|
|
|
|
|
Re: copy the val of previes item into next item [message #585693 is a reply to message #585563] |
Wed, 29 May 2013 03:18 |
irfankundi786@yahoo.com
Messages: 269 Registered: February 2009 Location: pakistan
|
Senior Member |
|
|
this code is at block level when-new-record-instance...
declare
a number;
cur_rec number;
cur_form FORMMODULE;
begin
CUR_FORM:=FIND_FORM(:SYSTEM.CURRENT_FORM);
SET_FORM_PROPERTY(CUR_FORM,VALIDATION_UNIT,FORM_SCOPE);
--
:srno := 1;
cur_rec :=:system.trigger_record;
go_record(1);
a :=1;
loop
:srno :=a;
if :system.last_record = 'TRUE' Then
Exit;
else
a := a + 1;
:global.TXT_TASK_DESC := :TXT_TASK_DESC;
message('name time :'|| :global.TXT_TASK_DESC);
next_record;
end if;
end loop;
SET_FORM_PROPERTY(CUR_FORM,VALIDATION_UNIT,DEFAULT_SCOPE);
:TXT_TASK_DESC :=:global.TXT_TASK_DESC;
===========================================
this is used to create serial no in block...and also assign values in the global variable and at last assign the global value to text item but there is problem when-new-record-instance triggered for each record ...once block is executed global val assigned to text_item and once when new record is created..
i need when new record created...which trigger is suitable for this???
|
|
|
|
|
|
|
|