API Style + Navigational Model // was Codebase Database API

[Ruslan Zasukhin]

On 8/8/06 11:36 PM, "Robert Sneidar" <bobs at twft.com> wrote:

> 3. A typical methodology of Visionpoint 2000 is to set an index
> (ordering the table), seek for a record, and then stepping through
> the table one record at a time, or issuing some kind of statement
> that uses REST (from the current point through the rest of the table)
> and a WHILE clause or FOR clause which are sometimes themselves
> complex expressions.

> But I am working with the actual table data
> directly, and so am not limited by the constraints of a cursor.

> To  switch to SQL would mean rewriting my data access methodologies  almost
> from scratch, and that through thousands of code module files.  The task is
> daunting.

Well, 

In Valentina 2 this methodology also is supported via

    ArraySet - that keep your ordered records
and
    Table.RecID = ArraySet.Nth item

We do not have like FoxPro - current filter on the whole table,
Because you can have only one such filter

Using ArraySets you are free to have several such sets in the same time..


--------------
>From other side:

I do not see where SQL way beat you:

    curs = db.SqlSelect( "SELECT * FROM T ORDER BY f5" )

Now you have virtually table sorted by f5 and its index.

Do your steps one by one ... Where is difference in methodology?


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