Svein Erling Tysvær wrote:

> Not even read-only databases are completely bullet proof against user
> stupidity. I would expect it to be possible to write a stored procedure
> in Firebird that could come up with results similar to what you report
> SQL server does:
>
> for select FieldA from D into :MyVar do
> begin
> If (MyVar is not null) then
> begin
> Update M
> Set FieldA = :MyVar
> Where...
> end
> end;
>
> Set

Of course, but procedures suffer all the problems of any
imperative/procedural programming language (or any programming language
perhaps), that you can shoot yourself in the foot with various mistakes
in program logic. But I think that's more expected than for SQL to merge
multiple rows into a single one without saying anything about it.

Kjell
--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64