Subject Re: [IBO] TIB_Script and multiline comments
Author Helen Borrie
At 00:18 11/09/2008, you wrote:
>Hi,
>i have problems with the TIB_Script component of IBO (V4.6a).
>
>Executing the following script i get an error
>
>script:
>
>connect "localhost:d:\test.gdb" user "SYSDBA" password "masterke";
>
>set term /;
>create procedure test
>returns( i integer)
>as
>/* this multiline
> comment throws an
> exception in TIB_Script
>*/
>begin
> i=0;
>/* do some other work btw: this comment is ok */
>end;/
>set term ;/
>
>error message:
>'ISC Fehlernummer:335544569
>ISC Fehlermeldung:Dynamic SQL Error
>SQL error code = -104
>Unexpected end of command'
>
>
>Executing this script in other db tools (e.g. ibexpert) works fine.
>
>Has TIB_script problems with multiline comments?
>is there a parameter to set to make it work?

I suggest avoiding the forward slash as your terminator. Use a character that is not going to confuse the various parsing layers that scripts and SQL statements go through. The forward slash is likely to cause parsing errors in several places. Most people use a caret (^).

Helen