1. Ivan Leon
  2. PowerBuilder
  3. Monday, 24 June 2024 13:06 PM UTC

Datawindow update() show "Row Changed between retrieve and update" in PB 2022 R3, this happened after migrate de application from pb 12.5 to PB 2022 R3.

John Fauss Accepted Answer Pending Moderation
  1. Monday, 24 June 2024 14:23 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Ivan -

If you are not willing to troubleshoot the issue, why did you post this question? This is a question and answer forum where you can ask questions and receive advice/suggestions from other PB developers (who volunteer their time and expertise) at no cost. Chris and René have responded in a timely manner with good advice on how YOU should proceed.

If you have evidence there is a defect in PowerBuilder, then you have the option to open a free bug ticket:

    https://www.appeon.com/standardsupport/search

You also have the option of opening a (not free) premium support ticket:

    https://www.appeon.com/premium-support.html

These are the options available to you. Choose the one that best fits your needs.

Best regards, John

Comment
There are no comments made yet.
Ivan Leon Accepted Answer Pending Moderation
  1. Monday, 23 September 2024 20:31 PM UTC
  2. PowerBuilder
  3. # 2
Thank you all, this week I took up the case again and the answer was in

https://docs.appeon.com/pb2022r3/troubleshooting_guide/tr_013.html

 

Comment
  1. John Fauss
  2. Tuesday, 24 September 2024 02:35 AM UTC
I glad to learn you found the cause, Ivan. Thank you for letting the Community know how this worked out!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 24 June 2024 13:36 PM UTC
  2. PowerBuilder
  3. # 3

Hi Ivan;

  This is more likely because of the DWOs "Update Property" setting because the Where clause generated is referencing "all columns" vs "only changed columns". I would check your DWO update settings first.

  If that does not address this issue, I would run an SQL Trace via the SQLCA.DBMS = "TRACE XXX" setting. HTH 

Regards ... Chris 

Comment
  1. Ivan Leon
  2. Monday, 24 June 2024 13:59 PM UTC
The instruction works fine in pb 12.5 but not in Pb 2022 r3
  1. Helpful
  1. Chris Pollach @Appeon
  2. Monday, 24 June 2024 14:31 PM UTC
What are the DWO's update settings set to?
  1. Helpful
There are no comments made yet.
René Ullrich Accepted Answer Pending Moderation
  1. Monday, 24 June 2024 13:24 PM UTC
  2. PowerBuilder
  3. # 4

If PB does a delete or update for a datawindow row it creates a database DELETE or UPDATE statement with a WHERE clause depending on your update settings in the datawindow object. The "Row Changed between retrieve and update" comes if this statement does not effect a row in the database - the WHERE does not find the row anymore.

It is not easy to say what's going wrong in your case. There are a lot of different reasons. You may check what statement PB will send to the DB in sqlpreview event or you enable tracing of sql.

Comment
  1. Ivan Leon
  2. Monday, 24 June 2024 13:59 PM UTC
The instruction works fine in pb 12.5 but not in Pb 2022 r3
  1. Helpful
There are no comments made yet.
Roland Smith Accepted Answer Pending Moderation
  1. Monday, 24 June 2024 17:19 PM UTC
  2. PowerBuilder
  3. # 5

When asking a question about database issues, it would be a big help if you told us what database server you are using and which connection method you are using. Any options set in DBParm could be helpful as well.

Please tell us:

The type/version of database server

Connection Method & DBParm used in PB 12.5

Connection Method & DBParm used in PB 2022

Comment
There are no comments made yet.
David Peace (Powersoft) Accepted Answer Pending Moderation
  1. Wednesday, 26 June 2024 16:16 PM UTC
  2. PowerBuilder
  3. # 6

Hi Ivan

Can you post up a screen shot fo the DW Update properties please so that we can best advise on the way forward. Alternativly you can contact my team and we will identify fix the problem for you as part of our consulting service. Just search "powersoft powerbuilder consultants"

Kind regards

David

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.