Hello! i'm trying to show the progress of an SP on a Delphi progress bar... but the
onProgress event is not called/started soo i can't get the PercentDone value...

my basic SP code (only for testing):
-----------------------------------------------------------------------
PROCEDURE "UpdateState" (IN "nroRep" INTEGER)
BEGIN

  DECLARE incremento INTEGER DEFAULT 0;
                                 
  START TRANSACTION ON TABLES Pessoa;
  WHILE (incremento < nroRep)  DO
     EXECUTE IMMEDIATE 'INSERT INTO "Pessoa" VALUES (1111111,''2222222'')';
     SET incremento = incremento + 1;   
     SET PROGRESS TO TRUNC(((incremento/nroRep)*100));
     SET LOG MESSAGE TO 'Introdução número: '+CAST(incremento AS VARCHAR);
  END WHILE;                                                                         
  COMMIT;
END
-----------------------------------------------------------------------



And the code on Delphi:
-----------------------------------------------------------------------
procedure TForm1.EDBStoredProc1Progress(Sender: TObject; PercentDone: Integer;
 var Continue: Boolean);
begin
 PGB.Position := PercentDone;
end;
-----------------------------------------------------------------------


What is missing? Thank you for your help!

Tiago


I don't think you can, its the same as with scripts. What you need to do is use the OnStatusMessage event and SET STATUS MESSAGE TO <Message> in the SP. It does mean that you can't have a progress bar. This    EXECUTE IMMEDIATE 'INSERT INTO "Pessoa" VALUES (1111111,''2222222'')'; is one statement so the best you can do is one message before and one after.

Roy Lambert [Team Elevate]

Tiago,

<< Hello! i'm trying to show the progress of an SP on a Delphi progress
bar... but the onProgress event is not called/started soo i can't get the
PercentDone value...  >>

Is this a local or remote session ?  Also, what version of EDB are you using
?  There was recently a bug that was fixed in 2.03 B7 that would cause
progress messages to stop working for remote sessions:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.03&type=f&incident=3106

--
Tim Young
Elevate Software
www.elevatesoft.com

Thank you for fixing the Progress and Status Message events.  It's nice to
see them again in EDB Mgr build 7 after running scripts "blindly" in build 6
for a while.  I just upgraded today.  

--
David Cornelius
Cornelius Concepts

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message
news:6D6AE7F1-46E2-4E46-ABDE-C63CE6FBAF62@news.elevatesoft.com...
> Tiago,
>
> << Hello! i'm trying to show the progress of an SP on a Delphi progress
> bar... but the onProgress event is not called/started soo i can't get the
> PercentDone value...  >>
>
> Is this a local or remote session ?  Also, what version of EDB are you
> using ?  There was recently a bug that was fixed in 2.03 B7 that would
> cause progress messages to stop working for remote sessions:
>
> http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.03&type=f&incident=3106
>
> --
> Tim Young
> Elevate Software
> www.elevatesoft.com
>

Thank you for helpping me, I will try that. I'm using the trial version, i don't know if i
can try that new version. Thanks anyway!



"Tim Young [Elevate Software]" wrote:

Tiago,

<< Hello! i'm trying to show the progress of an SP on a Delphi progress
bar... but the onProgress event is not called/started soo i can't get the
PercentDone value...  >>

Is this a local or remote session ?  Also, what version of EDB are you using
?  There was recently a bug that was fixed in 2.03 B7 that would cause
progress messages to stop working for remote sessions:

http://www.elevatesoft.com/incident?action=viewrep&category=edb&release=2.03&type=f&incident=3106

--
Tim Young
Elevate Software
www.elevatesoft.com

Tiago,

<< Thank you for helpping me, I will try that. I'm using the trial version,
i don't know if i can try that new version. Thanks anyway! >>

You can download any trial version using your normal customer login
information, even if you're a DBISAM customer.  Remember, we *want* you to
buy all of our products.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello! My company is almoust decided to buy elevatedb but we are still testing. Yesterday
i've downloaded the new version, another problem ocoured... I'm getting that "fatal error"
when compiling on delphi "[DCC Fatal Error] Unit1.pas(7): F2051 Unit edbexpr was compiled
with a different version of edbconsts.EDB_ERRSTR_COMPILE_RANGE"

I have tried almous everything, i've re-installed delphi and all the related software,
including elevatedb. I'm getting that error on a new project with only a EDBEngine droped
on form...

Thanks!





"Tim Young [Elevate Software]" wrote:

Tiago,

<< Thank you for helpping me, I will try that. I'm using the trial version,
i don't know if i can try that new version. Thanks anyway! >>

You can download any trial version using your normal customer login
information, even if you're a DBISAM customer.  Remember, we *want* you to
buy all of our products.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tiago,

<< Hello! My company is almoust decided to buy elevatedb but we are still
testing. Yesterday i've downloaded the new version, another problem
ocoured... I'm getting that "fatal error" when compiling on delphi "[DCC
Fatal Error] Unit1.pas(7): F2051 Unit edbexpr was compiled with a different
version of edbconsts.EDB_ERRSTR_COMPILE_RANGE" >>

Do a search on your machine of edbconsts.pas and make sure that there is
only one copy, and that it is in the \code\source subdirectory.  If there
are any copies in the \code subdirectory, then delete them.

--
Tim Young
Elevate Software
www.elevatesoft.com

I had to move "edbcomps.pas" and "edbconsts.pas" to my project folder, now my vcl is
working. But vcl will not work if you don't copy these source code files to your project
folder.

The onProgress event is now firing when e execute my SP on delphi, very nice and handy!

Thanks!






"Tim Young [Elevate Software]" wrote:

Tiago,

<< Hello! My company is almoust decided to buy elevatedb but we are still
testing. Yesterday i've downloaded the new version, another problem
ocoured... I'm getting that "fatal error" when compiling on delphi "[DCC
Fatal Error] Unit1.pas(7): F2051 Unit edbexpr was compiled with a different
version of edbconsts.EDB_ERRSTR_COMPILE_RANGE" >>

Do a search on your machine of edbconsts.pas and make sure that there is
only one copy, and that it is in the \code\source subdirectory.  If there
are any copies in the \code subdirectory, then delete them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tiago,

<< I had to move "edbcomps.pas" and "edbconsts.pas" to my project folder,
now my vcl is working. But vcl will not work if you don't copy these source
code files to your project folder. >>

Don't move them, just delete them.  You should have an edbcomps.dcu and
edbconsts.dcu in your \code subdirectory that will be picked up by the
compiler.  The edbcomps.pas and edbconsts.pas units should only be in the
\code\source subdirectory, and the reason that they are in the \code
subdirectory was due to an issue with the builds sometime last year.

--
Tim Young
Elevate Software
www.elevatesoft.com