• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • Rowcount does not appear in Database Painter in PB 2022

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

Resolved Rowcount does not appear in Database Painter in PB 2022

  1. Issue
0
Votes
Undo
  1. jorge gonzalez
    jorge gonzalez
  2. PowerBuilder
  3. Sunday, 11 December 2022 13:04 PM UTC

 

I found a small bug in PB 2022. As you can see below the row count in PB 2021 appears on the bottom of the database painter but NOT in PB 2022.

Controlling retrieve of nested reports
Download demo database V2022
Responses (8)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 14 December 2022 01:59 AM UTC
  2. PowerBuilder
  3. # 1

Hi Jorge;

  The problem is related to the System Options dialogue. If you set the "Reload painters when opening workspace" in the Workspace tab ON, then this anomaly will occur. Since I never use this setting, my rows display in the DB painter always works.

  So for now as a workaround, just set the "Reload painters when opening workspace" setting OFF and this problem will not occur.

  Note that Ken will submit this anomaly issue still over to the Engineering team.  HTH 

Regards ... Chris 

Comment
jorge gonzalez
  1. jorge gonzalez
  2. Wednesday, 14 December 2022 04:00 AM UTC
Thanks Chris
  1. Helpful
Andreas Mykonios
  1. Andreas Mykonios
  2. Wednesday, 14 December 2022 07:14 AM UTC
Nice catch Chris.

I also have this setting turned off.

Andreas.
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 13 December 2022 19:33 PM UTC
  2. PowerBuilder
  3. # 2

Hi Jorge;

  No problem with this in my PB2022 build 1892 on either W10 or W11 ...

Regards ... Chris

Comment
Load more comments
jorge gonzalez
  1. jorge gonzalez
  2. Wednesday, 14 December 2022 00:38 AM UTC
Chris I am not running windows server. I am running Windows 11 Pro
  1. Helpful
jorge gonzalez
  1. jorge gonzalez
  2. Wednesday, 14 December 2022 00:39 AM UTC
I 've run PB 2017 on this vm without any problems.
  1. Helpful
jorge gonzalez
  1. jorge gonzalez
  2. Wednesday, 14 December 2022 00:43 AM UTC
Is Ken Guo running PB2022 on a VM or a real machine?
  1. Helpful
There are no comments made yet.
Ken Guo @Appeon
Ken Guo @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 13 December 2022 02:53 AM UTC
  2. PowerBuilder
  3. # 3

Hi Jorge,

Thanks for the feedback. I reproduced the problem based on your description.
I will report this problem to the development team. I noticed you’ve submitted Bug 9470 in the Support system. We will reply to you in the Support System if any progress.

For now, when this problem happens, you can close the Database Painter and then open the Database Painter again to work around this problem.


Regards,
Ken

Comment
Load more comments
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Tuesday, 13 December 2022 19:42 PM UTC
Hi Mark, Please open a support ticket because even though it may be related areas in your code most likely it is two different fixes we need to do in the product and we may not be able to fix both of them exactly at same time. So much better for tracking to keep things separate.
  1. Helpful
Mark Goldsmith
  1. Mark Goldsmith
  2. Tuesday, 13 December 2022 20:10 PM UTC
Will do Armeen and thanks.
  1. Helpful
Mark Goldsmith
  1. Mark Goldsmith
  2. Wednesday, 14 December 2022 03:23 AM UTC
Support ticket opened...Bug 9479 (https://www.appeon.com/standardsupport/track/view?id=9479).
  1. Helpful
There are no comments made yet.
jorge gonzalez
jorge gonzalez Accepted Answer Pending Moderation
  1. Tuesday, 13 December 2022 01:39 AM UTC
  2. PowerBuilder
  3. # 4

If I close the database painter in the current PB 2022 session and reopen the database painter and retrieve some data the row count shows up as you can see below. I don't have to do this in PB 2021. It works fine in PB 2021.

 

Comment
There are no comments made yet.
jorge gonzalez
jorge gonzalez Accepted Answer Pending Moderation
  1. Tuesday, 13 December 2022 01:34 AM UTC
  2. PowerBuilder
  3. # 5

I think I found the problem with the database painter and the row count not showing in PB 2022. If I had the database painters opened in PB and closed PB and then open PB it does not show the row count after a retrieve:

 

 

 

 

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 12 December 2022 09:31 AM UTC
  2. PowerBuilder
  3. # 6

@Arnd Schmidt.

You are right. Here is what I see with the database painter active:

And that's what I get when running a query (example: select * from messages;).

Andreas.

 

Comment
There are no comments made yet.
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Monday, 12 December 2022 07:09 AM UTC
  2. PowerBuilder
  3. # 7

Hi.

Don't know why you don't see that information. In my installation it's there.

I'm using build 1892...

Andreas.

Comment
Arnd Schmidt
  1. Arnd Schmidt
  2. Monday, 12 December 2022 09:11 AM UTC
Your active sheet does not seem to be the DB Painter. Your screenshot looks like the active Sheet is the Datawindow Painter.

Can you check the rowcount in the DB Painter?
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Sunday, 11 December 2022 17:09 PM UTC
  2. PowerBuilder
  3. # 8

Hi, Jorge - 

I did a quick search and did not find this bug reported anywhere. Please open a bug report for this issue so that Appeon can investigate it:

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

 

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.