Subject | Re: [IBO] Slow SELECT in TIBOQuery - Default values |
---|---|
Author | Helen Borrie |
Post date | 2003-02-05T06:26:37Z |
Bjørge,
At 09:26 AM 4/02/2003 +0000, you wrote:
read-only datasets. I wouldn't want to disable it in hard code.
TStringGrid. Sophisticated? not. It's just a visual container for
displaying each row in turn as it arrives into the application.
(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.
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.
used to subscribe to the list.
address, your messages will evaporate into the ether.
Helen
At 09:26 AM 4/02/2003 +0000, you wrote:
>I've had problems with slow initial selects with TIBOQuery. I locatedAgreed, it would be nice to be able to disable this where it's not needed.
>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.
>- Is there a straightforward way to disable this slow operation whenYou could. It's what I would do if it was getting to be a problem with my
>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 ?
read-only datasets. I wouldn't want to disable it in hard code.
>- Is there a more sophisticated DBGrid out there that works withThere is TIB_CursorGrid, which is a simple data-aware descendant of
>TIB_Cursor ?
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 scrollableYes, it's a unidirectional cursor that is not buffered in the client at all
>dataset displayed in a grid ?
(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.
>I consider so. TIBOQuery is designed to emulate the VCL TQuery. With
>If so, is there any advantages with using a TIB_Query over a
>TIBOQuery when result set is displayed in a grid ?
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...Yes. Post to ibobjects@yahoogroups.com using the same email address as you
>- directly from email app ?
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