Subject Re: [IBO] SQL progress animation
Author Robert martin
Thanks for the heads up Geoff.

I am TIBOQuery and have added a OnCallback event but it doesn't
trigger. I tryied changing the CallbackInc from -1 to 0 and 1 but still
no go. The event doesn't trigger. It says it is triggered every nth
record fetched so

A) doesn't look like it will do what I want, the bulk of processing is
running the Query (not preparing or processing records).
B) Where do I specify the nth record, I have left other settings as default.

Am I doing something wrong.


Rob


On 23/03/2010 12:44 p.m., Geoff Worboys wrote:
>> What we want is a simple way of displaying an animation while
>> an SQL is being processed. In this particular case the SQL
>> is being built in code and results are being displayed in a
>> DB aware grid. As the delphi animation components are no
>> longer threaded they dont work. We cant put the db Query in a
>> thread becuase we want to display the results in a db grid.
>>
> TIB_Dataset.OnCallback (which means TIB_Cursor and TIB_Query)
> have it). See also the various Callback* properties that allow
> you to adjust callback processing.
>
> TIBODataset has OnCallback too... but see the help for how
> to use it.
>
>
>
>> Any suggestions would be appreciated.
>>
> You can see it in use in the source for form IBF_DataPump.
>
>
> Note that this can only give feedback events between record
> fetches, it cannot give feedback events during a long prepare.
> That is: In some very complicated selected procedures and the
> like it can the prepare that takes a long time and during the
> prepare your interface will appear frozen and callback can do
> nothing about it.
>
> HTH
>
>