Printable View
Hi friends
In field data stored 123456.
I wanna create EIGHTY (80) text items in control block,
and select 1 from data through substr(id,1,1) and store in first text item,
But problem is that i wanna store 2 like that with loop
1
1 2
1 2 3
1 in first text item when second number retrieve store 1 in second text item and 2 in first text item like that EIGHTY (80) text items.
Plz help me bcoz its urgent.
TYPE store IS TABLE OF XXXX ROWTYPE
INDEX BY BINARY_INTEGER;
variablestore store;
var1 := length(urfield1);
for i in 1..var1
loop
storeme := substr(var1,i,1);
variablestore(i) := storeme;
end loop;
from here take on..
Sir I can't understand
Plz sir write in easy we
What type and level of trigger i apply ?
In control block text item names are A1 to A80.
I select data from id column and numbers table.
Data is only 123456 and one row only.
How i can store that data in text items like scrolling of numbers?
Thanx in advance.
looks like you want multi-rows, just add 2 lines in the loop:
for i in 1..var1
loop
storeme := substr(var1,i,1);
variablestore(i) := storeme;
--
insert into xxx values(storeme);
commit;
--
end loop;
xxx is your table name