Andrei Luís wrote:

>I'm using IB_Query from IBO, and, when I'm inserting data
>(qrSales.Insert) the total field doesn't show its value. Only after
>qrSales.Post.
>
>Is that correct? Is there any way I can show the total before
>qrSales.Post? I'd like to show the total, right after quantity and
>unit_price receive any value.
>
>Is that possible?
>
>Thanks,
>
>Andrei
>
>
>

It's as designed. Computed by fields will be computed by Firebird
just after a SQL Insert (or Update) comand is issued and it's done
only in the Post method. The Insert method on IBO (and all other
DB components) works only locally.

To solve your problem, drop the computed by field and create a
calculated field (and a onCalcFields event handler) in your Delphi
query.

Ivan.