Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table buffer mode and unbuffer mode in same program
Message
 
 
To
25/03/2004 15:38:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00889769
Message ID:
00889835
Views:
23
John,

Provided you have a primary key mechanism that works for both buffered and unbuffered use you shouldn't have any problems. The buffered users won't see any updates made anywhere else and the others won't see the changes made by the buffered table until you commit the changes with TableUpdate().

You can pretty effectively test this yourself by opening two seperate VFP sessions on your machine and running your code from both of them.

>What happens when I have the same table in one part of the program buffered (5) and in a different part of the program appending to the table in un-buffered mode. One user is using the table in a form and it's buffered and the other user is using the table in a different form un-buffered and they attempt to write to the table at the same time?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform