PxPlus User Forum
Main Board => Discussions => ODBC => Topic started by: eldonfsr on November 29, 2020, 08:13:50 PM
-
I have this sql statements to ejecute but send that error
INSERT INTO PO5_ReceiptEntryHeader ( vendornumber , ReceiptNumber , batchnumber , ReceiptType ,InvoiceNumber,InvoiceDate,InvoiceDueDate,PurchaseOrderNumber,TaxableAmount)
VALUES( 'CONT' ,'064509' , '00011' ,'I' ,' CAESC7796' ,'10/29/2020','11/28/2020','T11499 ',' 430.45')
i using c# i dont know if i have to use " or ' to in close value or is wrong date format .
please help me thanks.
-
The date format is 'YYYY-MM-DD'.
If you are using a version of the ODBC driver earlier then version 6 you have to use the escaped date format {d 'YYYY-MM-DD'}. Versions after 6 can use either the escaped format or just the date string.
The ODBC driver uses single quotes to enclose string values including date strings.