Board index » delphi » how can I get the the percentage of the query process - correction

how can I get the the percentage of the query process - correction

Hi !
I akesd the following question a few days ago :
I have SQL statments that it takes a long time (maybe few minutes) to get
the results.
I want to make a progress bar in order to represent the time it going to
last.
My question is how can I get the percentage of the query process (during the
process)?

I have got an answer from David M:

You must register a BDE callBack of type cbGENPROGRESS.

but I do not have any experience with this particular stuff.
I have found some information in the BDE API Help documentation at
'DbiRegisterCallBack' page.
I afraid to admit that I have got lost.
My basic questions are :
1) how to call BDE API function ?
2) how to register a BDE callBack ? (maybe by using
TBDEDataSet.ConstraintCallBack mothod??)
Detailed example would be great!
thanks in advance!!

 

Re:how can I get the the percentage of the query process - correction


Quote
>but I do not have any experience with this particular stuff.
>I have found some information in the BDE API Help documentation at
>'DbiRegisterCallBack' page.
>I afraid to admit that I have got lost.
>My basic questions are :
>1) how to call BDE API function ?
>2) how to register a BDE callBack ? (maybe by using
>TBDEDataSet.ConstraintCallBack mothod??)
>Detailed example would be great!

You picked one of the most complex topics to deal with
I suggest you start with this TI
http://www.inprise.com/devsupport/delphi/ti_list/TI3103.html

You can find some other examples for DbiRegisterCallback by using the Search on
the Inprise website for DbiRegisterCallback
However beware you are sitll going to find it very tough going and even if you
get it hooked up and working you will find that a query doesn't provide much in
the way of progress results.  at best you will get information at two or three
points along the way.  Do a query in the database desktop to see what kind of
progress it actually sends back.

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads