Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
Progress not working |
Thu, Jan 21 2010 12:12 PM | Permanent Link |
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... 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! |
Thu, Jan 21 2010 1:39 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Thu, Jan 21 2010 5:47 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Mon, Jan 25 2010 12:27 AM | Permanent Link |
"David Cornelius" | 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 > |
Wed, Jan 27 2010 11:21 AM | Permanent Link |
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! "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 |
Wed, Jan 27 2010 5:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Jan 28 2010 7:07 AM | Permanent Link |
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" 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 Attachments: erro.jpg |
Thu, Jan 28 2010 7:39 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Thu, Jan 28 2010 8:33 AM | Permanent Link |
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. 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 |
Thu, Jan 28 2010 11:08 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |