sql - Set text of text item dynamically from table in oracle forms -


i using oracle forms builder 6i. have created table stores names of items in form, example detail50.z1, detail50.z2 , on. column name 'detail'.

now question is, in loop in 'when_new_record_instance' want give items new text value. example detail50.z1 := 'value 1'.

i have created procedure declared cursor (c_curs_det) fetches item name table, , in loop, want set text other value. tried:

for v_rec in c_curs_det loop   set_item_property(v_rec.detail, xxx, 'some value'); end loop; 

but can't find can put on 'xxx'. can me?

you use copy procedure:

for v_rec in c_curs_det loop   copy('some value', v_rec.detail); end loop; 

Comments

Popular posts from this blog

apache - Remove .php and add trailing slash in url using htaccess not loading css -

javascript - jQuery show full size image on click -