SQL Statement for AutoNumber Data Type
Posted: Thu Mar 04, 2010 5:45 pm
Hi,
I have an MS Access Database and the table has 3 columns / fields:
If I remove the first Field "SrNo" then it works fine. But as I need it and its data type being AutoNumber I canno provide any value for it. So, the following SQL Statement doesn't work if the SrNo field is included or I don't provide any vlaue for it .
Any solution?
I have an MS Access Database and the table has 3 columns / fields:
Code: Select all
Field Name Data Type
SrNo AutoNumber
Item Text
Remarks TextCode: Select all
$sql = "insert into MyTbl values" .
"('" . $V_Item . "','" .
$V_Remarks . "');";