Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Environment vs Previously Opened Tables
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Data Environment vs Previously Opened Tables
Miscellaneous
Thread ID:
00223322
Message ID:
00223322
Views:
53
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???
Nigel B Coates
NBC Software Services
Dublin, Ireland.
eMail: Nigel.Coates@NBCSoftware.com
Next
Reply
Map
View

Click here to load this message in the networking platform