General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating tables using remote views !!!
Hi,
I am working on a multi user system which uses remote views to update tables.I am running the following code to get a unique number from a table, and then update that number with the new uniwue one. when three or more users are running this program at the same time, only one of the users is able to update the number properly, the others get stuck in the loop and get a 'update conflict' error when hitting the tableupdate() code.
Any ideas ??
updatedok=.f.
do while updatedok=.f.
=requery("remote")
replace remote.no with remote.no+1
updatedok=tableupdate()
if updatedok=.f.
=tablerevert()
unlock all
endif
loop
enddo
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