Subject Re: [IBO] Slow SELECT in TIBOQuery - Default values
Author Helen Borrie
Bjørge,

At 09:26 AM 4/02/2003 +0000, you wrote:

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

Agreed, it would be nice to be able to disable this where it's not needed.


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

You could. It's what I would do if it was getting to be a problem with my
read-only datasets. I wouldn't want to disable it in hard code.

>- Is there a more sophisticated DBGrid out there that works with
>TIB_Cursor ?

There is TIB_CursorGrid, which is a simple data-aware descendant of
TStringGrid. Sophisticated? not. It's just a visual container for
displaying each row in turn as it arrives into the application.

>Or - is TIB_Cursor a bad idea for having a scrollable
>dataset displayed in a grid ?

Yes, it's a unidirectional cursor that is not buffered in the client at all
(except the current row buffer). Its typical use is for stepping through a
dataset, e.g. when populating a non-data-aware control. In fact, the main
reason we have TIB_CursorGrid at all is to provide a container for
TIB_Cursor rows as they are stepped through (see this working in the Cursor
tab of the IB_SQL tool..)

There is no such thing as a scrollable dataset in IB/FB (yet). IBO's
scrollable TIB_BDataset (an engineering miracle) spawns TIB_Query and
TIB_StoredProc.

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

I consider so. TIBOQuery is designed to emulate the VCL TQuery. With
TIB_Query, you use TIB_Grid and all of the other native controls, giving
you control support to TIB_BDataset's ordering and horizontal dataset
refinement techniques.


>BTW, is it possible to post messages to this group...
>- directly from email app ?

Yes. Post to ibobjects@yahoogroups.com using the same email address as you
used to subscribe to the list.

>- through atkin news server ?

Yes. But, if you post through the news interface using a different email
address, your messages will evaporate into the ether.

Helen