Try to omitt leading and trailing SET TERM statements. They're used for
scripting purposes and are not implemented in components that expects
only single statement.
I don't know, if that component you're using supports more than a single
statement, so I can be wrong.

Milan

Dne 21.7.2011 13:55, Marcin Bury napsal(a):

>
> Uwe
>
> W dniu 21.07.2011 13:49, Uwe pisze:
> > Could somebody tell me why the following error is received when I
> try to compile this SQL statement. Using firebird 64 bit v 2.5 ?
> >
> > SET TERM ^ ;
> >
> > CREATE PROCEDURE TestProc
> > AS
> > BEGIN
> > IF ( EXISTS(SELECT * FROM OBJECTTYPE)) THEN
> > SELECT 'Test message.'
> >
> > END^
> >
> > SET TERM ; ^
> >
> > Error: *** IBPP::SQLException ***
> > Context: Statement::Prepare(
> >
> > CREATE PROCEDURE TestProc
> > AS
> > BEGIN
> > IF ( EXISTS(SELECT * FROM OBJECTTYPE)) THEN
> > SELECT 'Whats Up'
> >
> > END
> > )
> > Message: isc_dsql_prepare failed
> >
> > SQL Message : -104
> > Invalid token
> >
> > Engine Code : 335544569
> > Engine Message :
> > Dynamic SQL Error
> > SQL error code = -104
> > Token unknown - line 9, column 1
> > END
>

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