Setting column's property in a datawindow from composite datawindow
I know this is easy but I cant get it to work.
I have two datawindows controls (dw_1, dw_2) in a composite datawindow
I want to change Text of a header column of dw_2, so I try it using:
1. GetChild and Modify
dw_Report.SetTransObject ( SQLCA )
li_Rtn = dw_Report.GetChild ( "dw_2", ldw_Child )
/* This returns 1, no problem */
If li_Rtn = 1 Then
ls_Error = ldw_Child.Modify ( "item_number_t.Text = ~'New Text~' ")
/* ls_Error is empty string, no problem, but report do...how to get the crosstab datawindow's width
please tell me, thanks
...how to get Crosstab datawindow's width
PFC datawindow service has a function of_getwidth() , I can use like this:
ldl_width = dw_1.inv_base.of_getwidth()
BUT when my datawindow's style is crosstab , it can not work correctly ,
because the width is changed dynamically !
so how to get the width now ?
If the crosstab datawindow has a "grand sum" column that I believe it
creates by default, the you could do the following:
li_width = integer(dw_1.describe("grand_sum_field_name.x&q...How to add oracle's CLOB column to PB10's datawindow
I try to show all record from product table in DataWindow. The backend
database is Oracle 9i. When I try to drop a CLOB column into datawindow, it
don't allow me to do so.
To use crosstab datawindow when the number of column (vertical column)
are over one page size can has. How to display row name (horizontal
column) in duplicate on the others when I print ?
...column's datatype of the datawindow
Is there a way to write PowerScript to get the datatype of the column in the
datawindow? If yes, what is the syntax?
Kevin Dinh <email@example.com> wrote in message
> Is there a way to write PowerScript to get the datatype of the column in
> datawindow? If yes, what is the syntax?
...How to get crosstab datawindow column value
How to get crosstab datawindow column value
Try dot notation. There is a good possibility to show data as well:
MessageBox( "Data", dw_Crosstab.Describe( "DataWindow.Data" ) )
Wisdom Pan schrieb:
> my problem
> How to get crosstab datawindow column value
don't forget to set the statis property to TRUE, before trying to access the
dynamically generated columns.
"Wisdom Pan" <firstname.lastname@example.org> wrote in message
How to g...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 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...Datawindow's Column: Multiline ???
Does anyone know how is it possible to allow multiline editing in a
column object of a datawindow object (instead of having the text
truncated). I know it is possible to do so if the datawindow is in "Rich
text presentation style" but I am not interested in this style since it
is not flexible enough for what I want.
If this is not possible to have multiline diting, I think that it's
quite severe limitation
to the reporting feature of a datawindow.
Turn on autoseize height. You can use ctrl-enter to get line breaks.
Terry Dyk...moving on DataWindow's columns
Tell me please how can I redefine the specified keys for moving on DW's
data. For example, if I press key
"ENTER" I move to the next row of DW. But I want to move to the next column
by pressing key "ENTER".
What is the simplest way to do it?
Check out http://techinfo.sybase.com/css/techinfo.nsf/DocID/ID=44003. It
has everything you need.
Ron Gallagher, CPDP
�������� ���� wrote in message ...
>Tell me please how can I redefine the specified keys for moving on DW's
>data....how to get header text from a crosstab datawindow
I'm trying to read the displayed text from a dynamic crosstab datawindow's
header columns. the header in the datwindow painter is called "val_t" and I can
access e.g its font weight or text (@headline). but I can't figure out how to
get the text that is actually displayed in header columns of the crosstab.
---== Posted via the PFCGuide Web Newsreader ==---
CrosstabData A string containing a tab-separated list of the expressions
used to calculate the values of columns in a crosstab DataW...Datawindow Crosstab column data and headers
How do I access the data in the dynamic crosstab columns? How do I access the
text of the headers of the dynamic crosstab columns?
...delete a datawindow's column
how is possible to delete a datawindow's column once it has been populated?
In other words, I'd like to have a kind of
dw.modify ( "destroy column columname" )
On 30 Jun 2005 06:03:22 -0700, "Marco Meoni" <email@example.com>
>how is possible to delete a datawindow's column once it has been populated?
>In other words, I'd like to have a kind of