On 06/05/2006, at 4:22, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]> 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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
