Subject Re: [IBO] TIB_Script and multiline comments
Author Falko
you were right:
using ^ instead of / solved the problem
and now TIB_Script works fine.

Thanks Helen, thanks Jerry

Best regards
Falko :-)



--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> 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
>