Trying to return results from a query run on the database

[Trevor DeVore]

On Nov 3, 2005, at 11:56 AM, Fred Giannetto wrote:

> Thank you Trevor,
>
> The function executes but only returns the Database ID connection  
> instead of the results of the query.  Anyone know why it would be  
> doing this?

revQueryDatabase returns the cursor id returned from the database.   
You then have to use:

revCurrentRecordIsLast
revDatabaseColumnNumbered/revDatabaseColumnNamed
revMoveToNextRecord
etc

to navigate through the results.

revDataFromQuery will return the results without the need of using a  
cursor.


-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com