When attempting to insert a multiline invoice I am getting a "ERROR [42000] [QODBC] Unexpected extra token: INSERT" message. I'm not quite sure why I'm getting this message and any help would be greatly appreciated.
Following is the INSERT statement that I'm sending to QODBC:
INSERT INTO "InvoiceLine" ("CustomerRefListID", "CustomerRefFullName", "RefNumber", "BillAddressAddr1", "BillAddressAddr2", "BillAddressCity", "BillAddressState", "BillAddressPostalCode", "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressCity", "ShipAddressState", "ShipAddressPostalCode", "PONumber", "ShipDate", "FOB", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineQuantity", "FQSaveToCache") VALUES ('80003E4A-1226088509', 'RPS_Test16168', '133', 'RPS_Test', '123 Test Ct.', 'Zionsville', 'IN', '46077', 'Kenny James', '134 W Raiders St', 'Gardena', 'CA', '90247', 'Test', {d'2008-10-13'}, '', '320000-1060714621', 'Transportation Charge 2095 Miles 2009 Acura RDX; 2006 Mazda MAZDA6 Salt Lake City IN to Gardena CA', 0.00, 1, 1)
INSERT INTO "InvoiceLine" ("CustomerRefListID", "CustomerRefFullName", "RefNumber", "BillAddressAddr1", "BillAddressAddr2", "BillAddressCity", "BillAddressState", "BillAddressPostalCode", "ShipAddressAddr1", "ShipAddressAddr2", "ShipAddressCity", "ShipAddressState", "ShipAddressPostalCode", "PONumber", "ShipDate", "FOB", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineRate", "InvoiceLineQuantity", "FQSaveToCache") VALUES ('80003E4A-1226088509', 'RPS_Test16168', '133', 'RPS_Test', '123 Test Ct.', 'Zionsville', 'IN', '46077', 'Kenny James', '134 W Raiders St', 'Gardena', 'CA', '90247', 'Test', {d'2008-10-13'}, '', '3A0000-1088464610', 'Oversize Charge', 0.00, 1, 0) |