Reading from Database question

[william humphrey]

There is a video in the RunRev learning center that covers one way to go
through the records.

On 11/10/07, Len Morgan <len-morgan at crcom.net> wrote:
>
> 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
> >
> >
>
> _______________________________________________
> 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
>



-- 
http://www.bluewatermaritime.com