invalid Operand for operator <Assigment>

Started by eldonfsr, November 29, 2020, 08:13:50 PM

Previous topic - Next topic

eldonfsr

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.




Devon Austen

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.
Principal Software Engineer for PVX Plus Technologies LTD.