please help me
strdml="INSERT INTO order (Id,orderdate,type,comm,disc,consigneename,lcno,da te,amount,expdate,buyerorderno,buyerorderdate,curr ency,remarks,commagent,style,model,deldate,munit)V ALUES ('"&Id&"','"&orderdate&"','"&otype&"','"&comm&"',' "&disc&"','"&consigneename&"','"&lcno&"','"&ldate& "','"&lamount&"','"&expdate&"','"&buyerorderno&"', '"&buyerorderdate&"','"&bcurrency&"','"&remarks&"' ,'"&commagent&"','"&style&"','"&model&"','"&deldat e&"','"&munit&"')"
Why the syntax error comes with the inserion statement
|