Outstanding! Thank you Trevor. It is all set.
All best Always
Fred
From: Trevor DeVore <[EMAIL PROTECTED]>
Reply-To: How to use Revolution <use-revolution@lists.runrev.com>
To: How to use Revolution <use-revolution@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
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution