General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Thanks for replying, sorry that I didn't state clearly in my first posting.
>Ok, I'm using optimistic table buffering for all tables and the problem occurred during adding of new records.
>
>Example, user_A added 3 records and the primary key value is "1234", and user_B also added 3 records and primay key value is "1235".
>
>After saving, we realise that although user_A still have 3 records under key-value "1234", but the third record's data belong to those of user_B whose key value is "1235". Record 1 and 2 for user_A ok. User_B entry all ok without error.
>
>I'm using VFP 5.0a with SP3 running on a mix of Win95b and Win98. Thanks for the help. Any idea how is that possible so???
>
>
>>Are you using optimistic or pessimistic buffering? Are they adding or modifying the record?
>>
>>>When 2 users running the same form do data entry together over a network, somehow they will overwrite a record of each other. The field of the primary key is not changed, but all other fields are over written.
>>>
>>>All tables are already set to table buffering.
>>>Running on NT Server 4.0 SP5.
>>>No problem if only 1 user data entry.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only