Setting the value of columns in Datawindow Expressions
Is it possible to set the value of a column in a datawindow expression. I
have used the gettext to get the value of a column but can I set it. I
would prefer coding code within the datawindow than to write script for
Thanks in advance
No. You can set the default value for a newly inserted row in the column
specifications, but that allows only constants, not expressions.
Derrick Chan wrote in message ...
>Is it possible to set the value of a column in a datawindow expression. I
>have used the gettext to get the value of a column but can I set it. I
>would p...Datawindow Displays Data Column Names and Expressions instead of Values
This is a multi-part message in MIME format.
The following expression is used for the VISIBLE expression on 4 data =
IF(evaluate_subject =3D 'Ending Backlog' OR left(report_type, 4) IN =
('SOLD', 'UNSO'), 0, 1)
The expression validates as VALID. However, when the datawindow is =
generated and data placed into it, when displayed on screen, it displays =
not the data but all the data column headers an...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 <email@example.com> wrote in message 36D52106.433CE9B2@188.net...
>I have a free style data...get column value in DW expression without column name
I've got a common experssion that I'd like to put on every
bold column property: I'd like set the column font to bold
if the previous column value is equal to the current. As I
have many columns, even dynamic columns, I don't know their
name in order to set an expression like this: "if (col_name
= col_name[-1], ...)"
So any idea?
get all object names using the expression
"datawindow.objects", split this tab separated
list into single object names, check every object
wether it is a column using the expression
&quo...How to Modify Contents of a DataWindow DDLB column based on value of another column in the same row.
I'm trying to conditionally Modify the contents of a DataWindow DDLB
column. For example,
ls_modstr = "cp_basis.Values='5 Test~t5~tIf(cp_type=~~'TB~~',30 Day~t30,3
ls_rtn = This.Modify(ls_modstr)
Does anyone have an example of syntax that works?
I don't believe the values attribute will actually accept a function. Have
you thought about using a DDDW instead and applying a filter dynamically?
On Wed, 20 Feb 2002 11:10:21 -0500,
>...Datawindow Expression value
How do I get the actual value of an expression?
for example dw_1.columnname.Protect
value = dw_1.columnname.Protect
if value = 0 then
// do this
// do that
Use the evaluate keyword.
<Josiah Ward> wrote in message news:firstname.lastname@example.org...
> How do I get the actual value of an expression?
> for example dw_1.columnname.Protect
> value = dw_1.columnname.Protect
> if value = 0 then
> // do this
> // do that
> end if
...visible expression for columns in a datawindow
I hope there is anybody who can solve the following problem:
I want to make a column in a datawindow invisible. So I have inserted
the value 0 into the visible
expression of the column.
If I make a preview of the datawindow the column is really invisible.
But if I insert this datawindow into a composite datawindow and make a
preview then the column is visible. Has the visible expression no
Would it help to set the width to be 0 (maybe the height too)
Does the composite alway show the dw the way it is presented in the dw
painter rat...Initial values for columns in datawindow
I have a button in a datawindow that appends a row which works fine. What I
would like to happen is have some columns have an initial value. These
initial values will vary based on the arguments to the SELECT statement used
to retrieve the existing rows. Can I use the arguments or global variables
to set these without putting code in the buttonclicked event?
you can change the initial value with pb scripts, e.g.: dw_1.object.columnname.initial = "abc"
see Initial DataWindow object property for details.
"Don" <email@example.com> �b�l...Defining an expression for a datawindow column
I want to define an expression for the 'Protect' attribute of
a datawindow column. I need to use a global variable in this expression.
Is this not possible ? Am I allowed to build the expression using only
the columns listed in the 'Modify Expression' box ?
You can use a global function in a Datawindow expression. This function can
return the value of the global variable.
If everything seems to be going well, you have obviously overlooked
eMail: j...expressions to change column values
I was wondering if anyone knows if it is possible to use the text of one
column to determine the text of another column.
Column A has a value of "-2". I would like to put in an expression that says
if( a.Text = "-2", b.Text = "New Value", b.Text = "Original Value" ).
I tried putting that exact code in the expression( don't remember which
one ), but it didn't work. Has anyone done this or knows how? Thanks
Mel Haynes Jr
Retail Solutions Group, LLC
A column can be accessed in an exp...Choosing between two column values to return as single column value
I'm working on a social network where I store my friend GUIDs in a table with the following structure:user1_guid user2_guidI am trying to write a query to return a single list of all a users' friends in a single column. Depending on who initiates the friendship, a users' guid value can be in either of the two columns. Here is the crazy sql I have come up with to give what I want, but I'm sure there's a better way... Any ideas?SELECT DISTINCT UserIdFROM espace_ProfilePropertyWHERE (UserId IN
...SetNull to a column value in a Datawindows
I�m trying to use the set null value
for column in a datawindows. The problem is that i have a datawindow
external with two columns, each one of this columns contain a datawindow
These make a function like a master detail. one dwChild(dwchild1) is
to a table product_group and the other one(dwchild2) to a table product.
When i get the selecci�n of the group in the itemchanged event of the
retrieve is executed with one retrieval argument (group), and the list
filtered out by the group selected is show up.
I need to clear the val...column status in datawindow expression
How can i check the status of a column in a datawindow expression
On 19 Mar 2006 04:01:27 -0800, "Sukhvinder Singh"
>How can i check the status of a column in a datawindow expression
For rows there are functions IsRowNew() and IsRowModified(). There
are no equivalent functions for the columns, but you can access the
column original value through dot notation:
So you could do something like
IF (column_name = column_name.original, "NotModified", "DataModified
or Null&...Matching each value out of multiple values to single column value
Hi, @whoposted in stored procedure holds value "agent builder owner" ( please note the space in between) My column POSTED_BY always holds one and only one value out of above 3.Example: POSTED_BY owneragent etc... If All / any of the value hold by @whoposted matches with value of POSTED_BY column, i want to show that row in gridview.( Also, please note, str may hold different values depending on user selection. For example, it may ...How passing values to hidden DataWindows columns
I build a DataWindow (DW) to create new data records, but some values are
constant or PageParameters from previous called html sites.
How can I transmit this data to hidden columns of the DW.
The hidden columns needs to be not NULL when I click the CREATE-Button.
Is there a standard way without modifiying DW-Code manually after
Are there examples for this task?
you could use callback functions to achieve what you want. If you check the
"Enable User Callbacks" box on the "Context" tab of the DTC object PowerSite