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.

Thanks.

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]