"Duilio Foschi" <dedalus@...> wrote in message
news:3.0.1.32.20020302230844.006af48c@......

> At 18.22 02/03/02 -0400, Claudio Valderrama wrote:
>
> >Look for db_key in my site. You have to reverse the update to be a
> >select-driven statement.
>
> I will need a few months to understand those pages :)
>
> In the while: what do you mean with "reversing the update" ?

You start with a select in a FOR and do the update inside, instead of
putting a SELECT inside the UPDATE (your command) that unfortunately, it's
executed for every row in the updated table.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing