Is DataWindow 2.5 in Dw.Net is same as DataWindow in PB11.2
Hi there ,
Can anybody confirm the said subject is a valid statement ?
Dw.Net2.5 = PB11.2.DataWindow ????
How about the future enhancements which are planned for PB11.5 and future
releases of PB...
Will it not always be in the same codestreamline ?
Regards , Van
I mean how will be co-relate the three products from Sybase
1) DataWindow.Net 2.5 for Visual Studio 2008
2) PocketPowerBuilder Datawindows
3) PowerBuilder11.2 and Powerbuilder1x.x Datawindows
All everthing is remain the same in all the above three products as far as
Datawindow properties / events /...Sharing data between 2 nested DWs: a graphic DW and a crosstab DW
I got a composite DW with lots of nested DWs. Among them, I
have a graph DW and a crosstab DW with the same SQL. As the
amount of lines retrieved is above 20,000, I'd like to share
the data between the 2 nested DWs. First, I put an argument
in each one, so the graph DW brings all the lines, and the
crosstab DW brings none. Then, after the retrieve of the
composite DW, I get both datawindowchild and run ROWSCOPY
from the graph to the crosstab (sharedata doesn't work for
crosstab). After that, run SORT and GROUPCALC for the
crosstab DW. The lines are copied, but the crosstab DW
...Datawindow Sort #2
i've a grid datawindow with a column call client_id.
This column has a dropdowndw edit style.
Can i sort the principal datawindow using the display column of this dddw ?
Thanks for your help,
Get Real Systems Ltd
Holtby Manor, Stamford Bridge Road, York, YO19 5LL
Tel 01904 481999 Fax 01904 481666
Visit us at www.getrealsystems.com
Specialists in e-Procurement and supply chain technology
"Carles Molina" <email@example.com> wrote in message
news:IVNf2SUWAHA.162@forums....Sorting in datawindow #2
I'm attempting to use the sort in the DW. It does not appear to be
working. Is this feature for data from a database only? I appreciate your
You will have to give more information.
You can sort the columns and computed fields (data not directly from the
database) ... in the datawindow. You just have to have a name for each
Are you trying to sort using code? Are you sure you are using the correct
names of the fields? Right click on each field
and get the name of it. This is the names you must use in your sort. If
it doesn't have a name then you mu...Datawindow Sorting #2
I'm using PB703 Build 10213
I face a strange behaviour by a datawindow used on a DataStore.
The object retrieves data using a SQL Statement that includes no ORDER BY
Also there are no sorting criteria on the object.
On Runtime I set the object on a datastore and I Retrieve.
After that I do the following.
For ll_I = 1 to ds.rowcount()
/* First come the rows with null values, then the rows ordered
by date */
ds.setsort('Char1Field DESC') /* Char(1) Field, Values &...CrossTab DataWindow #2
CrossTab DataWindow :
It 's very nice to build quickly this kind of report !
But, It starts to become a nightmare when you've to change something like :
Add a column, modify the SQL...
All the graphic is reset (Compute fields are deleted, properties are
reset...All the work has to be done again !)
I'm just wondering if i can cary on to use this type of DW...
Is it a bug PB or is there something to do to fix this problem ?
I'm using PB 6.5.
Tanks a lot for any suggestions !
...Crosstab datawindow #2
On a Crosstab datawindow, I use an expression to set both the
Background.color and the color property for a column. When I run the
application from PowerBuilder (version 6.5) everything works fine. However
when I build an exe, the expression setting the Background.color property
fails and the background for this column always appears as black. The font
color though is okay. Does anyone know why the exe behaves differently. The
application runs on Winodws NT 4.0
When you program behaves differently when you create the Exes this for me
has always meant that you have the wrong...Crosstab DataWindows #2
I need to create a Crosstab DW that resumes the information from a table.
This table contains the following columns: Quarter, Products and Quantity
and I want to create a very simple Crosstab DW with this tree columns
(Column, Row and data respectively). Besides I would like to create a
computed field, that should go with each data field, that resumes the
percentage of increment of each quarter compared with the last one. Do you
know if it posible to create this computed field?
...Crosstab DW #2
How can i get the column names in a Crosstab DW, is there an example or
some code you can provide me?
I would appreciate your help
To get the list of columns you can do
count = integer(dw_x.Describe("DataWindow.Column.Count"))
for i = 1 to count
name[i] = dw_x.Describe("#" + string(i) + ".name")
if by columns you mean columns and expressions then you would do
tab_list = dw_x.Describe("DataWindow.Objects")
then parse that tab separated list and check objects types using construct like
type[i] = dw_x.Describe(object...crosstab dw #2
I have build a crosstab datawindow for my report, and design
it with logo, title...etc readjust column,hide...etc.
But, now, i need to modify my query. But, once i modify my
query, like convert date to string, and select ok, my
previous design get messed up,it get fallback to original.
What can I do to avoid this? Please help. Thank you.
You may want to "edit source" instead of using the dw painter. Right
click on the dw in system tree and select it from the pop up.
On 1/6/2011 3:22 AM, genie wrote:
> I have build a crosst...PowerBuilder DataWindow #2
I have a requirement to implement a master-detail sheet. That's ok.
However, based on the user-logged-in credential, the user may OR may
not be able to edit the details part.
Now I can easily implement this by adding a constraint while updating
the details' data.
if user_can_edit then
The problem is this:
If the user is not entitled to make changes, he is still able to put
focus to the details' form data and modify (of course I am not
updating it)...but the user can get a feeling "oh I am able to modify
Is it so...How To copy rows from crosstab DW to crosstab DW
i am using pb8 and i am trying to copy rows from crosstab DW
to crosstab DW,
But the return code is -1 why?
How can i copy rows from crosstab to crosstab or shardata
from crosstab to crosstab?
...CrossTab Datawindows #2
I need to export a crosstab datawindow to an excel spreadsheet, the
saveas function does not bring the column headings into Excel or any
Is there a way to get the column names from the crosstab datawindow from
...Sorting a crosstab DW
I have a crosstab DW with an SQL statement that is ordered by EmpName. I
also specified a sort expression in the DW using the same column, which is
the leftmost DW column. When I run the DW the data is not ordered by that
column. Rows are shown in groups that are ordered by EmpName, each group
corresponding to each one of the other columns of the DW. Is this normal? Is
there a way to force the sort order I want. I have tried SetSort() and
Sort() with no effect.