Sarah
On Wednesday, July 9, 2003, at 05:42 pm, Jan Schenkel wrote:
--- 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
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
