Hi,

I have test some different solution but no one are good:

1) First test
a) SERVER: SP that send a POST_EVENT every 1% of job
b) CLIENT: in my DataModule i have a TIB_StoredProc for Execute
the SP
in my Form i put a TIB_Events for receive FireBird
Events
But when i call TIB_StoredProc->Execute() the Client Apps seem to be
Frozen and no other function are called. I try also to add a TTimer but
also the OnTimer event are not fired and my callback function are not
called.

2) Second test
a) SERVER: Select SP that return a row for any 1% of job
b) CLIENT: in my Datamodule i have put a TIB_Cursor: SQL = "Select *
from SP"
But when i call TIB_Cursor->First() the Client Apps seem to be Frozen
and no other function are called. Only when the SP finish its job the
application continue to run next instruction...

How can i do for make visible a progress bar in my client apps ???

Thanks,
Enrico Raviglione.



-----Messaggio originale-----
Da: Daniel Rail [mailto:daniel@...]
Inviato: lunedì 1 marzo 2004 14.18
A: 'IBObjects@yahoogroups.com'
Oggetto: Re: [IBO] SP and Client App Progress Bar


Hi,

At March 1, 2004, 06:30, Enrico Raviglione wrote:

> I have a lot of SP that make a lot of works for my Client App but i
> need to have a ProgressBar on my Client App for show to my users how
> much time they must wait. Which are the best method for do this work?
> Can i send an event (with POST_EVENT) any 1% of maked job or there are
> some better method?

Probably events are your only solution. I haven't used them for this
purpose, so you'll probably have to test that concept yourself. If it's
a selectable SP, you could have an extra return parameter for every row
that would give you that information and you could show the value of
that parameter.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



________________________________________________________________________
___
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