Perhaps something like this?
LOCAL lnRec
lnRec = RECCOUNT("caCursor")
INSERT INTO caCursor SELECT * FROM caCursor
SELECT caCursror
GO (m.lnRec)
SKIP
SCAN REST
ENDSCAN
>Hi,
>
>The title of the thread does not convey what I am trying to do. I just could not put it all in a sentence.
>
>Here is what I am trying to do.
>
>I have a cursor filled with a Cursor Adapter object that has so many records (practically from 1 to 10).
>I want to insert new records into the cursor for each existing record and copy all fields except two 2 fields: PK column/field and another field. I was thinking about using SCAN - ENDSCAN but if I keep adding a record on each loop of the SCAN, I will never get out of the SCAN loop.
>
>Any other suggestions, please? TIA.