Subject | Re: [IBO] SQL progress animation |
---|---|
Author | Robert martin |
Post date | 2010-03-23T02:32:54Z |
Sorry about the poor grammar on my previous email. What I meant to say
was...
Thanks for the heads up Geoff.
I am using TIBOQuery and have added a OnCallback event but it doesn't
trigger. I tried 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 retrieving records).
B) Where do I specify the nth record, I have left other settings as default.
Am I doing something wrong.
Rob
was...
Thanks for the heads up Geoff.
I am using TIBOQuery and have added a OnCallback event but it doesn't
trigger. I tried 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 retrieving 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 3:17 p.m., Robert martin wrote:
> 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
>>
>>
>>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>
>