At 02:06 PM 18-09-02 -0300, you wrote:

>Hi,
>
>When i alter one field of a TIB_Query and call Post (property RequestLive =
>true and KeyLinks properly assigned) all fields of the query are posted to
>the database by the update sql generated.
>
>Is there a way to the TIB_Query post only the altered fields to the database
>? If so, is there any problem with this approach ?

InterBase/Firebird has a record-versioning architecture. In an update, the
old version of a record is completely replaced by the new version. Between
Post and Commit, both the old and new records exist in the database.

So no, there is no way to update individual columns.

Helen