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