How to manage large SQL data sets - reply 2

[David Vaughan]

On 06/05/2006, at 4:22, <mfstuart at cox.net> <mfstuart at cox.net> wrote:

> Ruslan wrote:
> RevDataFromQuery -- is not good choice in your case.
>     it load everything into string of result
>
> You need to use RevQueryDatabase
> ======================================
> The successful use of this command returns an integer, not the data.
> How do I get the data into a table list on the card?


The integer is your cursor reference which you then use while moving  
back and forth through the record list. The list itself is not held  
in memory so you can handle any size of data set.

Read about it in the documentation, Mark. Look up revQueryDatabase in  
the Dictionary, and also revMoveToNextRecord to get a good set of  
links. Look up the User Guide in Section 8 on database use to  
understand use of cursors. In general, just type "database" into the  
Dictionary search field or into the search function in your PDF reader.

Ruslan is the progenitor of a fast database product, Valentina, which  
competes with MySQL and others, so he is being courteous in helping  
you with basic SQL. Some self-help might also be appropriate when the  
documentation is there, integrated with the product :-)

regards
David

>
> Thanx,
> Mark
> _______________________________________________
> 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