Great thanks. I think this would be useful in the documentation! ----- Original Message ----- From: "Jan Schenkel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 8:35 AM Subject: Re: revExecuteSql query
> --- 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
