If I post a record using a query then the values in fields are not what
is actually stored in database. This is because I have an update trigger
which modifies some fields. Shouldn't the query (TIBOQuery) be fetching
the updated version of record?

I can see correct values if I refresh the database, but this could be
costly if there the number of records in query are large.

Any suggestions?

Regards

Sandeep