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:
01499528
Views:
30
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform