I need simple query which i found difficult to solve please guide.
I have one database block in which five database field
in which i just replace data from i field to another is such a way that each field contain two button
when i select item1 then copy paste button enable and when i press copy button then item1 field data copy when when i select item5 button will enable and when i press button paste then data of item1 field data copy to item5 field and item5 field data copy to item1 field (simply replace of data), now the problem is when i copy of item1 data and paste to item5 its working fine but i unable to replace data item5 to item1 how can i do this.
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.
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