[V4RB 1] Creating Table from Cursor

[Ruslan Zasukhin]

On 9/3/06 3:05 PM, "Carsten Friehe" <rblists at online.de> wrote:

Hi Carsten

> Is it possible in V4RB 1.11 to create a new Table from a select, where
> there is a new field which has the recordnumber of the cursor?
> Are there temporary tables (in RAM?) possible wit V4RB 1.11?

Exists syntax 

    INSERT INTO T1 .. SELECT ...

 
> I am asking because I need to find a record inside a cursor. And these are
> huge cursors with 20000 and more records. I can search for the record in
> the tables and get a new cursor, that's no problem, but I have to display
> it with the data of the first cursor.

In fact copy of 20000 records can be much slower then do new search with
additional condition


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