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
1
vote
3 answers
PowerBuilder - dynamic DataWindow from Cursor
How to create dynamic DataWindow in PowerBuilder?
I have procedure in database which return me a cursor.
How with this cursor I can create DataWindow with columns?
Example1:
Cursor:
SELECT DATA, ID FROM TABLE1
I want DW with columns:
DATA,…
Piszu
- 443
- 1
- 8
- 24
1
vote
2 answers
PowerBuilder 12.5 Classic PDF SaveAs creating files of 0 size on Win7 x64
Platform:
Windows 7 x64
PB 12.5 Classic
Ghostscript 9.07 (both x32 and x64 are installed)
HP Laserjet PS printer installed as "Sybase DataWindow PS"
Datawindow's Data Export tab has Format to configure: PDF and Method: Distill. Both the checkboxes…
somnath
- 1,337
- 1
- 9
- 13
1
vote
2 answers
PowerBuilder Composite Datawindow
I've got an composite datawindow with 2 reports, one in the detail band and the other one at the summary. My expected result is that the report in the detail band comes first and when that has reached it's end then the other report starts. However…
Lucas Arrefelt
- 3,879
- 5
- 41
- 71
1
vote
2 answers
PowerBuilder Describe method with Evaluate expression vs. GetItem... (GetItemString, ...) DataWindow methods
Is there any significant performance difference between using of Describe method with Evaluate expression in DataWindow control and GetItem... (GetItemString, GetItemDate, GetItemNumber, ...) DataWindow methods?
l_s_ret = l_dw.Describe("Evaluate(~""…
4ir4o
- 37
- 1
- 10
1
vote
1 answer
Powerbuilder 12.5 - Functions on DataWindows
I have noticed a change in behaviour between PB12 and PB12.5 (both patched).
I have quite few datawindows with global functions on them. In previous versions of PB these functions only got fired on when the datawindow got focus (getfocus event) -…
Peter
- 11
- 2
1
vote
1 answer
Grid DataWindow Issues in PowerBuilder
I have a Data Window to display data from DB, and the following code in DW clicked event to display latest data from DB.
if row > 0 then
ReselectRow(row)
end if
I changed Data window style to Grid style. Now if i click on a row in DW it Is…
Suresh Vadlamudi
- 61
- 7
1
vote
1 answer
PowerBuilder dropdowndatawindow insertrow changes Display Column value
Working with PowerBuilder 11.5.
I have a datawindow (dw) consuming a dropdowndatawindow (dddw). I am performing dddw.insertrow (0) in the constructor of the dw, and then doing dw.insertrow().
The issue I am having is that the value of "Display…
Usering
- 143
- 3
- 20
1
vote
2 answers
powerbuilder datawindow validate records
close to 3 months into powerbuilder classic 12.5 and sql server 2008 and am working out well. I am creating a car hire system using car registration_number as the primary key.
i need to capture the car's details and make sure that the…
Wepex
- 163
- 4
- 13
- 32
1
vote
2 answers
How do I get a DataWindow to save correctly to PDF?
Here's my problem.
I currently am trying to print a DataWindow to a PDF file in PowerBuilder 12.5. I got some code, and it currently looks like this.
//dw_1.Modify("Datawindow.Export.PDF.Method = Distill!…
user1519082
- 33
- 1
- 2
- 4
1
vote
1 answer
Generate attachment for email in PowerBuilder
I want to send a mail using Lotus Notes in PowerBuilder. I also want to have a attachment to the mail to be sent.
However the content to be placed in the attachment is taken from a stored procedure.
The attachment is a pdf attachment. Therefore we…
User
- 67
- 2
- 13
1
vote
2 answers
How to Process in DataWindow in PowerBuilder
I am populating a DataWindow with some data. Some of the column names are "Request No", "Status", etc.
"Status" column can contain values like "Pending", "Active","Expired".
Whenever the DataWindow is populated I want to count the number of records…
User
- 67
- 2
- 13
1
vote
1 answer
Add field in DataObject in PowerBuilder
I am new to PowerBuilder and I need to add a new column to a DataObject. The DataObject has several fields which retrieves data using select statement. So if I add a column in the select statement I get another field with a name compute_0041 along…
Raghul Raman
- 169
- 1
- 5
- 18
1
vote
3 answers
Power Builder - DataWindow paging
I'll just straight to the question, does DataWindow control has pagination? Or do we have to write our own pagination code? Can anyone give information about Data Window pagination.
I'm using PB ver 9.0. In what version pagination is available?
PS.…
strike_noir
- 4,080
- 11
- 57
- 100
0
votes
1 answer
Powerbuilder Syntax for dw string replacement
I'm currently importing a CSV File but the problem is that this CSV File is extracted from another different program (w/c I do not control). The excel file is saved as CSV but when you open it in text/notepad. It shows as like this…
Sid
- 765
- 5
- 29
- 57
0
votes
0 answers
PowerBuilder 2019 R3 - Is it the filter method which caused the application to crash?
Our windows application was developed in PowerBuilder 8 and it has been migrated to PowerBuilder 2019 R3. The PB 8 build application is not crashing for a very long time and the filter method is working properly. When it was migrated to PB2019 R3…
RedHat
- 205
- 2
- 12
- 24