• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1002
  • Last Modified:

To get all computed column names of a datawindow

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)
the          messagebox('', ls_colname) never display "cust_name"

Is there anyway to find computed column names of datawindow
1 Solution
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now