Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append for few records
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00598952
Message ID:
00599162
Views:
16
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform