--- Jez <[EMAIL PROTECTED]> 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
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution
