![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Reported for Version 2.04 » View Incident Report |
![]() |
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, October 30, 2024 at 11:41 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |