This insert stmt was generated by my VBScript program
"INSERT INTO InvoiceLine (
CustomerRefListID ,
RefNumber ,
InvoiceLineItemRefListID ,
InvoiceLineDesc ,
InvoiceLineQuantity ,
InvoiceLineServiceDate ,
FQSaveToCache )
VALUES (
' 30000-1074158302',
'2006W000171',
'10000-1074158529',
'00000058 Kg 049 Days 574-3004 0850',
2842 ,
{d'9/8/2007'} ,
0 )"
with the following errors
Microsoft OLE DB Provider for ODBC Drivers (384, 17) : [QODBC] Expected lexical element not found: <identifier>
1. Is my inset stmt correct????
2. How do i convert my SQL server date format '9/8/2007' to QB data format '2007-8-9' ???
Thanks
|