Subject Re: [IBO] Slow SELECT in TIBOQuery - Default values
Author Svein Erling Tysvaer
Hei Bjørge!

At 09:26 04.02.2003 +0000, you wrote:
>Hi !
>
>I've had problems with slow initial selects with TIBOQuery. I located
>the problem in the routine where Default values are loaded from RDB$
>tables. This operation gives no meaning whatsoever in my application,
>as the query is ReadOnly.

I use TIB_ myself and don't know much about TIBO, but loading defaultvalues
does sound as if GetServerDefaults is set to true.

>- Is there a straightforward way to disable this slow operation when
>it's not needed (for now I've modified the code to exit this
>procedure), or do I need to implement a new property to control it ?
>- Is there a more sophisticated DBGrid out there that works with
>TIB_Cursor ? Or - is TIB_Cursor a bad idea for having a scrollable
>dataset displayed in a grid ?

Well, cursors are unidirectional, and most users prefer to scroll up as
well as down in a grid...

>If so, is there any advantages with using a TIB_Query over a
>TIBOQuery when result set is displayed in a grid?

For me, probably not much (I normally do only basic stuff). For you -
definitely! If I remember correctly (impression from other news groups),
you are the kind of programmer who digs deep, and utilizes whatever tool
you use to the utmost of its capasity. Once you get the hang of it, you
will love IBO, it's power and "simplicity" (once you know what you are
doing). E.g. the getting started guide does show you how to easily drop a
TIB_LookupCombo onto a grid, something which I suspect is considerably more
difficult if you use TIBO.

Svein Erling