Trying to return results from a query run on the database

Fred Giannetto fgiannet at hotmail.com
Thu Nov 3 14:34:04 CST 2005


Outstanding!  Thank you Trevor.  It is all set.

All best Always
Fred


>From: Trevor DeVore <lists at mangomultimedia.com>
>Reply-To: How to use Revolution <use-revolution at lists.runrev.com>
>To: How to use Revolution <use-revolution at lists.runrev.com>
>Subject: Re: Trying to return results from a query run on the database
>Date: Thu, 3 Nov 2005 12:17:48 -0800
>
>
>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
>
>
>_______________________________________________
>use-revolution mailing list
>use-revolution at lists.runrev.com
>Please visit this url to subscribe, unsubscribe and manage your 
>subscription preferences:
>http://lists.runrev.com/mailman/listinfo/use-revolution





More information about the use-livecode mailing list