Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

To get all computed column names of a datawindow

Posted on 2011-02-25
1
Medium Priority
?
995 Views
Last Modified: 2013-12-26
Pb 10.5

I create a datawindow with this sql
select cust_code from customer

Then In datawindow I make another copy of cust_code and give the colunm_name say 'cust_name'

IN constructor event II am doing this and my intention is to know all column names including computed columns of datawindow
      FOR I = 1 TO Integer(dw_master.Describe('Datawindow.Column.Count'))  
         ls_colname  = dw_master.Describe('#' + Trim(String(i)) + '.Name')
         messagebox('', ls_colname)
      next
the          messagebox('', ls_colname) never display "cust_name"

Is there anyway to find computed column names of datawindow
0
Comment
Question by:Mehram
1 Comment
 
LVL 3

Accepted Solution

by:
loks earned 2000 total points
ID: 34994266
Hi Mehram,

If you are trying to obtain the column names dynamically  from a datawindow then yes it is the best way. But I would recommend that push the value of 'Integer(dw_master.Describe('Datawindow.Column.Count')) ' into a local varible and then use in the FOR loop to imrpove performance.

Refer sybase tip http://www.sybase.com/detail?id=42398

Regards,
Loks
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

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

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
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…
The viewer will learn how to use and create keystrokes in Netbeans IDE 8.0 for Windows.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

916 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