Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

To get all computed column names of a datawindow

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

New benefit for Premium Members - Upgrade now!

Ready to get started with anonymous questions today? It's easy! Learn more.

Question has a verified solution.

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

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.
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 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.

722 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