This is actually an expected result. There is nothing wrong with the SQL used to send an update to the server which is why .T. was returned. What has actually happened is NO matching records were found to update, and the SQL executed just fine. However, having no records updated by the command will not cause the return value to be false.
>I made a test with CA using 2 instances of VFP.
>
>This is the sequence of the actions:
>Instance 1) open Form and get record 5 from the server
>Instance 2) open Form and get the same record 5 from the server
>Instance 2) Delete this record and clik the save button
>Instance 1) Change some fields in the form and clik the save button
>
>The instance 1) returns .T. when updating the record by clicking Save button
>But the record was deleted in the server before by instance 2)
>
>Save button code:
>
>x = Tableupdate()
>IF x <> .T.
> Aerror(aMatrizErro)
>....show error message
>ENDIF
>
>I expected an .F. as return in this case.
>What Im missing ?
>Does someone has a workaround for this ?
>
>Any advice is welcome...
>
>Peter
Mark McCasland
Midlothian, TX USA