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
1 answer
Removing spacing between datawindow bands
I am having an issue with spacing between the summary and footer band. Note, only detail and footer bands are used. Is there a way to remove the spacing between summary and footer band?
i.e i want the footer to be right under the information in…

Raju Kumar
- 1,255
- 3
- 21
- 39
0
votes
1 answer
Set required attribute for column in PowerBuilder
I want to turn off the required behavior for a column in PowerBuilder DataWindow, v10.2.
The database column is nullable, but I get "Required value missing..." if a value is not supplied for the column on an add.

Pete Yankovich
- 11
- 1
- 4
0
votes
2 answers
Powerbuilder DataStore fail only when deployed as EXE (but succeeds as DataWindow)
I have an app which works great in the development environment but misbehaves when deployed as an EXE. When I click deploy and make an EXE, all of my queries which are run through DataStore objects succeed (SQLCode 0) but return zero rows. Out of…

user922020
- 712
- 6
- 12
0
votes
1 answer
Manipulate data between DW ImportClipboard and validation
I have a DataWindow which I would like to be able to fill using copy/paste from an excel document.
It currently imports everything I want except for a date field.
Currently the user manually enters everything from an excel file including a MM/YYYY…

Jake
- 1,207
- 2
- 28
- 46
0
votes
1 answer
Powerbuilder tree nodes selected row colours
I have a tree view DataWindow an when I select a row in ,it, highlights the entire row with the colour blue. How can I set the colour from blue to transparent?

user2773471
- 11
- 4
0
votes
1 answer
how can i change display format in datawindow rather than display data in vertical
powerbuilder.net
What it look like
what I want its look:

user2142324
- 43
- 11
0
votes
1 answer
Send call open event from the event ItemChanged of a DataWindow
I try to send for the Open event of the window from the event ItemChanged a DataWindow using the: SUPER :: EVENT OPEN () in addition to the open event contains "script ancestor" I also need to run; itself need to restart the window from the event…

isidro ruiz
- 13
- 2
0
votes
2 answers
PowerBuilder graph DataWindow
I'm new to PowerBuilder 10.5 so I have a question...
I created a graph DataWindow. It's a usual graph model, with a simple SQL code.
SELECT data1, data2 FROM table1, table2;
Now I need to get into my "START" command button clicked event and write…

John Blue
- 51
- 1
- 2
- 12
0
votes
2 answers
How to Create Dynamic Datawindow Using Stored Procedure with parameters
My issues is I am trying to create a datawindow dynamically based on a SP with parameters. I could able to create a datawindow dynamically from a SP without parameters, but with parms I am getting this error - "Can not get parameters of…

user2379643
- 13
- 1
- 5
0
votes
1 answer
Can't check checkbox in Datawindow
Can I know why the checkbox in Datawindow can't be checked. I have changed the column style to checkbox.
I am using PB.Net version 12.5.

user2142324
- 43
- 11
0
votes
3 answers
Insert Row in PowerBuilder
Actually I need to validate empty columns in a newly inserted row in a DataWindow control. I tried with ItemFocusChanged event script is as follow
if dwo.name="emp_name" then
if dw_1.GetItemString(row,"emp_no")= '' then
…

user2273567
- 1
- 1
- 1
0
votes
1 answer
DataWindow select group row
I have several datawindows with different looks. One simple just has a detail band and shows information. I can select rows in that datawindow, which marks that row. I got another DW that has a groupband with all the columns in it, and for some…

Lucas Arrefelt
- 3,879
- 5
- 41
- 71
0
votes
1 answer
Retrieve argument type uniqueidentifier
I have in SQL Anywhere following table:
CREATE TABLE "documents" (
"doc_id" uniqueidentifier NOT NULL DEFAULT NEWID(*),
"doc_description" varchar(50) NOT NULL,
...
PRIMARY KEY("doc_id")
)
I created a Datawindow.
(SQL…

klgr
- 191
- 1
- 1
- 12
0
votes
1 answer
Composite datawindow to txt
I have built a composite datawindow in Powerbuilder 11.5 that presents the
invoice form of my application.
As most fiscal papers here in Greece, I have to send it as
a text file to a fiscal device that composes a digital tax
signature that I then…

PanosPlat
- 940
- 1
- 11
- 29
0
votes
1 answer
PowerBuilder .net Web Forms on Chrome, FireFox, Opera
I am using PowerBuilder 12.5 to develop a .net Web Forms
I managed to get work on IE, but it did not work on Chrome, FireFox or Opera
the problem is with Drop Down Data Window
* In Chrome it does not show the list when click on the arrow
* In…

asmgx
- 7,328
- 15
- 82
- 143