SQLIte, Result from revExecuteSQL

[Dave]

Hi,

The other database handlers return empty to mean ok. I had a problem  
executing a "CREATE TABLE" SQL statement and it returned a "1" and  
didn't work correctly. When I found and fixed the problem it then  
returned empty, so I am wondering if a similar problem exists here -  
it doesn't seem like the record(s) are being added correctly.

All the Best
Dave

On 31 Oct 2007, at 00:48, Kay C Lan wrote:

> 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
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution