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
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.
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?
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…
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