On 10/6/08 5:02 PM, "Tiemo Hollmann TB" <[EMAIL PROTECTED]> wrote:
Hi Tiemo, > I am just making my first steps with valentina, switching from SQLite. So > far everything works fine. I created my db, tables, filled the tables with > datas, and now I just stuck to get the data out of the DB, because I am not > a SQL expert. With SQLite I coded: > > put revdb_querylist(,,gConID,tSqlSting) into tList > > to get my selected datas as a sting. With Valentina I tried: > > put VDataBase_SqlSelect(gDBRef, tSqlSting) into tList > > and I get a cursor back. Now I am missing the command to get the data from > this cursor. Or am I on the wrong lane? In V4REV API Reference.pdf you can find description of class Vcursor. It have many methods as NextRecord(), Last, First... PrevRecord() GetField() It also have method as GetRecordsAsString(), so you will get back all records of cursor as single string with the specified field and line delimiters. And as I remember exists method similar to revdb_querylist() which return string of records without cursor at all. -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution