?
Solved

To get all computed column names of a datawindow

Posted on 2011-02-25
1
Medium Priority
?
612 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: 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

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. …
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

621 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