revExecuteSql query

[Jez]

Great thanks. I think this would be useful in the documentation!

----- Original Message ----- 
From: "Jan Schenkel" <janschenkel at yahoo.com>
To: <use-revolution at lists.runrev.com>
Sent: Wednesday, July 09, 2003 8:35 AM
Subject: Re: revExecuteSql query


> --- 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
>