Check the memo file block size setting.
? Set("BLOCKSIZE")
The default is 64 bytes.
>Hi all,
>
>There is a developer here who is getting this strange occurance when a report is being run, both at runtime and in the VFP IDE. Basically, several SQL selects compile the data into temp tables an a few appends are preformed to another main temp table called W2. When the first SQL result set is appended to the W2 table, the w2.fpt bloats to over 1.2
GB on his PC.
>
>Everything works fine on my PC and the tester's PC. In fact, the memo file for the temp tables on ours only gets up to about 768 KB. Any ideas?
>
>His PC is also running on Win 2000, with VFP 6 SP5.
--sb--