Subject Re: [IBO] Problem with TIBOQuery
Author Hans
You are correct, I mistyped JOIN , it should be UNION for different tables

> btw:
> >> What did FlushBuffers do with an IB (or Fb) database?

According to Delphi Docs
Posts all changes that have been written to the record buffer.

procedure FlushBuffers;


Call FlushBuffers to cause the dataset to post all pending changes to the
database, .including ...any cached updates. Use FlushBuffers instead of
...CheckBrowseMode if it is important that cached record buffers are posted.
So I put a procedure together that hopefully does about the same :)