[V4RB 1] Creating Table from Cursor

[Ruslan Zasukhin]

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

Hi Carsten,

>>    INSERT INTO T1 .. SELECT ...
> 
> I found this before too, but there is one problem. Can I have the rownumber
> of the cursor in this new table as a field?

Not recID but row number ???
 
I think no

Possible 

    INSERT INTO T1(f1,f2,f3,) .. SELECT recid, ...
                   


>> In fact copy of 20000 records can be much slower then do new search with
>> additional condition
> 
> That is clear, but the problem is that the user should still see all
> records. I only want to jump to a specific record that the user has
> searched.


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