Hi Jason,
I'm getting an exception when executing an SQL script using TIB_Script
component in Build 36.
Further investigation reveals that the statement it fails on is a Create
trigger statement which has multiple (26) 'insert into' statements
within the trigger.
The partial extract of the trigger with only 2 insert statements is:
CREATE OR ALTER TRIGGER ADCP_CURRENTS_AI0 FOR ADCP_CURRENTSACTIVE AFTER
INSERT POSITION 0ASbegin insert into ADCP_QUALITY_CHECKS
(ADCP_CURRENTS_ID, TEST_ID, TEST_LEVEL_NO, TEST_NAME, PASS_TEXT,
SUSPECT_TEXT, FAIL_TEXT) values (NEW.adcp_currents_id, 0, 1, 'BIT
Status (Built-in-test)', 'BIT result is zero', 'BIT result is non-zero',
'BIT result is NA');
insert into ADCP_QUALITY_CHECKS (ADCP_CURRENTS_ID, TEST_ID,
TEST_LEVEL_NO, TEST_NAME, PASS_TEXT, SUSPECT_TEXT, FAIL_TEXT) values
(NEW.adcp_currents_id, 1, 1, 'Echo amplitude/intensity', 'Value between
70 and 220 counts', 'Value between 60 and 70 counts', 'Value greater
than 220 or less than 60 counts');
end;
When debugging the code I see that the actual statement being executed
in IBO, which is only has the first insert into statement :
'CREATE OR ALTER TRIGGER ADCP_CURRENTS_AI0 FOR
ADCP_CURRENTS'#$D#$A'ACTIVE AFTER INSERT POSITION
0'#$D#$A'AS'#$D#$A'begin'#$D#$A' /* Trigger text */'#$D#$A' insert
into ADCP_QUALITY_CHECKS (ADCP_CURRENTS_ID, TEST_ID, TEST_LEVEL_NO,
TEST_NAME, PASS_TEXT, SUSPECT_TEXT, FAIL_TEXT)'#$D#$A' values
(NEW.adcp_currents_id, 0, 1, ''BIT Status (Built-in-test)'', ''BIT
result is zero'', ''BIT result is non-zero'', ''BIT result is NA'')'
the exception being generated is 'Unexpected end of command - line 7,
column 135'
Could this be a problem with the parser modifications mentioned in the
release notes? Anyhow the script have be executing successfully on all
previous version of IBO.
Regards,Sean.





[Non-text portions of this message have been removed]