Hi Jojo,
Try:
nTOTCUST=0
cBarcode="test"
= SQLEXEC(lnConnHandle, "INSERT INTO CUSTOMER (Customer_id, Barcode);
VALUES (?nTOTCUST, ?cBarcode)")
MartinJ
>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...
