>>hi to all,
>>
>>how can I check update conflit on a client/server app ?
>>
>>to explain:
>>- for update conflit I mean when the users A and B load the same record, does some modifies, then A save modifies, now if B save there is a update conflit
>>- in a normal VFP app, before to do the TableUpdate() I check the update conflit testing OLDVAL(myfield, mytable) and CURVAL(myfield, mytable), how can I do this on a C/S app ? I don't want to lock a record when I load it.
>>
>>TIA
>>Renato
>
>Look at 'SQL Where' selection on 'Upadate Criteria' page of View Designer. This is exactly what will be checked automatically when you TABLEUPDATE() remote view.
Sorry I've missed another information.
To update my table in C/S app I don't use the TableUpdate() for the view, but I use the pass-through method so I do a SQLExec() with a "UPDATE .... WHERE ..." command. I don't know why I haven't use the tableupdate() of views, maybe to minimize the information to trasmit on the Wan, maybe can you say me the good and bad thing of the pass-through and tableupdate view methods ?
TIA
Renato