Re: [firebird-support] EXECUTE STATEMENT problem understanding

[Alan J Davies]

Thanks again Mark - it took a while to work out what was going on (doh!) 
but now it works very well and I can expand it to do what I want.
Once again, thank you.
Alan

Just for interest (for anyone else)
table_to_use='q_tool';
         stmnt=
         'update '|| table_to_use ||
         ' set     tgp_no=:tgp_no,del_date=:del_date
         where   pjs_no=:pjs_no_in';
         EXECUTE STATEMENT
        (stmnt)
        (tgp_no:=tgp_no,del_date:=del_date,pjs_no_in:=pjs_no_in);




Alan J Davies
Aldis