Regarding Create Record in Oracle forms
848964Feb 8 2013 — edited Feb 11 2013Hi,
I am having a form in which I had two sections, master and detail. Master section has a field in which I select week range like 01-FEB-2012-07-FEB-2012.
Based upon this I am populating with the help of CREATE_RECORD(writted in when new block of detail) , 7 rows in the detailed section,
01-FEB-2012
02-
03-
till 07-FEB-2012.
There are other columns in the detail section beside this date field. Now at a stage when nothing is saved, I can go in the master block and change the week rangeb from LOV and accordingly the date field in the detail section gets populated with new 7 days/rows. (Its happening as the system.record_status = INSERT).
Now what I need is when I select the date range in master, 7 days as usual gets populated in detail section. Now I save and then I try to change the lov for the date range in master i doesn't allow me to change .(presently the system.record_status = QUERY) although I have taken 3 modes (NEW , INSERT & QUERY in the when new block code.
I am now not able to sure if at all what I want is feasible or not considering the mode when its QUERY. I tried doing some r&d but not of much help. Can anyone plz advise if this is a feasible requirement or not possible as per standard method.
Appreciate suggestions on this.
Thanks & Regards,
Ad