Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.03 » View Incident Report |
Serious |
Reported By: Harry de Boer Reported On: 4/7/2007 For: Version 1.02 Build 1 |
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; //is 1 SET II = RECID2; // is 1000000000 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;
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |