Another technique is to wrap your call in a try catch statement like so: try revExecuteSQL tDBID,tSQL catch theError answer "There was an error accessing the database" & cr & theError with "Cancel" or "Continue" if the result is "Cancel" then exit to top end try
Bob On Jul 7, 2012, at 2:25 AM, Malte Brill wrote: > 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 > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
