setting read only condition on form elements -- seemingly not working
gpozApr 2 2013 — edited Apr 3 2013using 4.2.1 on 11G (AIX) at work, I have created a report with form. I have direction to make some fields on the entry form to be read-only under "edit" and enterable under "create". I go to the field definition and I used several of the conditions to achieve this, and all failed. When I used Request = Expression 1, I gave literal string 'Create' for the expression, and under every circumstance, it treated the condition like it was true. Did this also with PLSQL expression, "Exists" SQL (against dual where upper(:request) = 'CREATE') -- nothing seemed to be working. I checked the Oracle docs (app build guide), but it didn't offer any useful example.
So I thought, maybe I'm doing something wrong? Maybe something is not right in my setup or my app? So I tried it at home on my own machine, which is the same version of everything (except using Oracle Linux 5.6), and the problem was easily reproduced with a new and very simple app.
Can somebody else try this and then post something that I can imitate very precisely to track down why I have this situation?