If I do a select query through QODBC the customer does not show up. If  I look in the quickbooks UI the customer shows up. If I edit the customer in the quickbooks UI and save changes the customer then shows up when doing a QODBC select.  How can I detect this problem and fix it using qodbc? 

I can assume that it is caused by an error or corruption when doing an insert into the customer table. All of our customers are input using a qodbc query. Only a very small percentage have had this problem.  Is there a way to trap for errors like a transaction would in SQL?

Thank you,

Not all edits to Customer rows are immediately detectable by the QODBC Optimizer. When a query isn't returning rows that should be there, try adding the UNOPTIMIZED tag like this:

Select * from Customer UNOPTIMIZED where BillAddressState = 'CA'

See: How do I setup the QODBC Optimizer? Where are the Optimizer options? for more on how the optimizer works.