General information
Category:
Forms & Form designer
Title:
VFP 3.0b Storage-Problem
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
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