Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append for few records
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00598952
Message ID:
00599162
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
>Nadya,
>
>The FOR clause on APPEND FROM acts on the source of the append not the target.

It's only true if the source is a table. Otherwise FOR is performed on the target table and the record in the memory right before it is inserted into target table. Here's the test to confirm that
CREATE TABLE temp ( c1 C(32))
APPEND FROM ( HOME()+"hlp2fox.prg") SDF
? _TALLY    && 85 records appended
ZAP
APPEND FROM ( HOME()+"hlp2fox.prg") SDF FOR RECNO() < 10
? _TALLY    && 9 records appended
ZAP
APPEND FROM ( HOME()+"hlp2fox.prg") SDF FOR RECCOUNT() < 10
? _TALLY    && 10 records appended
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform