Please help me in this querry
strdml="INSERT INTO order (Id,orderdate,type,comm,disc,consigneename,lcno,da te,amount,expdate,buyerorderno,buyerorderdate,curr ency,remarks,commagent,style,model,deldate,unit)VA LUES ('"&Id&"','"&orderdate&"','"&otype&"','"&comm&"',' "&disc&"','"&consigneename&"','"&lcno&"','"&ldate& "','"&lamount&"','"&expdate&"','"&buyerorderno&"', '"&buyerorderdate&"','"&bcurrency&"','"&remarks&"' ,'"&commagent&"','"&style&"','"&model&"','"&deldat e&"','"&unit&"')"

Errror is Syntax error in INSERT INTO statement.

Please post you question once only Ashwini - http://p2p.wrox.com/topic.asp?TOPIC_ID=38312

When inserting integer values only use double quotes. Single quotes are used for string values. I'm only guessing at this since you're trying to insert a value into the ID column which I'm hoping is an integer.

I don't know why you're inserting into an ID column when that value could be self-generating if you make this column an identity column, unless this is a foreign key. Its also probably not such a good idea to name a column ID in the first place. A much better approach would be to call that column OrderID to avoid any conflicts with reserved words.

Where you are inserting integers use:

" & ID & " and not '" & ID & "'

Hope this helps.

Richard