1. CJ Lai
  2. PowerBuilder
  3. Wednesday, 9 September 2020 19:10 PM UTC

Hi

- OS = Windows 10 Pro

- PowerBuilder CloudPro edition 2019 Build 2353

 

I have post this problem before but no working solution was found.

Issue:

- I have a dw control (inherited from datawindow) with the VScrollBar and LiveScroll properties checked. The dw control is placed on a window (inherited from w_sheet)

- In the run time (both in the IDE and from the exe), the VScrollBar is NOT scrolling as expected. 

- (Please refer to the attached screen shot) during the run time (in both methods - IDE's Run and EXE of the application), when I roll the mouse's wheel, the 'gray' bar goes to the bottom in just one wheel click. 

- If I click on the 'blank' area below the gray bar, it goes by the gray bar's length

- However, when I click on the down arrow  on the bottom of the VScrollBar, it goes directly to the bottom of the dw page in just one click. (true to the other way as well.)

If a visual helps, here is a demo youtube video -> https://bit.ly/2ZoqYqx

Attachments (1)
Accepted Answer
CJ Lai Accepted Answer Pending Moderation
  1. Wednesday, 7 October 2020 15:00 PM UTC
  2. PowerBuilder
  3. # Permalink

I was able to achieve 'smooth scrolling' by adapting code example found here -> https://bit.ly/3npAGDu

 

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Friday, 11 September 2020 19:43 PM UTC
  2. PowerBuilder
  3. # 1

Have you tried manipulating the scroll position via PowerScript code and dot notation or Describe/Modify?

https://docs.appeon.com/pb2019r2/datawindow_reference/ch03s03.html#XREF_80223

 

Comment
There are no comments made yet.
CJ Lai Accepted Answer Pending Moderation
  1. Thursday, 10 September 2020 19:38 PM UTC
  2. PowerBuilder
  3. # 2

Hi John Fauss

That's an alternative. However, with a medical record that goes mile-long vertically, the max window height in PB units, 32767, is just not cutting it.

I do not know what else can be done to achieve my goal.

By the way, the dwo's detail band is at 47900 for the record. Just so you know.

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 10 September 2020 20:04 PM UTC
Hi CJ;

I Just tested this code on a DW Control and it works 100% for me to be able to exactly control the DC's position over the DWO via PowerScript ( even if no scroll bars are active on the DC). I am not sure if that is what you are looking for, but this might solve your precision scrolling requirements.

FYI: https://www.rgagnon.com/pbdetails/pb-0175.html

Regards ... Chris
  1. Helpful
  1. CJ Lai
  2. Friday, 11 September 2020 17:20 PM UTC
Thanks, Chris Pollach @Appeon

I am not sure what your setup is where the Send() works.

I have the following code in commandbuttons (on a window) for page up and page down, respectively and I take out the VSCrollBar out of the dw control



Send(Handle(dw_1), 277, 2, 0)

Send(Handle(dw_1), 277, 3, 0)



The page down works; it scrolls a dw page per click (funny thing is, when I roll my mouse wheel, the wheel does exactly the same as the code)

However, the page up scrolls the dw always to the top; it doesn't matter where the dw page is. (again, the mouse's wheel does the exactly same)

  1. Helpful
  1. Chris Pollach @Appeon
  2. Friday, 11 September 2020 19:10 PM UTC
Hi CJ;

I had no issues on my Test App. The scrolling was very precise. I wonder if it might be best at this point to create a simple Test Case PB App using the same DWO and post it to the forum so that we can see the issue more clearly. Especially, after seeing your DWO layout & settings.

BTW: any time that you need more time from Appeon support to help look over this type of issue, you cam always open a Premium" ticket for a lot more coding help.

Regards ... Chris
  1. Helpful
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 10 September 2020 18:02 PM UTC
  2. PowerBuilder
  3. # 3

I agree that is the likely reason you are seeing this behavior, CJ.

DW scrolling has spoiled us a little. Since DW scrolling isn't meeting your needs, maybe look into using window scrolling instead? Increase the length of the DW control so that it displays the entire 200+ data column objects and turn off the DW scroll bars, then use a scroll bar in the window to move the viewport into the window's client area?

An alternative idea would be to compartmentalize the 200+ columns into sections (I assume the information is organized into logical groupings?) and use a tab control/tab pages to present each grouping. All of the DW's could use ShareData so that only a single copy of the data is in play.

Regards, John

Comment
There are no comments made yet.
CJ Lai Accepted Answer Pending Moderation
  1. Thursday, 10 September 2020 16:33 PM UTC
  2. PowerBuilder
  3. # 4

Hi Zhao Kai @Appeon, John Fauss and Chris Pollach @Appeon

I think I figured out why it's acting as such.

The dwo behind the dw control is ONE row and it's a row with 200+ columns/fields (it's a medical record)

That's why when clicking on down arrow on the VSCrollBar it goes from the top directly to the bottom as it's just ONE humongous row.

Now my question is : Is there any way I can make that scroll behave 'normally?'

Comment
There are no comments made yet.
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 10 September 2020 00:25 AM UTC
  2. PowerBuilder
  3. # 5

Hi CJ,

Please open a support ticket in the support porta and please provide a test case & detailed steps to reproduce the issue, Many thanks in advance.
https://www.appeon.com/standardsupport

Regards,
ZhaoKai

Comment
There are no comments made yet.
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 9 September 2020 20:07 PM UTC
  2. PowerBuilder
  3. # 6

Greetings, CJ -

Are you seeing this behavior in all DW's with VScrolling? If not, what is common to the ones that are not scrolling "normally"?

What style of DW object is the example in your video? Composite? How the DW responds to user actions is dictated by the Processing property of the DW object. For example, I just viewed a 20+ (printed) page tabular report with Print Preview mode on and with it off; Mouse clicks in the areas of the DWC's vertical scroll bar that you described resulted in what I would categorize as normal scrolling behavior. I don't have ready access to a composite DW to experiment with.

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 9 September 2020 19:24 PM UTC
  2. PowerBuilder
  3. # 7

Hi CJ;

  It's probably related to the way the DW object is layedout within the control. Without a test case (or at least the DWO source & some test data), it's hard to say.

Regards ... Chris

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.