Thanks Ivan, but I'm using T_IBQuery, how can I create a calculate
field on that?

Andrei

--- In firebird-support@yahoogroups.com, Ivan Cruz <ivan@a...> wrote:
> 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.