SQLIte, Result from revExecuteSQL

[Kay C Lan]

On 10/31/07, Dave <dave at looktowindward.com> wrote:
>
>
>
> When the command returns "the result" is set to 1. I've looked in the
> docs but it I can't seem to find anything that tells me what that means?
>
> Anyone know????


The command was successful, otherwise you'd have an SQL error message in
'the result'. I can't remember in this case if successful execution is
always 1 or an integer. So what you might be after:

revExecuteSQL theDatabaseID,mySQLCode
if (the result is not an integer) then
--add code to handle error message
end if

HTH