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 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 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 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...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...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...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&...Getting datawindow Properties from within datawindow??
i would like to create a custom userObject uo_myDW that inherits from
DataWindow and stuff some default behaviour into it.
For a new app i'm writing, i need a pile of input windows, all sharing the
same functionality. I'd like to build uo_myDW so that in incorporates all
Here 's what i want to do
For one of these functionalities mentioned above, i need the collection of
uo_myDW's columns that are 'Tab-able' (have a tabindex > 0), and store them
in a instance var ids_DWColumns for future reference.
...How to get a column property in a datawindow column object expression?
I have a free style datawindow, I want such expression:
columnA.x = IF(columnB.visible, columnB.x + 100, 200)
Yes, you can get it in script, but I just want set it in datawindow.
Anyone can help?
AFAIK, you cannot reference object properties in the expression. That would
- Eric Aling [TeamPS], Cypres Informatisering bv, The Netherlands
Eric's Home & PB Site @ http://utopia.knoware.nl/users/cypr115
Bo Song <firstname.lastname@example.org> wrote in message 36D52106.433CE9B2@188.net...
>I have a free style data...Datawindow Column name
How i can to get the column's name with it index.
I tried this in a datawindow with 10 columns:
for i=1 to dw.rowCount()
name = dw.describe("#" + i + ".name")
but when i going to try it only show me the name of the first column (1)
dont work with 2,3... etc.
you know any other method ?? What i can do ??
You are looping on a rowcount() - it does NOT have anything to do with
Yup. You need to use Integer (Describe ("...how to get the name of datawindow ?
I have a datawindow 'dw_sample' , I put a new expression in that
datawindow : "describe('datawindow.name')", but it return the result :
'datawindow', and not the name 'dw_sample'
am I describe the wrong expression ?
you can't get the name of the datawindow from within the datawindow.
"wong KS" <email@example.com> wrote in message news:4827199e@forums-1-dub...
>I have a datawindow 'dw_sample' , I put a new expression in that datawindow :
>"describe('datawindow.name')", but it return...