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