• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Why can I NOT save in the RESULT pane of the DB Painter?

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved Why can I NOT save in the RESULT pane of the DB Painter?

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Wednesday, 8 July 2020 17:16 PM UTC

PB 2019R2
Windows 10, 64 bit platform


Select * from rpt_argmnt;
//  result set is displayed in pane

// Manually change a value - the SAVE button is not enabled!

WHY CAN I NOT SAVE?????????

Powerbuilder 6.5 with Oracle19c connection.
aplication with several modules (.exe)
Responses (2)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 8 July 2020 18:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Olan - If you want to save your changes to the result set data, I believe you need to use the "Save Changes" toolbar button or Rows > Update from the menu.

HTH, John

Comment
Load more comments
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 8 July 2020 22:03 PM UTC
haha, I went nuts trying to find the "cancel retrieve" icon when previewing a datawindow
  1. Helpful
Ricardo Jasso
  1. Ricardo Jasso
  2. Thursday, 9 July 2020 16:05 PM UTC
<rant>

It's anti-skewmorphism gone too far, a current trend since the introduction of flat design. No line separators in menus, headers, or images, text in light gray difficult to read, and of course, flat icons hard to identify.

</rant>

  1. Helpful
Olan Knight
  1. Olan Knight
  2. Friday, 10 July 2020 14:19 PM UTC
Ricardo, I completely agree!

The current trend has emphasized appearance over usability, which is just stupid.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 8 July 2020 18:14 PM UTC
  2. PowerBuilder
  3. # 2

Hi Olan;

  Most likely its because:

1) The Data Pane in the DB Painter is a DataWindow

2) No DWO will allow saves if

  • A "unique" index is not present      // or
  • A primary key is not identified

Adding one of those to your schema for that table should enable saving.

HTH

Regards ... Chris

 

Comment
Olan Knight
  1. Olan Knight
  2. Wednesday, 8 July 2020 19:49 PM UTC
Good idea, but not in this case as I'm acceessing an old table that has been around for ages.

Thank you for your response!
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.