Subject Re: [firebird-support] Re: Dinamic SQL in Firebird ! - inside :P
Author Martijn Tonies
> But, could I introduce, in a select done, a only expression (sub
> statment) like that?
>
> <blocs>
> sub_s1 = 'and P = ' || my_user_id
>
> select c1,c2,c3
> from t1
> where c1 = 1 and c5 = \'Peret\' and EXECUTE STATMENT sub_s1 and c7 = 9
>
> <blocs>
>
> I supose that no... but nobodynows.... ;)

Read the Release Notes again to see how EXECUTE STATEMENT
is supposed to be used.

Short answer: no.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com