On 22 Apr 2003 at 21:19, Geoff Rees wrote:

> [using IB6.0x]. We have the situation that often the same record
> is selected by 2 computers at approx the same time. One computer
> is used to update 2 fields, the other computer another 2 different
> fields.

What SQL query you use to update fields? What component set?

If you use something like UPDATE table SET field1=?, field2=?...
and rewrite all fields of table... you are in troubles. Use run-time
generated SQL sentences.

>What is the solution? Can you lock certain fields?

AFAIK you can keep unchanged fields untouched.

SY, Dimitry Sibiryakov.