Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 3 of 3 total |
stored procedure progress |
Wed, May 30 2007 10:30 AM | Permanent Link |
"Harry de Boer" | LS
Given the following SP with input parameters (adding a number of records starting with value RECID1 up to the value of RECID2), how do I code the onprogress event of that SP to show a progressbar while adding the records (I cannot quite figure it out) ? Regards, Harry PROCEDURE "addRecords" (IN "RECID1" INTEGER, IN "RECID2" INTEGER, IN "DAT1" TIMESTAMP, IN "DAT2" TIMESTAMP) BEGIN DECLARE Tbl CURSOR FOR stmt; DECLARE I INTEGER; DECLARE II INTEGER; SET I = RECID1; SET II = RECID2; PREPARE stmt FROM 'SELECT * FROM Tbl'; OPEN Tbl; WHILE I <= II DO INSERT INTO Tbl (veld1, veld2, veld3, datum1, datum2) VALUES (I, '_' + CAST(I AS VARCHAR(10)), CURRENT_TIMESTAMP, DAT1, DAT2); //dat1 and dat2 are valid timestamps SET I=I+1; END WHILE; CLOSE Tbl; |
Wed, May 30 2007 1:27 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Harry,
<< Given the following SP with input parameters (adding a number of records starting with value RECID1 up to the value of RECID2), how do I code the onprogress event of that SP to show a progressbar while adding the records (I cannot quite figure it out) ? >> You can't currently - the SP's are missing a statement for reporting progress back from the SP. I hope to have that statement included in the next version. Also, SPs do not indicate progress for individual SQL statements due to the fact that ElevateDB doesn't want to reveal what is actually going on in an SP for security reasons. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, May 30 2007 2:26 PM | Permanent Link |
"Harry de Boer" | Tim,
> You can't currently Thanks for letting me know. I can stop trying to achieve this now. Regards, Harry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> schreef in bericht news:EA4CB5EB-0E42-420B-985A-6A184E034670@news.elevatesoft.com... > Harry, > > << Given the following SP with input parameters (adding a number of records > starting with value RECID1 up to the value of RECID2), how do I code the > onprogress event of that SP to show a progressbar while adding the records > (I cannot quite figure it out) ? >> > > You can't currently - the SP's are missing a statement for reporting > progress back from the SP. I hope to have that statement included in the > next version. > > Also, SPs do not indicate progress for individual SQL statements due to the > fact that ElevateDB doesn't want to reveal what is actually going on in an > SP for security reasons. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |