General information
Category:
Coding, syntax & commands
Title:
APPEND FROM Is there a file size limitation?
Good afternoon
I am moving records from a Clipper DOS application to VFP. While using
SELECT TargetTable
APPEND FROM SourceTable
the table data appends fine, until we process a table with more than 500,000 records. On this table, VFP does not copy any records, nor does it return an error message, just seems to skip over the append command.
I have it working with a Scatter to memvar, Insert inside a SCAN..ENDSCAN loop.
But I would like to know why the APPEND failed? Is there a file size limit on Appending table records? Note that this is not an append from Excel or on of the other documented exceptions.
Using VFP7/SP1. Clipper tables and VFP tables have identical fields, field length, etc.
For good measure I preprocess the Clipper tables to have a DOS 437 code page, open and close the tables, compare structures, etc. (natively, Clipper tables do not have a code page flagged). Indexes are not involved, because the VFP tables have different indexes, so this is a straight APPEND FROM without any conditions.
Thanks in advance for scratching my curiosity itch.
Don Lowrey
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only