revExecuteSql query

[Sarah]

As well as reporting "revdberr" if there is a problem, the result of 
revExecuteSQL will contain the number of rows affected if it is 
successful.

Sarah

On Wednesday, July 9, 2003, at 05:42  pm, Jan Schenkel wrote:

> --- Jez <jbradshaw at blueyonder.co.uk> wrote:
>> Is there any way to get the result of a
>> revExecuteSql statement? I'm getting
>> no indication of error when the sql has a problem,
>> and no indication of the
>> number of rows affected when it runs OK.
>>
>> (I'm accessing a Microsoft Access database via ODBC)
>>
>
> What do you get when you insert :
>   answer the result
> after your call to the 'revExecuteSQL' command ?
>
> You can also use the 'revdb_execute()' function ; the
> result of the call will then be put in the special
> 'it' variable.
>
> In fact, most of my code looks like :
>   put revdb_execute(tConnectionID, tSQLQuery) \
>       into tQueryResult
>   if char 1 to 8 of tQueryResult is "revdberr" then
>     answer error tQueryResult
>     exit MyHandler
>   end if
>   -- if everything went fine, proceed...
>
> Hope this helped,
>
> Jan Schenkel.
>
> =====
> "As we grow older, we grow both wiser and more foolish at the same 
> time."  (La Rochefoucauld)
>
> __________________________________
> Do you Yahoo!?
> SBC Yahoo! DSL - Now only $29.95 per month!
> http://sbc.yahoo.com
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>
>