At 01:45 PM 03-12-02 +1300, you wrote:

>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.

Well, there isn't any way you are going to see the results of committed
changes unless the row gets refreshed. Not sure what you mean by "refresh
the database" though. A dataset refresh is a close + open...

The native datasets can perform a selective refresh of changed rows in the
buffers if you called InvalidateBookmark on the modified rows. Not sure
whether you can access this from the iboquery...but you could try it via
InternalDataset.InvalidateBookmark.

The other question that your problem begs is: should you be performing
edits on large output sets?

Helen