> Something like this will work:
>
> for select <primary key> from <table> where <condition>
> into <variable>
> do begin
> update <table> set <assignments> where <primary key> =

<variable>

> end;
>
> There are a couple of variants that might be slightly faster (using
> the undocumented cursor mechanism or db_keys) but as all the structures
> you're using will be in cache, the difference is unlikely to be
> measurable.

Using the DB_KEY provides a significantly measurable difference, IME.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com