data insertion in sqlite from android application
<blockquote>
  <p>Error inserting intDBServerUserID=3 strName=Fruit juice
  dtDBServerDatetime=2012-07-08 12:20:54 strDescription=Breakfast meal
  of day intMenuCategoryID=103 strMenuPath=/mnt/sdcard/menu/juice.jpg</p>
</blockquote>

<p>Table structure:</p>

<pre><code>CREATE TABLE tbl_menucategory (intMenuCategoryID INTEGER PRIMARY KEY NOT NULL, 
    strMenuCategoryPath TEXT NOT NULL, strName TEXT NOT NULL, strDescription TEXT NOT NULL, 
    intDBServerUserID INTEGER NOT NULL, dtDBServerDatetime NUMERIC NOT NULL)

CREATE TABLE tbl_menu (intMenuID INTEGER PRIMARY KEY NOT NULL, strMenuPath TEXT NOT NULL,
    intMenuCategoryID INTEGER NOT NULL, strName TEXT NOT NULL, decUnitPrice NUMERIC NOT NULL, 
    strDescription TEXT NOT NULL, intDBServerUserID INTEGER NOT NULL, dtDBServerDatetime NUMERIC NOT NULL)
</code></pre>

<p>I can insert data into tbl_menucategory  but when I try to insert data into tbl_menu, I get the above error.</p>

<p>I am inserting data using:</p>

<pre><code>db.insert(DatabseOpenHelper.TABLE_CATEGORY, null, caContentValues);
</code></pre>
