Subject Re: [firebird-support] How can i update multiple rows after a delete?
Author Fabio Gomes
The problem is that i m new to firebird and sql, and i dont even know how to
make the default value of the table be 0, and i dont know either how to use
this coalesce stuff.. i ll try reading about it.


On 11/21/05, Adomas Urbanavicius <adomas@...> wrote:
> I am afraid, you misexplained your problem.
> Anyway, null problem can by avoided by "coalesce" ( myAmount = coalesce
> ( (selec sum... ), 0);
> Or by adding manually default 0 in sql, or by adding trigger with
> default writing 0 to field value.
> Fabio Gomes wrote:

[Non-text portions of this message have been removed]