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
3
votes
1 answer

PowerBuilder 12.5 Web Forms - Columns Not Editable or Lost Tab Order upon Deploy

I am a seasoned PB developer, but primarily with the typical client-server architecture and am really having problems with a Web Forms application deployed to IIS7.5 using PB12.5 Classic. I am creating an updateable dataobject (web service) that…
Rich Bianco
  • 4,141
  • 3
  • 29
  • 48
2
votes
2 answers

Get objects of DataWindow band

How can i get an array of all objects in specific band, Detail or Header for example? I success to get all objects using: dw_1.Describe("datawindow.objects")
gilhanan
  • 335
  • 1
  • 6
  • 16
2
votes
1 answer

PowerBuilder.NET not reading Datawindow SQL Syntax properly

Hopefully, someone has come across this issue before, as it has stumped a co-worker and I for a few days. We successfully converted our project from PowerBuilder 12 Classic to PowerBuilder.NET and things are running decently, but we are…
Christopher MacKinnon
  • 313
  • 1
  • 6
  • 17
2
votes
2 answers

Remove grouping from dw at runtime

Is it possible to remove a group or groups from a DW at runtime?
Guy
  • 325
  • 1
  • 3
  • 18
2
votes
1 answer

PowerBuilder - Repeating value suppression list not working on some datawindow columns

I've tried to suppress some columns in the datawindow. I've already dragged those columns in the suppresion list as shown below. But unfortunately when I run the datawindow report, there are values specifically under the column of total carton and…
RedHat
  • 205
  • 2
  • 12
  • 24
2
votes
1 answer

Powerbuilder - Retain previously retrieved data

I am doing multiple retrievals of a composite datawindow and the request was to have them all in one printout. I vaguely remember that in the past I was putting something in the RetrieveEne event that retained the data but I cannot recall or locate…
PanosPlat
  • 940
  • 1
  • 11
  • 29
2
votes
2 answers

How do I hide the display value of a column in a datawindow when the column value is zero

The question says it all. To clarify: I am not trying to hide the whole column, I just want to hide the display value when it is being equal to zero. Any help is appreciated!!! Thanks in advance.
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
2
votes
1 answer

Powerbuilder: does a change in the computed field trigger itemchanged event

I have a computed field called c_total_qty in a datawindow which computes multiplication of two fields, one field is a database column and the second one is another computed field. Now when c_total_qty's value changes, it does not trigger…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
2
votes
3 answers

Powerbuilder - SQLNRows is 0 after Datawindow update

The first time I call Update on my DataWindow it returns 1 (success) and SQLCA.SQLNRows is 1. When I do a second update on the same screen without closing it in between, Update returns 1 and SQLCA.SQLNRows is 0. Any suggestions why this is…
user52800
2
votes
1 answer

Powerbuilder: Making certain rows editable and certain rows non-editable in a datawindow

how can I make certain rows editable and certain rows non-editable of a datawindow? I am adding the rows using pfc_addrow() event of the datawindow, and I want some of them to be editable and some of them to be non-editable. Is there any way to do…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
2
votes
1 answer

How to dropdown in DataWindow in PowerBuilder

I have dw.area (area_id,area_name) and dw.office (area_id,office_id,office_name) I want to create a dropdown in datawindow. When I check area_id I'd like to retrieve office_name. How can achieve this with a script?
mohamed sobh
  • 21
  • 3
2
votes
1 answer

PowerBuilder: Insert data using a datawindow

Suppose I have a table called 'test', into which there are three columns named test_id, test_name and test_age. I have used a retrieval argument called :al_test_id to prompt the user to insert an id and search the database for the corresponding id…
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
2
votes
2 answers

How powerbuilder's datawindow executes insert command

I am new to powerbuilder and having a lot of trouble using datawindows. I can't get my head around the insert mechanism of it. Can someone explain it to me, or at least point me in the right direction(article, tips etc...) ?
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
2
votes
4 answers

In powerbuilder can you have multiple sql results display in one datawindow?

I'm wondering if it's possible to have one datawindow display multiple sql results? I have 4 or 5 sql scripts that I would like to run at once, display in one datawindow, and then save the results. I want in one window to keep it clean, instead of…
PBNick
  • 55
  • 1
  • 11
2
votes
1 answer

Reading crosstab datawindow column header value in powerbuilder

I am trying to read the value of a crosstab datawindow column header in powerbuilder 12.5.1. I have a clicked event on the datawindow in which I am using the following code to retrieve this information. IF ( dwo.type = 'text' ) THEN ls_name =…
Vijay Raghavan
  • 53
  • 11
1
2
3
…
14 15