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...How to share the datawindow to inner datawindow of nested datawindow
How to share the datawindow to inner datawindow of nested datawindow.
dw_1 is normal datawindow dw_nes is nested datawindow, both are placed
dw_nes contain dw_child datawindow
i want to share dw_1 and dw_child.
I have tried the below code, getting error
It's the dot notation. You will need to dw_nes.GetChild("dw_child", ldwc)
where ldwc is a _local_ datawindowchild.
<email@example.com> wrote in message
news:firstname.lastname@example.org...Datawindows with child datawindows
I want to create a datawindow whose only data is three columns that will
themselves be drop-down data windows. These child datawindows will be
populated in PB script with dw_1.GetChild(). When I create that parent
datawindow (New | Datawindow | Freeform), what do I choose in the next
dialog box ("Which datasource would you like to use?") External?
That depends on how you want to populate and use the columns of the main DW.
The DDDW is an edit style that assists the user in selecting a value for the
column in the main DW. If you want to retrieve the values ...DataWindows and datawindow objects
Difference between Datawindow and datawindowobjects?
- datawindow is a control on a userobject or a window
- datawindowobject (DWObject) is a control within a datawindow, defined in
the dataobject of the datawindow.
You refer to it as <datawindow-instance>.Object.<datawindow object>
<Santhoshi> wrote in message news:email@example.com...
> Difference between Datawindow and datawindowobjects?
DW Control is a "container" that reserves real-estate on the surface of
a visual object.
DW Obj...Cross tab datawindow crashes
I have been using powerbuilder 6.0 application with sybase as database
Now we are migrating our database from sybase to sql 2008.
After migration of database, every data window is retrieving data
correctly except for one cross tab data window.
earlier Crosstab datawindow was using sybase stored procedure as
datasource and works fine.
But same procedure when migrated to SQL, crosstab datawindow crashes
with some sybase product error and closes application.
But strange thing is that when I run application through PB data
retrieves correctly and when I b...Cross Tab Datawindows
Does anybody know if it is possible to conditionally format a computed field
in the trailer band of a cross tab datawindow.
My cross tab has a column called compute_0008 which gives a value for every
There is a computed field in the trailer band called sum_compute_0008 and I
want to modify the background.color of this computed field based on the
value of avail_date (e.g. Weekends one colour and Weekdays another).
I have tried
dw_1.modify("sum_compute_" + string(li_count) + ".background.color ....
Add direct setting and getting capability for the datawindow where clause.
This would have to be a string array in case of unions.
Return ONLY the where clause(s) in the main select (in case of sub-selects,
ignore the where clause or somehow list it as a subselect in the where or a
subselect in the select).
It would be great if I could just get and set this as a value and have the
datawindow automatically change (or add) the where clause as specified.
This is for setting the where clause dynamically at run time. Currently
have to parse through the datawindow.table.select looking f...Help on Cross tab Datawindow
Can you please refer some good links regarding Cross tab
datawindows? I work for two years in PB, but have not yet
used these much. Thanks in advance.
...Cross Tab Datawindow #3
I have a composite datawindow report with a nested datawindow on it. This
nested datawindow is a cross-tab datawindow which is used to show the tax
year descriptions as different columns at runtime.
The tax year description is retrieved from database table. For most of the
time there are several years which get retrieved per run.
For the column of the last year retrieved, instead of displaying the actual
year description retrieved from the table(like 2003 or 2004), I want to
dislay some other string like ("Post Assignment Year").
How to change it in this...cross tab datawindow #2
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
Could any help me out in creating this type of report using crosstab
datawindow style. (dynamic
The data source is stored procedure
The following data is retrieved from the stored procedure:
1. Mat proceeds
2. Type -
3. Subtotal (mat proceeds)
5. Subtotal (interest)
6. grand total (3+4)
8. subtotal (new issue)
My requirement is like this:
----...DataWindow Within DataWindow
How Can I access/modify object/control from a Datawindow within Datawindow.
When i access/modify object/control from a Datawindow i used
dw_1.modify("name.text = 'new val'") but within another datawindow or child
datawindow it doesnt work.
Your description is difficult to understand due to the terminology. First,
a datawindow is assigned to a control - either a datawindow control or a
datastore. Second, the Modify function can only be called within a script.
With that as a basis, can you rephrase the question and describe more
precisely what you want to do? ...modifiyin a datawindow in a datawindow
When I want to modify a datawindow, then it's just
But what do I have to do when I want to modify a datawindow
in a datwindow ?
I tried : dw1.dw2.modify() but that doesn't work.
Anyone can help me out with this ?
get the dw via getchild & apply modify
In article <firstname.lastname@example.org>, David says...
> When I want to modify a datawindow, then it's just
> But what do I have to do when I want to modify a datawindow
> in a datwindow ?
> I tried : dw...datawindows in composite datawindow used in datawindow.NET, are not sliding up
Problem: datawindows in composite datawindow used in "datawindow.NET", are
not sliding up ,
if one dw is not visible or did not retrieve data. Resulting in unwanted
The height of blank white space is equal to the height of the datawindow art
datawindow with height 0.00in
which is supposed to be not visible. Tried different options with
html/xhtml/xml same result.
But slides up ok when exported to pdf(using saveas) on web and in PB10.5
Also s...Cross tab Datawindow erro
We migrated PB 9 to PB 12. After migration when we are
running report we are getting --> "Please refresh your
We are running against MS SQL Server 2000.
Thanks for your help.
1) Are you using PB 12.1?
2) Are you using the same DB connectivity option?
3) If you open and run (preview) the DWO in the DW Painter - does it give
you the same error?
Regards ... Chris
President: OSUG / STD Inc.