This content has been marked as final. Show 8 replies
What problem are you facing when you you replace item1 data with item5 data?
Yes how to replace of data between two fields.
User can select item5 and copy that data to item7 with replacement option.
How to find when user select item7 from item5
Not very clear with your requirement,
If you are trying to swap values each other, first you have to save the value of the field you are copying to in a variable then use the temporary variable value to copy back.
but how to replace each other
let me describe you detail
how to find previous field in which i replace data...??
if i use variable then this variable how to replace it...??
DECLARE TEMP varchar2 ( 15 ) ; BEGIN TEMP := :ITEM7 ; :ITEM7 :=:ITEM5 ; :ITEM5 :=TEMP; END;
TEMP varchar2 ( 15 ) ;
TEMP := :ITEM7 ;
:ITEM7 :=:ITEM5 ;
this is not as simple as u define
actually i have told u i have no. of item field and we don't no which field i came if i use variable then ok but next how to this variable use can assign as replacement
I AM USING COPY BUTTON TRIGGER
I AM USING PASTE BUTTON TRIGGER
Let me put the way i understood
So if a user wants to copy from item1 to item 3
clicks on the item1 first then press copy button
clicks on item3
clicks the paste button
i created a parameter called temp to store the destination field value
copy button trigger
:parameter.temp := :item3
paste button trigger
:item3 := :item1 ;
:item1 := :parameter.temp ;
i think i unable to clear u
actually when i copy the field i hold the field of the copy but when i paste then how to assign or replace value like
how to reassign value to v_previous_field
how to assign field