Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Fpt bloat during report
Message
From
29/04/2002 11:20:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Fpt bloat during report
Miscellaneous
Thread ID:
00650420
Message ID:
00650420
Views:
45
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.


Thanks,

- Brian


VFP6 SP5, VFP8 SP1, VFP 9 SP 1 and Win XP SP 3 (unless otherwise specified)


www.wulfsden.com
Next
Reply
Map
View

Click here to load this message in the networking platform