Subject Re: [firebird-support] Parameter in select statement possible?
Author Thomas Steinmaurer
> is it possible to use parameters within the select statement?
> Something like
> "select cast (:PATH || FILENAME as varchar(255)) as FILEPATH from SOME_TABLE"

Yes, but I guess you will get an error at prepare time.

You explicitely have to specify what data type the :PATH parameter is,
e.g. with:

select cast (:PATH as varchar(255)) || FILENAME as filepath from SOME_TABLE

With regards,
Thomas Steinmaurer