Re: Totals with Oracle Forms

8 Nov 2004 00:26:20 -0800 Elie Constantine <elie.constantine_at_gmail.com> wrote:

>
> When I write only this:
> UPDATE xxp_receiving_header SET rcv_amount = x_Amount
> WHERE xxp_receiving_header.header_id = :XXP_RECEIVING_HEADER.HEADER_ID;
>
> UPDATE xxp_receiving_header SET free_rcv_amount = x_Free_Amount
> WHERE xxp_receiving_header.header_id = :XXP_RECEIVING_HEADER.HEADER_ID;
>
> I don't see the changes on the form

There are two ways:

1)
requery the form after commit

or

2)
update on the client via assignment:

:block.var:=value;

...

commit;

>
> DA Morgan <damorgan_at_x.washington.edu> wrote in message >
>> How about the one that does the commit?

-- 
Frank Piron,
etfrankatkonaddotn
(leftrotate two)