Subject Re: Is this statement wrong?
Author hvlad
--- In firebird-support@yahoogroups.com, "Fabiano" wrote:
>
> Tested with Firebird 2.1.3 Classic (Windows)
>
> set term !! ;
> execute block (
> par1 smallint = :par1)
> as
> begin
> if (exists (select * from rdb$database where rdb$relation_id = :par1)) then
> exit;
> end !!
> set term ; !!
>
> /*******************************************************************************
> The next statement causes the following error:
>
> Invalid token.
> Dynamic SQL Error.
> SQL error code = -104.
> Token unknown - line 2, column 16.
> Is.
> *******************************************************************************/

isql not supported input parameters and not rewrited statement to replace named parameters with question marks.
BTW, i see no way to supply input parameters in isql script, so such query have no meanings (for isql)

Regards,
Vlad