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
missed.
Do you have any idea?
Charles
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...
how to get all the column names from datawindowI would like to get all the column names from datawindow.
any help apppreciated
TIA
//1. Column names
Int li_col_count, ls_columns[]
li_col_count =
integer(idw.Describe("DataWindow.Column.Count"))
FOR i = 1 TO li_col_count
ls_columns[i] = idw.Describe("#" + String(i) + ".Name")
Next
//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.
hth
> I would like to get all the column names from datawindow.
>
> any help apppreciated
> TIA...
How does a datawindow column get its name?Q: How does a column get its name?
Pretext:
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").
Change:
I was changing this existing datawindow - adding one another column.
After adding the column into the SQL-SELECT, the datawindow display warning
message as
"SELECT change has forced update specification change" ( I have update
pro...
get column name dynamically in webpage
Hi,I am using
<%# DataBinder.Eval(Container.DataItem,filedname %> in my webpage.But I want to get the first field's name in the container I have here(It depends on the dataset I bind to the datalist).How can I do that?thanks
i'm not sure what you are trying to acheive here. can you describe it in more detail?
I mean how can I get the column name here?I can't hardcoded it here because the datalist will bind to different dataset based on the user selection,so the field name will change....
CrossTab Datawindows and Getting the Column NamesHi,
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
Blue 1
Red 1
Green 1
Yellow 1
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...
Dynamically changing DataWindow column namesI need a way to "Dynamically change DataWindow column
names".
This so that when a user wants to save a datawindow as an
excel file, that a more user-friendly column name can be
used instead of the cryptic database column name.
Please advise. Thank you.
Dynamically create an external dw with all the columns you want and column
names you want. Then move the data from original dw to know dw, and then
call saveas(). It does not need any formatting. Create a external dw, export
to syntax, look at how its structured. Then you can dynamically build one
very easily by loop...
Get Value of column dynamic of datawindow crosstabHello to all.
I have datawindow crosstab and I need to obtain the value of the
generated columns .
Thanks!
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
friday.
"Raul Gil" <gl_ra@hotmail.com> wrote in message
news:414f86f2$1@forums-1-dub...
> Hello to all.
>
> I have datawindow crosstab and I need to obtain the value of the
> generated columns .
>
> Thanks!
>
&...
how to get the column names of a dynamic executed procedure?I wrote a pb a application that executes a sybase procedure that I get its name
and parameters dynamically.
I use DynamicDescriptionArea for that and It works fine , except for that I
can't get the columns titles.
Is there another way to execute a procedure from pb and get the columns names as
well ? how ? do you have a code sample for me ?
I'm using powerbuilder 6.5 and Sybase 12.0
thanks
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
Column names for what?
Please, more info.
Alex Osin
"Izik I." <izi...
rules-based generic approach to get friendly column names in a Dynamic Data project
All --Please help. I am looking for a rules-based generic approach to get friendly column names in a Dynamic Data project.For instance, suppose I use a rule to name my columns in the database that separates words with PascalCased names-- FirstName, LastName, MiddleName, and so on.Now, suppose that I want to have a rules-driven friendly name creation done automatically by the Dynamic Data templating process to convert such names "insert space if next is capital" so we get... First Name, Last Name, MIddle Name.Or something like that. Maybe the rule is "replace underscores in the...
Get Name of DW Identity Column (column.identity property requires looping thru all columns)I need to locate the identity column for a DW. Only method i see is use of
the columnName.Idenity property - which requires you to traverse all the DW
columns and then look up the identity property for each until one is yes.
Is there a way just to get the identity column directly - or the Primary
Key.
thanks,
Dave
As one can see in he syntax, sorry no.
I played around with it this week also as I am using DW.Net2.0 with
DataSets and a DataSet can not create update commands from a SQL
statements where one has 2 tables.
But, now, with the help of DW.Net it can do it ...
Getting Datawindow name from datawindow child variableHi !
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 :
datawindowchild dwc
dw_1.getchild("colname", dwc)
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.
Please, help!
thx.
You're correct. There is no way to get the datawindow name from the
datawindow child, you have to ask the paren...
Get Column Number Using Column NameThis ones burning me because, I am sure i've done it before and It's simply
slipping my mind.
I need to be able to get a column number using the column name.
i.e. Column name = 'effective_date'.
Using effective date - get the column number that belongs to effective
date.
Any help is appreciated!!
Thanks!!
William
dw.Describe("effective_date.ID")
Good Luck
Michael Walker
Cascadia Software
William_Shiers wrote:
> This ones burning me because, I am sure i've done it before and It's simply
> slipping my mind.
>
...
Dynamically name columns in dynamically created datagrid
I am using code that I found on the net to take a datatable, drop it into a datagrid, and then export the whole thing as an excel spreadsheet.
So far for the small numberes I have tried it works. Currently I have an application where the number of columns ranges between 40 and 70.
The problem that I have is I want the first row to have names which are meaningful to the user, but I don't want to rename my datatable columns, only the datagrid columns. Right now the Excel column names are the same as the datatable names. Those names are meaningful to me (the programmer) but meaningless to...
SQL: Column names, can ONLY get "name" instead of "table.name"
Hey all,
When iterating through column names returned from a query, I need to get "table.name" rather than just "name"
Check it out:
If I have an SQL statement "SELECT table1.ID, table2.ID FROM table1, table2;"
And table1 has a column name 'ID'
and table2 has a column name 'ID' aswell,
and i run the query, the dataset will contain column names 'ID' and 'ID'
instead of 'table1.ID' and 'table2.ID'
It is extremely important that I can differenciate between the 2 fields, and know where each of them come from.
The same thing happen...