Andreas Bednarek wrote:

> Uhh, does that mean TIBOTable.Open creates a view in the database? I would
> expect that for TIBOQuery... (I'm not very experienced how exactly views
> work so I hope I don't mess the terms now...) However, it seems that things
> are getting complicated, as I said in my previous post, refresh over a large
> dataset (view?) drastically decreases performance so I probably can't use
> it... :-(

TIBOTable is just a simple wrapper. You SHOULD be able to use TIBOQuery
in place of it, just create the SELECT xxx FROM yyy using the IBO tools.
This can then be 'filtered' as required to reduce the number of records
looked at. IBO will normally buffer what is has already seen, with
RefreshKeys basically marking all records to be reloaded from the
database when IBO needs to use them.
( Helen explains this better then me :( )

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services