• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Datawindow where clause: Key and Updatable Columns, question

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

Resolved Datawindow where clause: Key and Updatable Columns, question

  1. Advice
0
Votes
Undo
  1. Sylvain .
    Sylvain .
  2. PowerBuilder
  3. Thursday, 23 July 2020 14:11 PM UTC

MySQL Server 5.6.26
MySQL ODBC 5.3.10 ANSI
PowerBuilder Universal: 2019R2 Build 2328.00

We never had to use 'Key and Updatable Columns' so far in our system we always used 'Key Columns', but now I have something special to do that require .

I'm doing some test and the datawindow Update method return true even when the columns value currently in the database are no longer the same has what was read prior to the update.

The database is not modify because of the where clause but it would be nice if the return value of the Update method return False or an error of some kind.

I was under the impression that I would receive something in the form of 'Row changed between retrieve and update'.

Is there something I'm missing somewhere that I need to configure...

 

TIA

Sylvain 

Git, still Git and always Git
Data windows when switching from PB2019 to R2
Responses (3)
Sylvain .
Sylvain . Accepted Answer Pending Moderation
  1. Thursday, 23 July 2020 14:32 PM UTC
  2. PowerBuilder
  3. # 1

Yes, I made sure I was modifying the same column in two instance of the application. Both instance read at the same time, Both instance modified the same columns and when both instance saved both returned true but only the first instance value was put in the database.

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 23 July 2020 14:30 PM UTC
  2. PowerBuilder
  3. # 2

Hi Sylvain;

   FWIW: Note that Appeon PB does not officially support MySQL.

Regards ... Chris

Comment
There are no comments made yet.
mike S
mike S Accepted Answer Pending Moderation
  1. Thursday, 23 July 2020 14:23 PM UTC
  2. PowerBuilder
  3. # 3

did you change any updatable data in the datawindow itself?  It won't try to update if there are no changes in the datawindows data.  Update returns 1 in that case even though it didn't to anything (-1 indicates an error, so it wouldn't return that)

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.