Hi Helen,

Helen Borrie wrote:

> At 03:37 AM 18/03/2004 +0000, you wrote:
> >Hi Helen,
> >
> > > No. Computed on the server means computed on the server....it is
> >read-only
> > > and it can not change until the output is recalculated.
> > >
> >
> >What will be the best way for that field to be display once a post is
> >made but now yet committed? Iam using the IBExpert Personal Ed. I try
> >inserting a record after posting it with out committing the computed
> >field immediately show the result of the computation.
>
> Sorry, James, I can't understand the question.
>

Iam sorry, please bear with my poor english. Here is the DLL of my table.

CREATE TABLE "birinvoicedetails" (
"id" INTEGER NOT NULL,
"invid" INTEGER,
"qty" INTEGER,
"prodid" INTEGER,
"price" NUMERIC(15,2),
"subtotal" COMPUTED BY ("price" * "qty")
);

In IBO, what happen is when I insert a record, assuming the "qty" field
is 10 and the "price" is 55 that means that the "subtotal" field will be
550. But after posting the record the 550 won't appear until I run this
line "ib_transaction1.refresh(true);" My question is after posting is
there a way for the value in the "subtotal" field will be display right
after posting it even if its not yet committed? Just like what I see in
IBexpert.

Thanks for your patience.

Regards,
James