Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

apex

Posted on 2012-03-28
4
759 Views
Last Modified: 2012-04-03
in my application
i have a home page where date column is there if the date column is not null
then all items in other pages should be disabled(locked)not updatble only can view
but if date column is null then all items in pages are updateble.

how to disable some items in pages when i select with some condition
0
Comment
Question by:vsarma50
  • 2
  • 2
4 Comments
 
LVL 20

Expert Comment

by:gatorvip
ID: 37778747
For those items, change their Read-Only condition to Value of Item/Column in Expression 1 is NOT NULL and set the Expression 1 field to your date column
0
 

Author Comment

by:vsarma50
ID: 37797318
Hi
this is working only for one column
but i have condition with 4 columns
1) date
2) anothercolumn1
3) another column2
4) another column3
in this column 1 to 3 should be null and the date should match with date in the first page
then the fields are locked
but now with this solultion iam able to check only one
expression 1 is not null
how can i do this please advice.
thanks.
0
 
LVL 20

Accepted Solution

by:
gatorvip earned 500 total points
ID: 37797879
>>this is working only for one column

Yes, because that is what you asked for in the original question. My answer was correct for what you stated initially: "where date column is there if the date column is not null"

Now you are asking about 4 columns and there's an additional requirement for a date match. In the future, please ensure to give the correct details or post a new thread with the new question.

What you probably want to do in this case is to change the Read-Only condition to PL/SQL Expression, then change the Expression 1 field to something like:
:P_COLUMN1 is not null
and :P_COLUMN2 is not null
and :P_COLUMN3 is not null
and :P_DATE_FIELD1 = :P_DATE_FIELD2  

Open in new window

The date condition his is where you need to be more specific as to what you actually have on your pages. You can add a separate validation to ensure that the date fields actually contain a correct date.
0
 

Author Closing Comment

by:vsarma50
ID: 37802562
Thanks very much it worked for text columns but if it is a report column how can I change the read only property. please advice.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question