General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
I thank you for your intrest in this issue that I have. If you will permit I would like to explain just what my process is that causes the issue. I understand when two people are trying to update the same records but my case is slighty different(I think).
The form used is an input form with the pview in the dataenvironment. The main form drives a parent table(text boxes) and then a grid for the child table(pview). The form comes up in an empty state. The user types in a number and a new parent is added(insert into code) with a unique index number to the parent table. Items are then added to the grid, each with the unique index number of the parent and it's own unique index number(parent index number + item number). The form is closed firing the tableupdate().
All works pretty good except for a rare case like yesterday.
User 1 has his form filled out. There is evidence that a unique index was created for the parent table. There was no indication that anything was wrong. As far as it looks the pview was set with all the proper data to update the associated table.
Apparently at the same time.
User 2 opens the form creates the parent index. Selects a set of existing child records to use as a template(not even remotely connected to the above users input). The template records are insert into the pview.
Just guessing, at this time User 1 closes the form, the TableUpdate() fires. The child records are added with the proper parent index but the data is a copy of user 2's template records or what was currently in the pview of user 2.
Previous
Next
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