Datawindow Crosstab column data and headers
How do I access the data in the dynamic crosstab columns? How do I access the
text of the headers of the dynamic crosstab columns?
...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 Datawindows and Getting the Column Names
I'm kind of new to the Crosstab Datawindow. Currently,
we are trying to develop a Crosstab Datawindow to show a grid similar to:
Extra Small Small Medium Large Extra Large
with empty boes to type in. This would be used when someone is taking an
order for shirts, for example. I can pretty much get this far. My problem
is when I am trying to get the name for the Columns. I am using the...Crosstab Datawindow column header sorting
I have got a small question.
I have a crosstab datawindow. Users would like to click on
the column headers to sort the data.
Can you please let me know if this is possible? If so, how?
Thanking you in advance for your time.
...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
...Reference the name of the header object for a column in a grid datawindow.
Does anyone know a way to reference (using the PFC is an option) the
name of the static text header field for a column in a grid datawindow? I
am doing dynamic column ordering in PB 8.01. This can be done by making
columns invisible and then visible again in the order you want them
displayed. Well in PB 6.5 all you had to do was do a Modify with the column
number and set the visible property to 1. In PB 8.0 doing that only makes
the column's data visible, but not the header text field. That needs to be
done via another Modify. When in most cases using the column'...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 )
...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
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...Hide datawindow column in html datawindow
Is there anyway I can hide a datawindow column in the generated html? I
can't make the visible property to false because doing that will not
generate the column. I want the column with type as hidden in generated
I don't think this is in the works for the next release but I know of
several people who have mentioned it in the past. Try adding an
enhancement request (I think you can do this through my.sybase.com).
Hitesh Patel wrote:
> Is there anyway I can hide a datawindow column in the generated html? I
> can&...Datawindow Column Name
Is it possible to get a datawindow's column name from it's dbname. I
need do a find on the datawindow using the column name but since our
column names are created dynamically i.e col1, col2 etc i need to find
the corresponding column name to it's dbname.
I'm not getting entirely what you're trying to achieve, but here are some
When you create a datawindow from a SQL Select statement for each of the db
columns from your statement PB generates corresponding DW column (control).
If you observe the Column Specification pane in the Datawindo...Datawindow Column Names
Does anyone remember what the dwSyntax command is to return the columns
on a datawindow (in an array format)? I cannot seem to find it in the help.
you can read the source code of f_dw_get_objects in PFC,
or just retrieve columns list by dw.object.datawindow.objects.
Jim Cuoco <firstname.lastname@example.org> wrote in message
> Does anyone remember what the dwSyntax command is to return the
> on a datawindow (in an array format)? I cannot seem to find it in the