How to get a list of columns in a datawindow.
At development time, I can get a list of columns by select the "column
specifications" in the datawindow painter.
But how can I get a list of columns in a datawindow at run-time.
Hi Thomas !
ls_test = dw_object.Describe("Datawindow.Objects")
This command retrieve a List of Objects in your DataWindow, and not only
After test the result with this another command:
ls_test = dw_object.Describe(ObjectName + ".Type")
This command test if the object name you pass by reference is...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 ...How do I get a list of columns that exist in a datawindow?
When running my application, how can I get a list of columns that exist in
a give datawindow object?
> When running my application, how can I get a list of columns that exist in
> a give datawindow object?
You should have posted in the powersoft.public.powerbuilder.general newsgroup.
Something like this should work:
For li_counter = 1 to dw_1.object.datawindow.column.count
ls_columns[li_counter] = dw_1.Describe('#' + String(li_counter) + '.name')
Jim Egan [TeamSybas...How to create dynamic columns in the Datawindow Using powerbuilder
Can any one let me know How to create dynamic columns in the data window
using modified method.
Thanks in Advance
Please refer "Datawindow Syntax" tool provided by sybase for
generating the syntax to create dynamic columns.
/*************Dynamic column Syntax
<DW Control Name>.Modify(&
"create column( id=<an integer> tabsequence=<an integer>
accelerator='<a single letter>' moveable=<0 - False, 1 -
True> resizeable=<0 - False, 1 - True> pointer='<Arrow!,
Cross!, HourGlass!, IBeam!, Icon!,...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 .
&...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...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...Get SQL From datawindow
How Get Perfect SQL statement from datawindow?
I don't need "PBSELECT( VERSION(700) TABLE(NAME=~"Table~" )
"SELECT col1, col2
Where col1 = arg;"
I need your help, please!
dw_1.Describe( "table.SQLSelect" )
Roy Kiesler [TeamSybase]
Sybase Developer Network (SDN) - http://www.sybase.com/sdn
"minkyu kim" <email@example.com> wrote in message
> How Get Perfect SQL statement fro...Dynamic Column for datawindows
Is there a standard technique for dynamically (programatically) creating a
new column in a datawindow?
Adding a visible object for a column that is already in the SQL is easy -
look up the CREATE keyword for Modify.
If you also need to add the column to the SQL, you will have to modify the
Table property as well to define the column in the buffers. Look at an
export so see all the keywords you will need.
"David Ashton" <firstname.lastname@example.org> wrote in message
> Hello folks:
> Is there ...get list of columns
I use this script to read the columns
FROM sys.syscolumn c, sys.systable t
WHERE t.table_id = c.table_id
AND t.table_name = :ls_table[li_aantal]
But, the columns are not in the order as they are in the table (looking
with powerbuilder). If I include sys.syscolumns and order on col_no is
the column order then allways the order as I see in powerbuilder?
SELECT list(c.column_name ORDER BY c.column_id)
FROM sys.syscolumn c, sys.systable t
WHERE t.table_id = c.table_id
...Dynamic SQL and datawindow
I come from a VB/Delphi background(if you don't count the 5 years programming in
RPG) and I'm quite comfortable and used to building dynamic SQL from user input.
I've learned that if you want to do this with a datawindow then the SQL for that
datawindow can't have a 'where' clause. I'm working on a really big(can we say
overblown) application that uses PFC and relies heavily on inheritance and one
of the projects that I've been working on has to do with fixing a problem where
the designers of this application only expected to return one record from a
data...How Get sql in datawindow
I need get the command sql that go to DataBase when I do update at the
The SQLPreview event in the DW is your friend here.
Use sqltype = PreviewUpdate! to get the SQL only for updates.
Argenis Castro <email@example.com> wrote in message
> I need get the command sql that go to DataBase when I do update at the
...Dynamic SQL In a Datawindow
Is it possible to create a datawindow where the SQL can be generated
dynamically without the use of a stored procedure? I need to build a WHERE
clause depending on the arguments passed from a window. For example I need
to query on last name, first name, and middle name if all are provided. Or,
I need to query only on last name and first name when middle name is not
provided. Thanks in advance.
There are actually several different ways that you could accomplish this...
You could create your datawindow with no where clause, but define all of the
retrieval arguments...All my task list entries were gone!, powerbuilder is getting closed when i click on the Task list icon
I am using PB 10.2.0 Build 7516. I have created a list of Tasks using the
Task List for my current workspace. But suddenly when I click on the Task
List icon the PB is getting closed, Application error occurs.
How to recover my Task List!!, How to solve this issue,
Any body have idea, pls share it with me
Rammurali Krishnan B