Any Error Handling using SQL available?

[henryp]

Im using the code found here for sql connections and queries: http://www.autoitscript.com/forum/index.php?showtopic=47585

Statement: "Select * from Test"

If "Test" exists, then it will return the results.

If "Test" does not exists, then autoit will crash on me. Ive tried using the @errors from the comments but they do not return anything since Autoit crashed. So is there a way for me to capture those errors or make autoit skip those sql commands?

Thanks!

[jchd]

Which are you using: SQLite UDF or some ADO layer?

Anyway, you didn't post any code for us to chew, so don't expect a useful answer!

But since you say that AutoIt "crashes", I suspect (using the forum crystal ball) that you're using ADO without a COM error handler (a no-no). Querying a table which doesn't exist is a design overlook in all cases. You should use a way to check for table existence before querying it. How to do so depends on your context, which we have no clue what it is.