General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Problem with TableUpdate()
Hi!
I have a stubborn problem with one of my forms. This form inherits from class frmdataentry. The form has three pages. In one of the pages I have a command button. Inside its valid method the following is executed:
--calls for a method that performs querying of an updateable view and then does a series of replacements in that view. The method also updates another table file.
--calls Thisform.UpdateBuffers() after calling the method above
This form runs perfectly when I run my application locally but when the app runs in a multiuser environment, tableupdate() inside Thisform.UpdateBuffers() fails giving me an error message that is 'Record in use by another'. But at the time that it is running, no one else is using the application. Also I am using optimistic buffering.
I need help here so badly. I am still troubleshooting the problem but I will appreciate immediate help from anyone who had this situation before.
Thanks,
Evelyn
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