Hi

You can execute only one query at the time in sql editor.

Scripts are executed in script executive, but you can not have output from
scripts.

So i you must combine the two things
first you must formulate a query which will produce script-like output
than you execute that script


select 'update ' || RDB$RELATION_NAME || ' set ' || / select that finds the
name of the field-id of the table / || '=' ||
|| 'select max(' || / select that finds the name of the field-id of the
table / || ') from ' || RDB$RELATION_NAME || ';'
from RDB$RELATIONS where RDB$RELATION_NAME not like ('RDB$%')

The only problem could be /.../ selects - if you have named the id fields
well, then it's ok.

Then put the output of the query into script executive and after a few tries
it should work

Regards
Bogdan