Calling for database error

[Malte Brill]

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