>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.
Edward Pikman
Independent Consultant