There is a video in the RunRev learning center that covers one way to go through the records.
On 11/10/07, Len Morgan <[EMAIL PROTECTED]> 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 > >>> [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 > -- http://www.bluewatermaritime.com _______________________________________________ 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
