Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I append and copy at the same time?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01499518
Message ID:
01499523
Views:
39
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform