Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Environment vs Previously Opened Tables
Message
De
27/05/1999 10:08:26
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00223322
Message ID:
00223430
Vues:
26
>Can anybody answer this:
>
>If you open a table in a form's data environment and the table is already open, which copy of the table is used?
>
>We seem to have a problem with buffering here (all forms are default data session - horrifying, but that's how the app was designed!). The form's data environment opens table 'x' with BufferModeOverride of 1 (use form default). Form BufferMode=0 (no buffering). I have put a trap in the form (save button) to kill the process if buffering is on. This trap has been hit!
>
>Buffering is set to 5 for table 'x'!!! I have discovered a previously visited form has CursorSetProp of 5 for table 'x' but it also has autoclose .T. in it's data environment.
>
>Let's say the table was opened earlier in operations. Does the data environment override existing open tables??? Or CAN IT???

If a form using the default datasession contains a table that is already opened, another copy IS NOT opened. The form uses the copy that is already there. If the cursor in the form's DE is set to use a different buffering setting than the table already opened, the form changes the already opened table's buffermode to suit its needs. The form will NOT close the table if it did not open it, but is also not polite enough to change the buffermode back to the way it found it.
Erik Moore
Clientelligence
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform