Hi Dave,
Everything you need to know is in the database section of the PDF
documentation and the Dictionary (Help->Documentation).
The basic process is:
1) Establish a connection to the database
2) Send your query and get a record set ID
3) Use the record set ID above and revMoveNextRecord... to go through
each record
4) When you reach the last record, close the connection to the database.
len
Dave wrote:
Hi,
Do you mean the PDF? I looked in their, doesn't really tell you much!
I have a big database and I don't want to have to read it all in one
hit. This is such a simple thing to want to do, just read each record
from the database! Do you think I can find out how to do it? lol
All the Best
Dave
On 10 Nov 2007, at 13:32, Len Morgan wrote:
Hi Dave,
It sounds to me like you need to dive into the section of the Rev
manual that explains database commands. There ARE NO SQL commands to
read one record at a time. You need to preform the query, then use
Rev commands to work with them one at a time.
len
Dave wrote:
Hi All,
I am trying to read all records sequentially from a SQLIte database,
basically I just want a loop that gets one record, process the
record and then move on to the next. I can't seem to get my head
around the SQL to just get one record at a time!
Any suggestions greatly appreciated!
All the Best
Dave
_______________________________________________
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
_______________________________________________
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
