>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.
insert into (CA.Alias) (field1, field2, ...) select field1, field2, .. from (CA.Alias)
If it's not broken, fix it until it is.
My Blog