I am using the QODBC VB Demo to query the invoice Table in Quickbooks Desktop edition, but the query takes too long and it keeps running until the program crashes. I tried using TOP 10 (SELECT TOP 10 * FROM Invoice) but that doesnt help, is there a better way to do this? I need the data from the Invoice table, its a must.
Asked
Active
Viewed 129 times
0
-
Could you post text results of SHOW INDEX FROM invoice; and EXPLAIN SELECT SQL_NO_CACHE .....? – Wilson Hauck Dec 09 '17 at 15:01
-
I get no results, the query just keeps executing without returning any results. – Mario Landa Dec 11 '17 at 15:07
-
Since it crashes, could you post your error log? It may have some clues. – Wilson Hauck Dec 19 '17 at 14:42
-
It freezes the VB, there is no error log is there? – Mario Landa Jan 03 '18 at 17:11
-
OK, then post your my.cnf/ini from MySQL so we can help you determine if you have an error.log. You and we should see information naming the error log file. – Wilson Hauck Jan 05 '18 at 13:45