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