How can I get the column name of a datawindow column?
I want to get the column name in tablename.columnname format. I have tried
to get it using dbname property. However, I found that it work only if the
tables in the datawindow are inner join. If the tables in the datawindow
are outer join, the dbname only return the columnname and the tablename is
Do you have any idea?
You could add the name to the select clause or to the tag property. Or you
caould check to see if it is a join or not (by seeing if there is a '.' in the
column name) if not then get the sql select statment and parse to find the
table...Getting Datawindow name from datawindow child variable
I want to get the datawindow (name) from a datawindowchild variable.
But, the dwc has no way to get it.
I want the code like this :
dw_2.dataobject = dwc.dataobject
-------------- -> X
In the above code, "dw_1.object.colname.dddw.name" is what I want.
But, from the "dwc", I can't know that.
You're correct. There is no way to get the datawindow name from the
datawindow child, you have to ask the paren...How does a datawindow column get its name?
Q: How does a column get its name?
Datawindow is built using
Tabular - SQL Select - and Converted to Syntax.
On existing datawindow - the column names have been modified to strip off
the table names (so table name "company" was stripped from column name
"company_code" to make it as just "code").
I was changing this existing datawindow - adding one another column.
After adding the column into the SQL-SELECT, the datawindow display warning
"SELECT change has forced update specification change" ( I have update
pro...how to get all the column names from datawindow
I would like to get all the column names from datawindow.
any help apppreciated
//1. Column names
Int li_col_count, ls_columns
FOR i = 1 TO li_col_count
ls_columns[i] = idw.Describe("#" + String(i) + ".Name")
//2. If you need to include CF's look at the
Object.DataWindow.Objects string (tab separated) and parse
it back to an array of DW objects.
> I would like to get all the column names from datawindow.
> any help apppreciated
> TIA...How to get crosstab datawindow column value
How to get crosstab datawindow column value
Try dot notation. There is a good possibility to show data as well:
MessageBox( "Data", dw_Crosstab.Describe( "DataWindow.Data" ) )
Wisdom Pan schrieb:
> my problem
> How to get crosstab datawindow column value
don't forget to set the statis property to TRUE, before trying to access the
dynamically generated columns.
"Wisdom Pan" <firstname.lastname@example.org> wrote in message
How to g...How to get Column names from dynamic Datawindow?
Attached is a piece of code that opens a datastore based on a datawindow
which is itself based on a stored procedure that takes two parameters.
There are two records in the dataset. The problem is thus: this code
will be customized in each application but the "linked" list it will be
stored in is part of a PFC service that will not know the number/names
of fields until run time. That code is generic and creates the initial
linked list from records stored in a table that "defines" the
number/names of fields.
Since the code must not make any assumptions about the ...DataWindow This, DataWindow That...
Blah blah blah
You've heard it enough that you don't even want to comment on how many
....but it can't be enough anymore...can it?
This from one of our colleagues
(and yes my apologies for taking it out of context)...
"...PB covers all you need to do that in ONE Tool. This
includes Windowprogramming ( meaning the interface to the user:
Windows, Sheets, diallougeboxes, etc.), Database operability AND
Reporting! Well, I see als well as many other PB users that some of
the implementations and features PB offers are improvable. But thi...Crosstab datawindow column header names ???
I am trying to read column header values of a crosstab datawindow :
- I tried GetItemString ( ), but what are the names of the text header fields : I only got the column name
defined at design time.
- A Describe ( "DataWindow.Crosstab.Columns" ) also give me names at design time.
Thank you for your ideas...
> I am trying to read column header values of a crosstab datawindow :
> - I tried GetItemString ( ), but what are the names of the text header fields : I only got the column name
> defined at design time.
> - A Describe ( "DataWindow....Get Value of column dynamic of datawindow crosstab
Hello to all.
I have datawindow crosstab and I need to obtain the value of the
generated columns .
Hola a todos.
Tengo un datawindow crosstab y necesito obtener el valor de las
columnas generadas dinamicamente
Read the thread started by Davy De Permentier with the subject "CrossTab" on
"Raul Gil" <email@example.com> wrote in message
> Hello to all.
> I have datawindow crosstab and I need to obtain the value of the
> generated columns .
&...datawindow.column.count not returning the column count of a datawindow
I am having problems with the datawindow.column.count property of a
datawindow. It just started happening with PB 6.501 and still works
fine in PB 5.0. The function that looks at this property is in an
ancestor userobject. The dataobject is assigned at this point but all
other properties of the datawindow are missing. Any suggestions?
Don't recall, but was it still dwDescribe() in version 5.0? If it was that
may be your problem.
Kent Montgomery wrote:
> I am having problems with the datawindow.column.count property of a
> datawindow. It just started happenin...CrossTab Datawindow and Datawindow plugin
Does anyone know of any problems using the Datawindow plug-in and a crosstab
presentation sytle. I'm using web.pb to call my distributed PB server and
save the crosstab as a psr file and then return the html pointing to the psr
file. The computed fields are getting overlaid but doing it from
PowerBuilder works fine. I'm using PB 6.5
...Getting column's header in a Crosstab datawindow
My problem is as follows
I have made a cross tab datawindow. In that i want to change the column headers
at runtime. How could i get cloumn header name(it will vary at runtime) and
it at runtime. One thing is that i can't use column expression because i have to
get the value from other table.
Thanks in advance.
...datawindow column names and multi-table datawindows 5.0.04 -> 6.5
Has anybody out there noticed problems with the dynamic creation of
multi-table datawindows and referring to the datawindow columns? In 5.0.04
PowerBuilder automatically prefixed each datawindow column with the table
name(e.g. table_name_column_name). This is now broken in PB 6.5.
Why did this change in 6.5? What necessitated this change so that all
Sybase customers are forced to perform costly regression testing on
PB Enterprise 6.5
ODBC - any dbms( Sql Any, MS SQL, Oracle, Sybase ASE, Quadbase )
I'm using DataWindow.NET 1.5.1 9004 on a Windows XP
Professional SP 2 machine with the latest Microsoft Update
The release notes indicate that change request 385532 is
However, if I configure my computer to use a Windows XP
theme the border does not render as expected; a blue
bordered box is displayed. If I configure my computer to
use a Windows Classic theme the border is rendered as
expected. Is there something else I need to do to get the
datawindow object column borders to render correctly when
using a Windows XP theme?
Are you using 3D Lower...