OT: First steps with Valentina ...

[Ruslan Zasukhin]

On 10/6/08 5:02 PM, "Tiemo Hollmann TB" <toolbook at kestner.de> 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]