Reading from Database question

[Len Morgan]

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
>>> 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
>>>
>>>
>>
>> _______________________________________________
>> 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
>
> _______________________________________________
> 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
>
>