Subject | Re: Is this statement wrong? |
---|---|
Author | hvlad |
Post date | 2010-07-23T14:59:41Z |
--- In firebird-support@yahoogroups.com, "Fabiano" wrote:
BTW, i see no way to supply input parameters in isql script, so such query have no meanings (for isql)
Regards,
Vlad
>isql not supported input parameters and not rewrited statement to replace named parameters with question marks.
> 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.
> *******************************************************************************/
BTW, i see no way to supply input parameters in isql script, so such query have no meanings (for isql)
Regards,
Vlad