Stack Overflow
Stack Overflow

Questions tagged [datawindow]

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.

212 questions
2
votes
2 answers

How to include filtered rows in a datawindow computed field for Sum (PowerBuilder)

I have a datawindow that has 2 groups (Company and Department). I need to show the overall total amount for the company even if the user has filtered by Department. Data Scenario Company Department Role EmpCount ABC X …
Stephen J
  • 21
  • 3
2
votes
4 answers

Usage of ~t in powerbuilder

I am using powerbuilder 11.5 using this method to set font weight of column name. What is ~t used for??.Why is it necessary to add it in statement. Without it error is thrown. dw_1.Object.name.Font.Weight = & "700 ~t If(state = 'MA', 400, 700)"
Mohit Jain
  • 733
  • 3
  • 9
  • 24
2
votes
1 answer

Powerbuilder saveas xlsx, after 170000 rows it's not working, returns -1 or crashes

I have an issue when using DataWindow SaveAs function. Previously the function was working with Excel8 format and the rowcount didn't exceeded 65536. But now there could be 300000 or more rows in the DW that needs to be exported. I've changed the…
Zoltan V.
  • 21
  • 1
  • 2
2
votes
1 answer

Design Preview mode is not working with Label type DataWindow

I am new to PowerBuilder. I am trying to use Design Preview functionality to change attribute of column at run time. It is working fine for free form DataWindow but when I tried to use same feature with Label type DataWindow then only X and Y…
user1318718
  • 21
  • 1
  • 5
2
votes
3 answers

How To Delete Extra Columns in PowerBuilder's DataWindow

I have a combination of 2 DataStore, lds_header and lds_detail which is fetching data in 1 DataWindow. I've set the columns of the DataWindow based on the columns of the header. lds_header has 10 columns to export for header segment - holds in…
RedHat
  • 205
  • 2
  • 12
  • 24
2
votes
2 answers

Can't change Column color at runtime if its default color is "Transparent"

I use the following code to change the color of particular columns when I open the datewindow up for editing: dw_1.object.description.Background.Color = RGB(255, 255, 255) This works great as long as the default background color was not…
FauxReal
  • 4,762
  • 4
  • 21
  • 18
2
votes
5 answers

How do you add a superscript character into a Powerbuilder textbox?

Is there any way to do this in the Powerbuilder properties window for a datawindow's textbox?
Glenn Wark
  • 1,499
  • 4
  • 19
  • 23
2
votes
1 answer

is it possible to use a `WITH` clause in a DataWindow query?

I have a DataWindow in a PB10.5 application which works perfectly until I add a WITH clause to the top of the SQL query that sits behind. The query painter accepts it as valid syntax, and if I manually retrieve the data in the DataWindow painter, it…
ninesided
  • 23,085
  • 14
  • 83
  • 107
2
votes
1 answer

DataWindow displays contents in Debug, but not in RunTime

I inherited this Powerbuilder 12.0 project. We needed to add another datawindow (which is more or less a copy of another datawindow, but with different sql tables tied to it). When testing the datawindow in Debug mode, the "report" shows up just…
tobbiefox
  • 83
  • 2
  • 15
2
votes
1 answer

calling an event on a Button in datawindow

I have placed a search button on a datawindow, and i have already an event for searching such list...how is it possible to call an event once the button is clicked on runtime. below is the code on my event named "ue_key" string xcode, iseries,…
Mae
  • 21
  • 2
2
votes
1 answer

PowerBuilder DataWindow object Edit

I have a DataWindow with some columns. One column contains numbers of a certain object. I want to put a Edit(mask?) on this column, so that when it is bigger than 0, change column value to "Available". How can I Achieve this in design view?
Lucas Arrefelt
  • 3,879
  • 5
  • 41
  • 71
2
votes
1 answer

Powerbuilder Datawindow Crosstab Display

I have 20 columns and 1 row in my crosstab where display in portrait 8" x 13", now when I print out the first 14th columns is display in the first line of page 1 then the next 14th above columns is display in the first line of the next page. …
user1705208
  • 33
  • 3
2
votes
1 answer

how to code the itemchanged event and datawindows

I am using PowerBuilder classic 12.5 am having difficulties in inserting, editing, creating and printing reports. i have a datawindow, dw_NewEmployee with dataobject, d_newrecord which is update-able. should i use the columns to insert records…
Wepex
  • 163
  • 4
  • 13
  • 32
2
votes
2 answers

PowerBuilder DataWindows

I am building a tool that can outputs certain information from the input. I have this free form DataWindow with textboxes and a button( button_1 ). Let's say I have a Window Button [ADD] and when clicked will trigger dw_1.InsertRow(0) The textboxes…
Sid
  • 765
  • 5
  • 29
  • 57
1
vote
1 answer

Report Detail Band Not Populating

I am new to PB and retrieving my report. My header and footer populate but not my detail band. My arguments seem to be working correctly. Any ideas:
doug
  • 221
  • 3
  • 5
  • 12
1 2
3
…
14 15