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;

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

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
>
>