Hi to All,

I used the ff. code inserting records on an MS SQL Server DB
and works fine, but under MS Access, it doesn't insert a new row of record?
Anything missing with my code below?

= SQLSETPROP(lnConnHandle, 'Transactions', 2)  && Manual transactions
= SQLEXEC(lnConnHandle, "INSERT INTO CUSTOMER (Customer_id, Barcode);
VALUES (@nTOTCUST, @cBarcode)")
 	=SQLCOMMIT(lnConnHandle)
 	= SQLDISCONNECT(lnConnHandle)
 	Messagebox("Customer Added!",0+64,"",1900)


I presided using ? on my memvar but still the same? Any Ideas...
Am I lacking something in my code?

Thanks...

Jojo R. dela Cuesta, B.Sc.
eConsultant, Programmer
Dalplus Technologies
http://www.dalplus.com