Below is the *exact* SQL I am passing thru to QODBC and the *exact* error I get. Funny thing is, the customer record is still inserted into QuickBooks... but because I'm trapping errors my script, wisely, stops from continuing on to create a job for the newly created customer.
INSERT INTO Customer (Name, CompanyName, BillAddressAddr1, BillAddressAddr2, BillAddressAddr3, BillAddressCity, BillAddressState, BillAddressPostalcode, Phone, Fax, Email, Contact, TermsRefListID, AccountNumber, SalesRepRefListID, CreditLimit) values('Defense Towing', 'Defense Towing', 'Defense Towing', 'ATTN: Accounts Payable', '539 S. Frederick Ave.', 'Gaithersburg', 'MD', '20877', '301-527-9772', '301-527-9773', '', 'Veronica', '40000-1071691570', '116022', '20001-1145032751', 0.00)
HY106:[Microsoft][ODBC Cursor Library] Fetch type out of range |