datawindow expressions using datacolumns from other datawindows
Is there a possibility to access datacolumns from other datawindows from a
In fact, I have two datawindows which have a master/detail-relation. For
example I want to set a columns visible or protect property in the detail dw
depending on the datavalue of a column in the master dw.
There is no direct way. You could, however, write a couple global
functions... one to set a value, one to get a value (then call these from a
computed field in the DW)... but you're probably better off doing this in a
...DataWindows Expressions for contraints on grid datawindows...
This may seem like an unholy thing to do to a datawindow, but I ran
into a place where it was appropriate. First, I decided that I wanted to
use Don Roof's dropdownfilter service for datawindows, which is
triggered by clicking on a small bitmap icon which is supposed to be
positioned next to the column heading. This is fine for the tabular
style that Don's samples used. However, I wanted to use a grid-style
datawindow to allow my users to resize columns while the application is
running. Unfortunately, the datawindow tries to resize the bitmap when
the column is resized, makin...Use DataWindow Object Properties in DataWindow Object Expression
Can I make use of the properties of objects in the expression?
For example, can I set an expression in COLUMN_A's color property which
reference the color property of COLUMN_B. I don't know how to access
properties in expressions. Can anyone help me? Thanks.
You can use the Describe() function.
Alex wrote in message <362D543F.F34B5F33@hotmail.com>...
> Can I make use of the properties of objects in the expression?
>For example, can I set an expression in COLUMN_A's color property which
>reference the color property of...Can DataWindow.Data.HTMLTable handle DataWindow expressions ?
I have a couple of DWs that I am saving as HTML. I use
'DataWindow.Data.HTMLTable' to get the html (I've also tried data.html). I
prifix this with the StyleSheet in order to get the layout correct i.e.
bold, colours etc..
One DW is very simple and works no problem. The other (external) DW is very
complicated and has loads of columns. Depending on various column data
values, all the columns have expressions to control things like x and
coords, height, width, visibility etc.. When I get the HTML the layout is
not correct. Some column are not displayed when the...datawindow expression
I'm trying to do something that sounded so simple, but I cannot figure it
out. I want to change the background color of a "cell" in a grid datawindow
when it has focus. Not the background color of the entire column or row -
just the cell which represents the current row and column. I cannot find
any datawindow function that tells me the current column. Can it be
determined with the Describe function? I tried "GetColumnName" inside a
Describe, and of course that is not valid. All the datawindow functions
seem to apply to rows, not columns.
Does anyone ha...datawindow expression
In PowerBuilder a datawindow expression can call a global
function. Is there a similar possibility/feature in
Not at this point.
On 17 Aug 2004 02:54:20 -0700, jan wrote:
>In PowerBuilder a datawindow expression can call a global
>function. Is there a similar possibility/feature in
I have an expression to change the color of text on row in a datawindow ,
'if (change_colour =1,rgb(255,0,0),rgb(0,0,0) )', but what I am trying to
do is only change the color of a particular column on the row.
Is there any way to do this? All the columns have to have the expression
but any combination of the columns are to have the color change.
Hope that makes sense.
If I understand the question correctly, you can put the expresion in the
datawindow. Go to teh datawindow painter and click on a field (column) you
want to have use the expression. (PB8)...datawindow expression
I made an expression on my datawindow level : for example
the border expression :
Now I want to get this syntax via script on my window level
How can I do this so that I can also put this or another
expression back to the datawindow expression ?
This also gives me data in the field, but what do I have to
do to get only the expression ?
Thnx in advance
You should post this in the powerbuilder.datawindow section.
On 14 Oct 2004 05:41:24 -0700, Dave wrote:
>I made an expressio...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...Anything Like GetColumn() datawindow method in DataWindow expression function
I'm Using PB703 Build 10213
I'd like to know if there is any DataWindow expression function that could
give me the current Column on the DataWindow! Sthg like GetColumn() method
I've got a tabular datawindow, where I want to change the Border of a column
when it is the current column (Just for the current row, too)! Is there any
other way to do It?
Check your event arguments for "DWO". That is a pointer to the current
To check the name for example:
ls_var = DWO.name
Hope that helps.
regards ... Chris
...Datawindow, Protect property, add datawindow expression to control setting
There is already a Protect property for datawindow columns which can be an
expression. Did you mean the ReadOnly property of the whole datawindow?
Matthew Chestnut wrote in message <firstname.lastname@example.org>...
Oops, I was in a hurry when I entered this ... I meant to request an
expression on the *Required* attribute for a datawindow column.
On Thu, 7 Mar 2002 14:48:33 -0500, "Jerry Siegel"
>There is already a Protect property for datawindow columns which can be an
>expression. Did you mean the Re...Datawindow Expressions
I'm having a problem that I hope someone can help me with. I'm trying to
change the attributes of a datawindow in PowerBuilder 6.5 so that the list
of available radio buttons defined for a column is dynamic. Specifically,
if a flag column in the datawindow is set to a 1, I need an extra
radio-button added to the list of available selections. Otherwise, it
should not be present. I've been looking at the .Values attribute for the
datawindow object and I can manipulate it to change the available options
but only when I don't have an expression. I just c...datawindow expression #2
what is wrong with this
ls_modify = "inc_exc.visible=0~tif (cashincluded ='Y',1,0)
ls_error = dw_modeldetails.modify( ls_modify)
It says incorrect syntax.
The visible expression should be a string, and needs to be in quotes.
(Then you're inner quotes need to be tilde'd... I'll leave that joyous
experience for you. <beg>)
Terry and Sequel the techno-kitten
On Fri, 28 Nov 2008 03:58:04 -0800 (PST), Brijesh
>Hi G...Datawindow Expression Problem
Trying to use an expression in a datawindow to make a filed visible
based on the entry in another. Example 2 columns: name, other_name.
If other_name is not null, then display name.
Tried putting 'isNull( other_name)' in the expression on the name filed
but it doesn't seem to work.
Any help appreciated.. Thanks JB
John Bringolf <email@example.com> wrote in article
: Trying to use an expression in a datawindow to make a filed visible
: based on the entry in another. Example 2 columns: name, other...