Subject Re: [IBO] SQL progress animation
Author Geoff Worboys
> 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

--
Geoff Worboys
Telesis Computing