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

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

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

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

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 

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.