--- In ib-support@y..., "sd_webpage" <sd_webpage@y...> wrote:

> Hi again,
>
> Is this possible :
>
> I have a list of tables with corresponding fields in them to update.
> I would like to be able to dynamically update them using the
> tablename and fieldname as parameters.

Hi Sandy!

You can use a stupid method like this:
if (:atablename='TABLE1) then
if (:afieldname='FIELD1) then
begin
update table1
set field1='XXX'
where field1='TST';
end
else
if (:afieldname='FIELD2) then
begin
update table1
set field2='XXX'
where field2='TST';
end
.....
et cetera

Best regards
Andrey Prokhorov