Calling for database error

Malte Brill revolution at derbrill.de
Sat Jul 7 05:25:10 EDT 2012


Hi Skip (and welcome to liveCode from me too...)

If you want to check if there was an error in the SQL statement you tried to execute, you will want to check "the result"

revExecuteSQL tDBID,tSQL
if the result is not a number then
  -- an error occurred
  answer the result & cr & tSQL
end if

The result is quite often your friend. The other friend you will stumble upon sooner or later is the variable "it". Makes sense to check those two.

Hope that helps,

Malte



More information about the use-livecode mailing list