| Not updating last Record [message #79123] |
Mon, 29 April 2002 15:04  |
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;
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
