Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to have DB_KEYANDMODIFIED in native table buffering?
Message
From
29/12/2000 20:11:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
How to have DB_KEYANDMODIFIED in native table buffering?
Miscellaneous
Thread ID:
00458018
Message ID:
00458018
Views:
51
Hi,
I am using native table buggering - 5 in my multiuser application.
My table (customer) consists of 10 fields. I allow user to keyin, update and etc customer details in my customer form. There are 7 fields only which are allowed to be updated only shown in customer form. The others 3 fields will not be shown (used for other accumalate purposes).
I got a Error - Update conflict when my application update. The steps to reproduce are as the following:

1. User A search for customer details and update certain updatable fields
2. Before user press "save" button to save changes, that was a changes by other user for that 3 fields for accumalate purposes.
3. When User A press "Save" to sace changes, VFP return update conflict.

Any way to have same featuce of view (DB_KEYANDMODIFIED )? Since my application only REPLACE 7 fields instead of 10, how to prevent update conflict and "order"
VFP just check conflict for that 7 fields instead of 10??

Thank you
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...
Next
Reply
Map
View

Click here to load this message in the networking platform