Article View: borland.public.interbase.sql
Article #48Re: progress bar while executing a lengthy stored procedure
From: WillR
Date: Fri, 23 May 2008 20:41
Date: Fri, 23 May 2008 20:41
24 lines
1826 bytes
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
Technical Details
Message-ID:
<48372b32$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<483557f1@newsgroups.borland.com> <48357398@newsgroups.borland.com> <483576b7@newsgroups.borland.com> <48358870@newsgroups.borland.com> <48359e10@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: Fri, 23 May 2008 14:41:40 -0600 From: WillR <willrNo.Spam.pmccl.noSpam.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> <48359e10@newsgroups.borland.com> In-Reply-To: <48359e10@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 189.174.196.62 Message-ID: <48372b32$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1211575090 189.174.196.62 (23 May 2008 13:38:10 -0700) Lines: 24 Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!newshub.sdsu.edu!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail