Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 1.07 » View Incident Report |
Minor |
Reported By: Harry de Boer Reported On: 11/12/2007 For: Version 1.06 Build 1 |
SCRIPT BEGIN DECLARE TempCursor CURSOR FOR stmt; PREPARE stmt FROM 'SELECT * FROM Information.Tables WHERE Name = ?'; OPEN TempCursor USING 'TmpJTOV'; IF (ROWCOUNT(TempCursor) > 0) THEN EXECUTE IMMEDIATE 'DROP TABLE tmpJTOV'; END IF; CLOSE TempCursor; EXECUTE IMMEDIATE 'CREATE TEMPORARY TABLE tmpJTOV AS SELECT extract(month from Datum) AS maand, SUM(Bedrag) AS bedr FROM MyTable WITH DATA'; END
This web page was last updated on Tuesday, April 23, 2024 at 08:39 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |