progress bar while executing a lengthy stored procedure

Thread View: borland.public.interbase.sql

7 messages

[T] Back to Threads [V] Tree View [G] Group Articles

7 total messages Started by Isaac Thu, 22 May 2008 11:24

#24

Author: Isaac
Date: Thu, 22 May 2008 11:24

5 lines
1036 bytes

Hello,
I wonder if I can display from my app a progress bar or a busy status 
while a for..select is executing.

Thanks

Re: progress bar while executing a lengthy stored procedure

#26

Author: Martijn Tonies
Date: Thu, 22 May 2008 13:26

23 lines
1779 bytes

Hi,

> I wonder if I can display from my app a progress bar or a busy status
> while a for..select is executing.

It depends what you mean by "progress". The notion of "progress" requires
some kind of feedback and knowing how long it will take. If you call
a Stored Procedure, that's just a single operation (even though internally
it does a whole lot more) from a client-side programs point of view.

Why not display an animation that shows "waiting" or something?


-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Re: progress bar while executing a lengthy stored procedure

#27

Author: Isaac
Date: Thu, 22 May 2008 13:35

2 lines
1102 bytes

ok, but how I know if the procedure has finished ?  without store in a 
temp table if possible

Re: progress bar while executing a lengthy stored procedure

#29

Author: Bill Todd [TeamB]
Date: Thu, 22 May 2008 14:51

14 lines
1551 bytes

Isaac wrote:

> ok, but how I know if the procedure has finished ?  without store in
> a temp table if possible

A call to a stored procedure is blocking. The call will not return
until the stored procedure has finished execution. To execute a stored
procedure and display some entertainment for the user while the
procedure is executing you must execute the procedure in a background
thread and display whatever you are going to display in the
application's main thread.

-- 
Bill Todd (TeamB)

Re: progress bar while executing a lengthy stored procedure

#32

Author: Isaac
Date: Thu, 22 May 2008 16:23

17 lines
1625 bytes

Bill Todd [TeamB] wrote:
> Isaac wrote:
> 
>> ok, but how I know if the procedure has finished ?  without store in
>> a temp table if possible
> 
> A call to a stored procedure is blocking. The call will not return
> until the stored procedure has finished execution. To execute a stored
> procedure and display some entertainment for the user while the
> procedure is executing you must execute the procedure in a background
> thread and display whatever you are going to display in the
> application's main thread.
> 
ok, FIBPLus TpFIBStoredProc component has before execute and after 
execute events I can also use that.

Thanks

Re: progress bar while executing a lengthy stored procedure

#48

Author: WillR
Date: Fri, 23 May 2008 20:41

24 lines
1826 bytes

Isaac wrote:
> Bill Todd [TeamB] wrote:
>> Isaac wrote:
>>
>>> ok, but how I know if the procedure has finished ?  without store in
>>> a temp table if possible
>>
>> A call to a stored procedure is blocking. The call will not return
>> until the stored procedure has finished execution. To execute a stored
>> procedure and display some entertainment for the user while the
>> procedure is executing you must execute the procedure in a background
>> thread and display whatever you are going to display in the
>> application's main thread.
>>
> ok, FIBPLus TpFIBStoredProc component has before execute and after 
> execute events I can also use that.
> 
> Thanks

Are you using Firebird?

-- 
Will R
PMC Consulting

Re: progress bar while executing a lengthy stored procedure

#47

Author: Isaac
Date: Fri, 23 May 2008 20:49

23 lines
1873 bytes

WillR wrote:
> Isaac wrote:
>> Bill Todd [TeamB] wrote:
>>> Isaac wrote:
>>>
>>>> ok, but how I know if the procedure has finished ?  without store in
>>>> a temp table if possible
>>>
>>> A call to a stored procedure is blocking. The call will not return
>>> until the stored procedure has finished execution. To execute a stored
>>> procedure and display some entertainment for the user while the
>>> procedure is executing you must execute the procedure in a background
>>> thread and display whatever you are going to display in the
>>> application's main thread.
>>>
>> ok, FIBPLus TpFIBStoredProc component has before execute and after 
>> execute events I can also use that.
>>
>> Thanks
> 
> Are you using Firebird?
> 
Actually both FB and Interbase

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads