🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.sql
Article #32

Re: progress bar while executing a lengthy stored procedure

#32
From: 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
Technical Details
Message-ID: <48359e10@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail
References: <483557f1@newsgroups.borland.com> <48357398@newsgroups.borland.com> <483576b7@newsgroups.borland.com> <48358870@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,a7be48b6f259e6a5
X-Google-Attributes: gid114a0e,domainid0,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Thu, 22 May 2008 19:23:40 +0300
From: Isaac <no@no.com>
User-Agent: Thunderbird 2.0.0.14 (Windows/20080421)
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: progress bar while executing a lengthy stored procedure
References: <483557f1@newsgroups.borland.com> <48357398@newsgroups.borland.com> <483576b7@newsgroups.borland.com> <48358870@newsgroups.borland.com>
In-Reply-To: <48358870@newsgroups.borland.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 41.234.201.114
Message-ID: <48359e10@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1211473424 41.234.201.114 (22 May 2008 09:23:44 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder.news-service.com!news.isoc.lu!newsgroups.borland.com!not-for-mail