> Does this mean a single field update, results in an
> update of the entire Row? For some reason I thought
> TIB_Query only issued an update for Field A in
> prior versions.
>
> How can I force the internal generation of a SQL
> update for the changed/updated fields only ?

Hans,

When you do this:
SELECT * FROM ATABLE

and set RequestLive to true then IBO will generate insert/edit SQL
that updates ALL updatable fields returned from the select.

To only update changed fields IBO would have to prepare new statements
with every insert/update - and it is prepares where the performance
hits are experienced.

If you only want certain fields to be updated then you can...

* Change your select to only return the
needed fields (recommended anyway)
OR
* Set all other fields to ReadOnly
OR
* Write your own EditSQL statement


I am not sure what your concern is over updating the entire row. The
only impact of any significance this has is that server based defaults
will not be applied during an insert (so use the TIB_Query
DefaultValues property). There will be almost no difference in either
network or server performance in updating a single field versus the
entire row.


HTH

Geoff Worboys
Telesis Computing