SQL errors

[skipper]

Hello all!

I would like to have a little tip on how to test for "potential" errors running SQL commands.

eg. How to test if the CONN.OPEN("Data Base = " & AppPath & "\" & myDB) did not generated an error? (HD failure, disk full....)

Many thanks

Mimmo

 

[Erel]

You should use ErrorLabel to catch errors.
If the Open method fails then an error will be raised.
You can then show a message to the user that the sql connection has failed.

 

[skipper]

Hello Erel

many thanks for your quick reply!

My question was intended to understand when/if the SQL commands/funtions return any value (numerical/boolean or whatever else) to the calling routine as in:

Do While Reader.ReadNextRow = TRUE
...
Loop

In this case the ReadNextRow return a bool.

Thanks
Mimmo

 

[Erel]

You should check the SQL manual to find which methods return a value: http://www.b4x.com/help/sql/index.html

Generally speaking, methods throw errors and don't return a succeed / failure value.