>Yes, this looks like will work. Especially I like it since I don't have to list all fields but do all (*). Thank you very much.
>
Listing all fields is better than do such extra processing.
>>Perhaps something like this?
>>
>>LOCAL lnRec
>>lnRec = RECCOUNT("caCursor")
>>INSERT INTO caCursor SELECT * FROM caCursor
>>*
>>SELECT caCursror
>>GO (m.lnRec)
>>SKIP
>>SCAN REST
>> * Replace your two fields with default/blank values
>>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.
If it's not broken, fix it until it is.
My Blog