Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
Serious |
Reported By: Terry Swiers Reported On: 9/17/2010 For: Version 2.04 Build 2 |
SCRIPT BEGIN EXECUTE IMMEDIATE 'CREATE TABLE Table1 (ID INTEGER, Notes CLOB)'; EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (100,''Test 100'')'; EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (200,''Test 200'')'; EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (300,''Test 300'')'; EXECUTE IMMEDIATE 'INSERT INTO Table1 VALUES (400,''Test 400'')'; EXECUTE IMMEDIATE 'CREATE TABLE Table2 (ID INTEGER, Notes CLOB)'; EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (100,''Test 100'')'; EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (200,''Test 200'')'; EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (300,''Test 300'')'; EXECUTE IMMEDIATE 'INSERT INTO Table2 VALUES (400,''Test 400'')'; EXECUTE IMMEDIATE 'CREATE TABLE Table3 (ID INTEGER, Notes CLOB)'; EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (100,''Test 100'')'; EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (200,''Test 200'')'; EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (300,''Test 300'')'; EXECUTE IMMEDIATE 'INSERT INTO Table3 VALUES (400,''Test 400'')'; EXECUTE IMMEDIATE 'CREATE TABLE Table4 (ID INTEGER, Notes CLOB)'; EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (100,''Test 100'')'; EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (200,''Test 200'')'; EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (300,''Test 300'')'; EXECUTE IMMEDIATE 'INSERT INTO Table4 VALUES (400,''Test 400'')'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX Notes ON "Table1" (Notes COLLATE ANSI_CI) INDEXED WORD LENGTH 30 WORD GENERATOR CustomWordGen'; EXECUTE IMMEDIATE 'CREATE TEXT INDEX Notes ON "Table2" (Notes COLLATE ANSI_CI) INDEXED WORD LENGTH 30 WORD GENERATOR CustomWordGen'; EXECUTE IMMEDIATE 'CREATE FUNCTION "TestFunction" () RETURNS VARCHAR COLLATE ANSI EXTERNAL NAME "extmodule" VERSION 1.00'; EXECUTE IMMEDIATE 'CREATE TRIGGER "TestTrigger" BEFORE ALL ON "Table3" BEGIN DECLARE Test VARCHAR DEFAULT ''''; SET Test = TestFunction(); END '; EXECUTE IMMEDIATE 'CREATE TRIGGER "TestTrigger" BEFORE ALL ON "Table4" BEGIN DECLARE Test VARCHAR DEFAULT ''''; SET Test = TestFunction(); END '; END
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 |