• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • dw.Update() is no longer working and getting an error

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

Resolved dw.Update() is no longer working and getting an error

  1. Issue
0
Votes
Undo
  1. Ramesh Govindarajan
    Ramesh Govindarajan
  2. PowerBuilder
  3. Monday, 21 February 2022 19:40 PM UTC

PRODUCTION ISSUE :

  We have recently compiled our old PB code to 2019 R  and pushed the latest code to production. 

  Now our data windows is no longer have update capabilities and we are getting an error whenever the dw.update() statement is getting executed. 

Do we have to set any property to bring that update capability back.  ?

Attached the error for your reference

Appreciate your help in advance.

Thanks

 

Ramesh Govindarajan.

 

 

 

 

 

 

 

 

Attachments (1)
Datawindow_error.JPG Datawindow_error.JPG
PB 19 tracing DB error
RESTFUL API MULTIFORM DATA
Responses (2)
mike S
mike S Accepted Answer Pending Moderation
  1. Monday, 21 February 2022 20:40 PM UTC
  2. PowerBuilder
  3. # 1

you need to edit the datawindow and put the update back.

if anyone changes the datawindow's sql via the IDE, it removes the update settings.   

If you hate that and think that is really stupid thing for it to do, well i agree.  sybase promised to fix it, but never did.

 

 

 

Comment
Load more comments
mike S
  1. mike S
  2. Monday, 21 February 2022 21:22 PM UTC
on the menu, select rows then update properties
  1. Helpful
John Fauss
  1. John Fauss
  2. Monday, 21 February 2022 21:32 PM UTC
Remesh - If you are unsure how to configure the update properties, open the old version of your app in the old version of PB, edit the same DataWindow and check its update properties.

P.S.: I 100% agree with Mike... It is a very "unsmart" thing for the IDE to do.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Monday, 21 February 2022 21:49 PM UTC
Sounds like some solid Unit & QA steps were bypassed. :-(
  1. Helpful 1
There are no comments made yet.
Ramesh Govindarajan
Ramesh Govindarajan Accepted Answer Pending Moderation
  1. Monday, 21 February 2022 21:28 PM UTC
  2. PowerBuilder
  3. # 2

Thank you very much. 

Comment
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.