Devlopers Plz help

[mahmood]

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.

[vbaskar]

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..

[mahmood]

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.

[jm]

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