That didn't work. The problem is upon saving the record of the grid, the record pointer isn't moved...
>
>if TableUpdate()
> MessageBox('Record saved successfully.')
>else
> * Get error with aerror()
> If (update conflict)
> MessageBox("Update conflict - another user just edited the record.")
> TableRevert()
> ThisForm.Refresh()
>endif
>
Thomas, it was defaulted at datasession = 1. I changed it to 2 and some other error messages came up (grid calling the table sort of thing), so it's back to 1. At least for now, to get this program out the door.
Grigore, thanks for the email, I will review it. I will look into OLDVAL(), CURVAL(), etc, as Mark uses that approach too.
Marcia, I know, just kidding. However, I did asked about what is the best "framework" should I set up and I am not there yet (boss rushed me to finish this program).
Seems to my understanding that I may best off with RLOCK and UNLOCK. That way, the record is LOCKed, thus other user can KNOW it is being editing at the same moment. This will then lead me to how to UNLOCK (and SAVE?) after so many minutes, for such "lunch lock". Also, would have to find a way to REFRESH the forms others may be viewing (instead hoping they exit the form and come back again).
My PC has been crashing like crazy yesterday, so hope this goes through. Thanks to all that helped. I am still trying to come to a result yet.
Chuck
Today is tomorrow's yesterday.