Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can I append and copy at the same time?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01499518
Message ID:
01499528
Vues:
31
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform