Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.14 » View Incident Report |
Minor |
Reported By: Mark Culos [Blackberry Civil Works] Reported On: 11/19/2013 For: Version 2.14 Build 5 |
SCRIPT BEGIN DECLARE TableCheckCursor CURSOR for TableCheck; DECLARE LastJobNumber Integer DEFAULT 3; PREPARE TableCheck FROM ' Select * From information.TemporaryTables Where Name = ? '; BEGIN OPEN TableCheckCursor using 'zzTest1'; IF RowCount(TableCheckCursor) > 0 then EXECUTE IMMEDIATE 'Drop Table zzTest1'; END IF; CLOSE TableCheckCursor; EXCEPTION END; BEGIN OPEN TableCheckCursor using 'zzTest2'; IF RowCount(TableCheckCursor) > 0 then EXECUTE IMMEDIATE 'Drop Table zzTest2'; END IF; CLOSE TableCheckCursor; EXCEPTION END; EXECUTE IMMEDIATE ' Create Temporary Table zzTest1 ( "Number" INTEGER DEFAULT 0 )'; EXECUTE IMMEDIATE ' Insert Into zzTest1 (Number) Values (1), (2), (3), (4), (5) '; EXECUTE IMMEDIATE ' Create Temporary Table zzTest2 as ( Select Number From zzTest1 Where Number >= ? ) with data ' Using LastJobNumber; 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 |