Re: Totals with Oracle Forms

[Quoted] When I write the following code:

  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;         

  :XXP_RECEIVING_HEADER.RCV_AMOUNT := x_Amount;   :XXP_RECEIVING_HEADER.FREE_RCV_AMOUNT := x_Free_Amount;

I got Receord Has been updated by another user....

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;

[Quoted] I don't see the changes on the form

Help please...

Thanks
Elie,

[Quoted] DA Morgan <damorgan_at_x.washington.edu> wrote in message >
> How about the one that does the commit?
Received on Mon Nov 08 2004 - 09:26:20 CET