Column property Problem

Posted on 2003-02-19
Medium Priority
Last Modified: 2013-12-26
Column properties are quickly becoming my arch-nemesis.
I will explain the situation, and if anyone can point me in the right direction, I would be pleased!
Let us assume that I have a column named col_1.  Let us also assume that the Visible property for col_1 is set to false. Let us also assume that I have another column (col_2) which has a Tag value of 2.
Now, put an expression on the visible property of col_1 that states {If(number(describe("col_2.Tag")) = 2,1,0)}.
Therefore, since the tag value of col_2 is is in fact "2", the expression evaluates to TRUE, and our column is now displayed (IE it is now Visible)
Now, create a computed column (comp_col) and describe the visible property of col_1 {describe("col_1.visible")}
You will find that comp_col returns {"0~tIf(number(describe("col_2.Tag")) = 2,1,0)}
My problem with this is that the describe is returning the INITIALIZED value of col_1 (IE 0 or False) and not the CURRENT value of col_1 (IE 1 or True).
I really want to know the CURRENT property status of col_1 for use with property expressions on other columns, not the initialized value.  Is this a bug, or am I approaching the problem the wrong way (keep in mind that I want to port this DW out as a WebDW also, so I want to keep display logic from within the datawindow rather than reference outside code)
Any help or comments are appreciated.
Question by:shamjones
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
1 Comment

Accepted Solution

maran_software earned 150 total points
ID: 7982563
I think you need to use EVALUATE to evaluate the property status. There is a useful example in the help file. The example uses the Evaluate combined with the describe fuction to get the current value of column properties.

I hope that helps.

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org Go to that link and select download selenium in the right hand column That will then direct you to their download page. From that p…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.
Suggested Courses

752 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