Trying to return results from a query run on the database
Fred Giannetto
fgiannet at hotmail.com
Thu Nov 3 15:34:04 EST 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