1. Tom McArdle
  2. PowerBuilder
  3. Thursday, 05 July 2018

Hello

This is my first posting to the Appeon community. I am hoping someone can help me?

I have written an app using the MySQL database and PB2017. There are 8

Concurrent users. I am tracking the user as they sign in, but I

have noticed that I do not see their entries until I exit and get back in again.

 

Seems like the update is not ‘Committed’ even thought I do use the ‘Commit;’

at the end of each update.

 

When I exit and get back in I can then see those database entries.

 

Any guidance would be appreciated.

 

Tom

 

Accepted Answer
Bruce Armstrong Accepted Answer Pending Moderation
0
Votes
Undo

Which storage engine did you use? 

Are the connections set for autocommit?  

What transaction isolation level are you using?

The latter defaults to REPEATABLE_READ and you might want to use READ_COMMITTED instead.

Comment
Thank you very much Bruce.



Those changes did the trick Bruce.



Thank you so much.



 



SQLCA.Lock = "RC"

SQLCA.AutoCommit = True



Tom

  1. Tom McArdle
  2. Thursday, 5 July 2018
There are no comments made yet.
  1. Thursday, 5 July 2018
  2. PowerBuilder
  3. # Permalink
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Tom;

  Unfortunately at this time, MySQL is not a supported DBMS by PowerBuilder - only byt PowerServer.

Regards ... Chris

Comment
Thanks Chris.



ODBC for the most part works fine. Is there any pans to fully support MySQL?



or should I consider converting to PostGreSQL?



Tom

  1. Tom McArdle
  2. Thursday, 5 July 2018
Hi Tom;



   Nothing for MySQL in the short term. PB 2018 will focus on C#.Net Web API and C# .Net Assemblies - with some GUI improvements for Classic Apps.



Regards ... Chris

  1. Chris Pollach
  2. Thursday, 5 July 2018
Thank You Chris



I made the changes Bruce recommended and that did the trick.



SQLCA.Lock = "RC"

SQLCA.AutoCommit = True

  1. Tom McArdle
  2. Thursday, 5 July 2018
There are no comments made yet.
  1. Thursday, 5 July 2018
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


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