Kjell Rilbe wrote:

> Now, as far as I know FB doesn't support this update ... from syntax,
> but is there any other way that FB could end up mixing data from
> multiple records in this subtle way instead of throwing an exception?
>
> Kjell
>

Since you will need a sub-query like

update
M
set
M.FieldA = (select FieldA from D where ...),
M.FieldB = (select FieldB from D where ...)

you would get "multiple records" error, this kind of update requires a
single row returned

So I don't think you could get such mixing with FB.

see you !

--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br