The following SQL statement worked fine in previous versions of Quickbooks but I cannot figure out why it is giving me an error???

Here is the statement :

sSQL = "INSERT INTO BillItemLine (VendorRefListID, RefNumber, ItemLineItemRefListID, ItemLineDesc, " & _
                  "ItemLineQuantity, ItemLineCost, Memo, TxnDate, TermsRefListID) " & _
                   "VALUES ('" & strVendorRefListID & "', '" & strRefNum & "', '" & strItemLineItemRefListID & "', " & _
                   "'" & strItemLineDesc & "', 1, " & dblItemLineCost & ", 'Bill created by Someone', {d '" & strTxnDate & "'},  '" & strTermRefListID & "')"

I've checked and double checked all of the variable and they look fine....any ideas

Don

Go the the QODBC Setup Screen and the Messages Tab, click on the Review QODBC Messages Log, scroll to the bottom and paste the error as well as the statement that produced the error here. One isn't much good without knowing the other.

Thanks for your speedy reply Tom, (I believe the last time we corresponded was a couple of years ago and you were right on top of things then too!)

Turns out I did a little more research on how  to read the trace log and determined that I had somehow electronically created a duplicate vendor and VendorRefListID...hence when the Bill entry tried to upload it was using the wrong VendorRefListID and would not load. It working fine now. ...but I'm still puzzled as to why the QODBC driver would let it happen.

When I checked the entry date & time of the duplicate Vendor they we 1/2 an hour apart so it was like one was held in Cache. Have you heard of this kind of problem before? ...I may have had the optimizer on at the time. It is working fine with the optimizer off.

Thanks again for your time....

Don