Article View: borland.public.interbase.sql
Article #47Re: progress bar while executing a lengthy stored procedure
From: Isaac
Date: Fri, 23 May 2008 20:49
Date: Fri, 23 May 2008 20:49
23 lines
1873 bytes
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
Technical Details
Message-ID:
<48372de1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!news1.google.com!news.glorb.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> <48372b32$1@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 23:49:33 +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> <48359e10@newsgroups.borland.com> <48372b32$1@newsgroups.borland.com> In-Reply-To: <48372b32$1@newsgroups.borland.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 41.234.200.242 Message-ID: <48372de1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1211575777 41.234.200.242 (23 May 2008 13:49:37 -0700) Lines: 23 Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!news1.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail