Home » Developer & Programmer » Forms » Not updating last Record
Not updating last Record [message #79123] Mon, 29 April 2002 15:04 Go to next message
Nissi
Messages: 2
Registered: April 2002
Junior Member
Hi,

I am pretty much new to forms. Please help me !. I am trying to change the values of one of the columns in the block. The user wants to change the date column to sysdate.

The code I am using below is doing fine but not updating the last record since it is exiting when the last_record is true.

Can anyone help me please ??

here is my code...
go_block('Assets');
first_record;
Loop
if :assets.hold_flag <> 'Y' then
:assets.from_date:=sysdate;
end if;
next_record;
exit when :System.Last_Record = 'TRUE' ;
end loop;
Re: Not updating last Record [message #79125 is a reply to message #79123] Mon, 29 April 2002 20:32 Go to previous messageGo to next message
Remash
Messages: 52
Registered: November 2000
Member
Put 'next_record' under 'exit when :System.Last_Record'.
Re: Not updating last Record [message #79129 is a reply to message #79123] Tue, 30 April 2002 08:25 Go to previous messageGo to next message
Nissi
Messages: 2
Registered: April 2002
Junior Member
Thank you so much. it worked
Re: Not updating last Record [message #79150 is a reply to message #79123] Sun, 05 May 2002 23:45 Go to previous message
Remash
Messages: 52
Registered: November 2000
Member
Please send me the coding you have done for this.
Previous Topic: How to count the no of windows opened in Oracle forms??
Next Topic: master detail form
Goto Forum:
  


Current Time: Mon May 16 20:43:33 CDT 2022