APEX

Hi all,

I need help to solve a problem like following.

I have a table 'results' with the columns
result_id number PK
method varchar2(200)
readout varchar2(60)
result number

Also I have built a page with an array (realized through text fields) like this one:

x1_1 x1_2
x2_1 x2_2
x3_1 x3_2
... ...
x100_1 x100_2

All elements in the array have the same method. In column readout the name of the array element has to be stored. The input of the text fields have to be stored in column result.

I think an example makes it more clearly

method = malinoe

x1_1 = 15 x1_2 = 9
x2_1 = 3 x2_2 = 7
x3_1 = 10 x3_2 = 11
... ...
x100_1 = 2 x100_2 = 3

After fill in the values into the text field array you have to click the Button 'SAVE' and all values have to be stored in the table results:

first row:
result_id = 1
method = malinoe
readout = x1_1
result = 15

second row:
result_id = 2
method = malinoe
readout = x1_2
result = 9

third row:
result_id = 3
method = malinoe
readout = x2_1
result = 3

....


last row:
result_id = 200
method = malinoe
readout = x100_2
result = 3


Has anybody an working example or idea how I can solve this problem?

Thanks for help,
ben

Message was edited by:
ben512