Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP 3.0b Storage-Problem
Message
De
26/02/1997 03:31:39
Elmar Werner
Regionales Rechenzentrum
Freiburg, Allemagne
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
VFP 3.0b Storage-Problem
Divers
Thread ID:
00022039
Message ID:
00022039
Vues:
80
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
Répondre
Fil
Voir

Click here to load this message in the networking platform