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
1
vote
2 answers

How to group rows vertically in PowerBuilder?

I have this sample rows of plate nos with bay nos: Plate no | Bay no ------------------ AAA111 | 1 AAA222 | 1 AAA333 | 2 BBB111 | 3 BBB222 | 3 CCC111 | 1 Is there a way to make it look like this in a datawindow in…
fanboime12
  • 21
  • 2
  • 10
1
vote
3 answers

PB - Undocumented column.compute property

When you try dw_1.describe(column_name.attributes), you will see ...,color,coltype,compute,criteria.dialog,... This means that DW object of type Column has undocumented property compute, this property isn't in Powerbuilder Help, isn't in datawindow…
Pavel Románek
  • 11
  • 2
1
vote
1 answer

Power builder rtf column does not display simple text

I need to convert some datawindow text columns (PB 11.5.1 - SQL Server 2008R2 - datatype Text) to RTF. I have 2 issues: New data are displayed fine but the existing data do not display at all The RTF format popup has very limited height so the…
PanosPlat
  • 940
  • 1
  • 11
  • 29
1
vote
1 answer

Handling database column privileges in datawindows

How to handle DB column privileges in datawindows to avoid getting "SELECT permission denied on column".... I have a datawindow that displays table columns, the users/roles permissions differ for certain columns and are set as per the business rules…
Etch Morrar
  • 11
  • 1
1
vote
1 answer

How to close Catel Framework Datawindow from the viewmodel

Does anyone know how to close (or save) the data window from your viewmodel and not use the ok or cancel button but custom buttons like this: public class UploadWindow : DataWindow { public UploadWindow() : base(DataWindowMode.Custom) …
Arne Van De Vyver
  • 83
  • 1
  • 7
1
vote
2 answers

Powerbuilder: How can I specify current date as initial value for a datawindow field

I have a datawindow where I have a date field. I want to specify an initial value into that date field when a row is retrieved from the database. From the Column Specification, I want to set the initial date value of that field to current date. Is…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
1
vote
1 answer

Grouping treeview powerbuilder

Is it possible to group 2 rows into one ?e.g. Revenue -Unit Revenue -Parts to Revenue -Unit -Parts The Revenue is a compute field with a expression if(account_main_short_title='UNIT' or account_main_short_title='PARTS','Revenue','') I've done…
Ren Mark Almojera Cerdan
  • 268
  • 1
  • 12
1
vote
1 answer

Powerbuilder Datawindow textbox does not word-wrap

I am trying to display a long word like a URL in a text box. Setting Vertical Scroll and Auto Vertical Scroll does not do the job. The line will be cut off.
easai
  • 71
  • 1
  • 6
1
vote
2 answers

How to scale or fit header texts in Powerbuilder?

Good day, I am making a report DataWindow when it is previewed the rightmost columns spill to the next page. So, is there a way to dynamically fit them according to paper size of the datawindow?
Dac
  • 210
  • 3
  • 19
1
vote
1 answer

Editing a column on a datawindow does not change on first edit

I'm editing a column in a window but it does not save the data when I input it for the first time, but after I close the window and repeat the whole process the data is saved.
Ruth
  • 69
  • 1
  • 9
1
vote
1 answer

DataWindow Error: Row changed between retrieve and update when ran from Windows 2012 R2 server

I am getting an error when updating a DataWindow which says "Row changed between retrieve and update". I am facing this in different environment. When i run my application on Windows 7 machine there is no error thrown. But i run the same application…
ninja_md
  • 165
  • 3
  • 15
1
vote
3 answers

Datawindow field : accept only positive numbers

I want to make a datawindow field accept only positive numbers. How can I do that? Edit I know I can validate the column using column specification's validation expression system. But is there any format available which I can put into the Format…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
1
vote
2 answers

Dropdown list in PowerBuilder can't retrieve all data

I have created in powerbuilder a dropdown data window to function as a filter to get values from a table named product and then by selecting something from the dropdown list in another datawindow to show all the retrieved data associated with the…
dc03kks
  • 221
  • 2
  • 6
  • 22
1
vote
2 answers

Avoid duplicates in dddw in powerbuilder

i have a created a DropDownDataWindow in PowerBuilder, the list has zip codes from a database table... but it has many duplicates and more like that for example, 01720 01720 01720 01730 01730 01730 01730 ... ans so on , my script is the…
dc03kks
  • 221
  • 2
  • 6
  • 22
1
vote
1 answer

Powerbuilder : How to write validation expression for a field

I have a datawindow containing multiple fields. I want to write a validation expression for a field named amount. I have another two fields named debit and credit. If the sum of debit and credit is greater than amount, then I want to show a…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
1 2 3
…
14 15