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
3 answers

powerbuilder: How can I make sure that a text field in datawindow is not empty?

I have a user object which is using pfc services. Now, during update, how can I make sure that a text field in datawindow is not empty?
MD Sayem Ahmed
  • 28,628
  • 27
  • 111
  • 178
1
vote
3 answers

How to disable a single row in a datawindow?

Can anybody help me that how can I protect individual column of an individual row, though my datawindow has more than one row. I am writing a code like this: dw_1.Modify("column_name.protect = '1'") However it is making all my rows disabled.
Santosh Kumar Dutta
  • 33
  • 2
  • 6
1
vote
1 answer

Powerbuilder/Javascript HTML Datawindow SetItem Datetime Failure

I am working within a Jaguar 5.4 environment using PowerBuilder 11.2 9097. I have a php script within I have a javascript for the event beforeItemChanged. I am calculating an end date (datetime with edit format of dd-mmm-yyyy) from a start date…
Anthony S
  • 65
  • 11
1
vote
1 answer

Unintended gap between nested reports in PowerBuilder Classic

I have tried asking same question in SAP community network forums but got no response there, so trying my luck here: I have 3 freeform datawindows, named A, B and C. C is a nested report of B, B is a nested report of A and A is a main report. Report…
Valdas
  • 368
  • 4
  • 14
1
vote
2 answers

Powerbuilder 12.5 - Functions on DataWindows not triggering

I have an application in PowerBuilder 12.5.1, with a read-only grid datawindow, part of a master-detail (PFC linkage service). I would like to highlight some fields that contain certain strings. To do that, I made a global function…
carlo.borreo
  • 1,344
  • 2
  • 18
  • 35
1
vote
3 answers

How to migrate a datawindow from PB 10.5 to PB 6.5?

Is it possible to import a datawindow implemented in Powerbuilder 10.5 to Powerbuilder 6.5? What changes have to be made in the export code?
Alex
  • 207
  • 1
  • 2
  • 15
1
vote
2 answers

Emulating hyperlink functionality in datawindow text fields

The idea is rather simple. Some datawindow (not web datawindow) varchar fields contain detailed descriptions. I was wondering if it is possible to provide the following (wikipedia-like) functionality to users: The ability to click (or dbl-click or…
Brani
  • 6,454
  • 15
  • 46
  • 49
1
vote
4 answers

What is the fastest way of copying a data from a DataWindow/DataStore to SQL Server table using Powerbuilder

We have a datastore (powerbuilder datawindow's twin sister) that contains over 40.000 rows, which takes more than 30 minutes to insert into a Microsoft SQL Server table. Currently, I am using a script generator that generates the sql table…
Julio Nobre
  • 4,196
  • 3
  • 46
  • 49
1
vote
1 answer

When displaying a PowerBuilder datawindow, is it possible to only show a column details when it changes?

I am displaying a datawindow in PowerBuilder (v12) but for one of the columns only wish to display information in the column if the data has changed, otherwise the user will be subjected to a lot of repeats on the screen. Is this possible please or…
HugMyster
  • 329
  • 1
  • 4
  • 14
1
vote
4 answers

With PowerBuilder, is there a way to find if a specific datawindow or datastore is being used?

Having written my PowerBuilder code I may have several datawindows, one of which is called, let us say, d_Gubbins. Can I search through the whole uncompiled program to see if the datawindow is actually used or not please?
HugMyster
  • 329
  • 1
  • 4
  • 14
1
vote
1 answer

Powerbuilder: ImportFile of UTF-8 (Converting UTF-8 to ANSI)

My Powerbuilder version is 6.5, cannot use a higher version as this is what I am supporting. My problem is, when I am doing dw_1.ImportFile(file) the first row and first column has a funny string like this:  Which I dont understand until I…
Sid
  • 765
  • 5
  • 29
  • 57
1
vote
2 answers

How to enable to check both checkbox from the same column in datawindow

I have 2 checkboxs from the same column, one for Eat and another one for Drink, I plan if user check Eat, it will save as Eat data in 'a_type' column in database, same goes with Drink. In additional the user also able to check both Eat and Drink…
user3059801
  • 11
  • 4
1
vote
2 answers

How do i select a data column from a DDDW dynamically in PowerBuilder

I'm using PowerBuilder 11.5 and still relatively new to PowerBuilder. I need to get the datacolumn value of the selected item of a DDDW from a popoup window? Any help would be appreciated.
user2773471
  • 11
  • 4
1
vote
2 answers

powerbuilder datawindow update error

I am trying to insert a new record but sometimes datawindow not includes all the column . All columns are selected in the update properties but i am not getting all the columns in the insert statement.
user1788373
  • 39
  • 2
  • 6
1
vote
1 answer

PowerBuilder catch retrieve ORA

How to convert a standard error message to my own message? I have this code: dw_1.setSqlSelect('SELECT * , FROM TABLE1) dw_1.retrieve() I know about comma in select! User write select, so he can make mistakes. I don't want standard Error like…
Piszu
  • 443
  • 1
  • 8
  • 24
1 2 3
…
14 15