Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP 3.0b Storage-Problem
Message
From
26/02/1997 03:31:39
Elmar Werner
Regionales Rechenzentrum
Freiburg, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
VFP 3.0b Storage-Problem
Miscellaneous
Thread ID:
00022039
Message ID:
00022039
Views:
78
We run VFP 3.0b with Windows 95
The following VFP-application consumes more and more storage and get therefore very slowly:

VFP-Form one to many to zero or many:
Access to Parent-table directly with VFP. (Table A). Navigation with SKIP.
Access to Childs with local Views.
Grid 1: local View (View B) with all records to the actual record in Parent Table A. Refresh View with REQUERY when the Parent Recordnumber changes.
Grid 2, 3 and 4:
1. Local Views (View C, D and E) with all records to the actual record in Parent Table A. Refresh Views with REQUERY when the Parent Recordnumber changes.
2. Local Views (View F, G and H) with all records to the actual record in View B. Refresh Views with REQUERY when the Parent Recordnumber or the recordnumber in View B changes. These Views are RecordSource of the Grids 2, 3 and 4.
With Debug and Testwindow I found out, that every REQUERY consumes 416 Bytes more Storage, which never will be released. ( with SYS(1016) immediately before and after REQUERY). So, every SKIP in Parent A needs about 3,000 Bytes more Storage.
With a testloop with 50 SKIPs for Parent A I measured 172000 Bytes more Storage after the loop.
Does anyone have an idea what causes this problem?

Thank before!
Elmar
Reply
Map
View

Click here to load this message in the networking platform