?
Solved

To get all computed column names of a datawindow

Posted on 2011-02-25
1
Medium Priority
?
601 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
[X]
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
 
LVL 3

Accepted Solution

by:
loks earned 2000 total points
ID: 34994263
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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. …
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 synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

765 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