The PowerBuilder DataWindow control is a container for database originated data in a PowerBuilder application. It can display the data and optionally let the user modify it and send changes back to the database. In addition to the DataWindow control, the DataStore object provides a non-visual container for server applications and other situations where on-screen viewing is not necessary.
Questions tagged [datawindow]
212 questions
0
votes
2 answers
graph datawindow shows error when procedure is changed in power builder
I have a userobject where I have used graph datawindow in it. Can I change the procedure in that graph datawindow without recreating datawindow? I tried using syntax
datawindow.table.procedure =
But I got an error telling error…

user70922
- 1
- 2
0
votes
1 answer
how to copy checked rows to another datawindow?
So I have two datawindows, and in the first DW I have a checkbox per row. Now, I want to copy/send the checked or selected rows to the 2nd DW on a click of a button. Can you please enlighten me on how to do this? TIA. :)

Dac
- 210
- 3
- 19
0
votes
2 answers
Datawindow query is not respecting ORDER BY clause
I'm developing a form in order to have an order form for procurement purposes.
I've a Datawindow as a report object inside my main form. This datawindow (sub-report) has a select to retrieve the orderlines for that order form. Everything is working…

ɐsɹǝʌ ǝɔıʌ
- 4,440
- 3
- 35
- 56
0
votes
4 answers
PowerBuilder Datawindow EditMask for IP Address
Please help me for writing datawindow editmask for IP address. Currently I am doing like this
###.###.###.### but it can also allow 300.300.300.300, and a valid ip address only allows maximum 255.255.255.255. Please guide me. Thanks

mfn
- 45
- 1
- 3
- 10
0
votes
2 answers
issue appears only in generated app.exe and dont appear in the sources' execution | PowerBuilder
I have an issue when i execute my app.exe, there is an error which is revealed only in the ".exe", if i try todo the same thing when i use the sources, there is no problem, i think the problem is when there is a call of the update method from a…

3bdl1
- 33
- 4
0
votes
1 answer
Strange DataWindow sort with negative numeric string
I have a sortable DataWindow in PowerBuilder (both 9 and 12.6) that is giving me the collywobbles. I have a field called Category, defined as a Char(4). The form that populates this field restricts it to 4 numeric characters. Smartass tester me saw…

SarekOfVulcan
- 1,348
- 4
- 16
- 35
0
votes
1 answer
Saving a composite datawindow in PowerBuilder
Is there a way to save results in a composite datawindow as a text or excel spreadsheet? Powerbuilder states for composites the format to save it is PSReport. That doesn't work for what I'm trying to do. Is there any other workaround for this issue?

PBNick
- 55
- 1
- 11
0
votes
1 answer
Entity Framework objects from SQL Statement
I've been working on a project which is based on PowerBuilder and DataWindow objects.
Now, one of the things we want is to "grab" the DataWindow objects and convert them to .NET objects (in C#) by basing them on the query. From that query I want EF…

Zed_Blade
- 1,009
- 3
- 18
- 38
0
votes
1 answer
Can you have a datawindow that runs more than one SQL?
I'm pretty new to programming and PowerBuilder in general. I was wondering if it's possible to have one datawindow but multiple SQL statements? I would like it to run one statement if one radio button is chosen or another statement if a different…

PBNick
- 55
- 1
- 11
0
votes
1 answer
Powerbuild 12.1 datawindow Saveas with limited file types option
I am using PB 12.1 Classic on Window 7.
When we use datawindow's saveas(), it either displays all files type or one specific file type based on saveastype argument. We need to display only certain filetypes e.g. CSV, Text, Excel, HTML and PSReport.…

SK_78
- 1
0
votes
1 answer
Unable to get datawindow group trailer and summary to slide up
I have
a report with grouping.
some items displayed on the group trailer band
an autosized datawindow in summary band
a footer band
A run of the report brings 5 rows of data returned in the report's detail band.
The problem is, the report…

Azeworai
- 772
- 3
- 9
- 25
0
votes
2 answers
Powerbuilder 12.1 and DataWindow in Design vs Debug and Executable/Runtime
I have a very strange situation with Powerbuilder 12.1. I have two issues that may be related - mainly because it's for the exact same datawindow report.
Issue #1: Somehow and somewhere, the capability to display contents of a DataWindow during…

tobbiefox
- 83
- 2
- 15
0
votes
1 answer
Load Excel File To Powerbuilder
I have this code for buttonclicked event to load excel and text file to powerbuilder and the excel data is not copied i.e ll_return_xls <= 0 and thus when i want to load it to db i will get error since it has no value or data in it...The problem…

Alloice Kiprop
- 23
- 1
- 8
0
votes
3 answers
How can I group data in datawindow
I want to create a report on which data shows in group. I have tried but the report is not made as I require. If a number of rows have the same value, then data should be printed only one time.
name category value
FCL 1 3
FCL 1 …

rahul jain
- 143
- 1
- 3
- 12
0
votes
3 answers
How to break the entire group when limited space in datawindow (Powerbuilder 11.5 build 2506)
In Powerbuilder, how can I break the entire group to another page when there is not enough space for the whole group?
I don't want to break the group every time when the content of column of the group change, but only break automatically when the…

calvinyankf
- 35
- 2
- 6