Subject | Re: [firebird-support] Re: Dinamic SQL in Firebird ! - inside :P |
---|---|
Author | Martijn Tonies |
Post date | 2005-04-18T10:38:36Z |
> But, could I introduce, in a select done, a only expression (subRead the Release Notes again to see how EXECUTE STATEMENT
> 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.... ;)
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