• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to select multiple columns in run-time using mouse drag

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

Resolved How to select multiple columns in run-time using mouse drag

  1. How-to
0
Votes
Undo
  1. Rajkumar K S
    Rajkumar K S
  2. PowerBuilder
  3. Tuesday, 9 August 2022 16:47 PM UTC

Hi,

Good day!

While designing a datawindow manually we can select multiple columns by using the mouse drag selection and within that drag position if there any columns available then those columns will be selected and we can move/adjust the height for all those columns.  We have a requirement to do the same case in run time. Is there any built in functionality available / how can we get the position of the  x, y, height and width while drag the mouse from one position to another.

Please help us to sort out this scenario.

thanks in advance.

Regards

Rajkumar K S

C-square

Ultimate Suite PowerBuilder
PB 2019 R3 MSOLEDBSQL SQL Server not available in ...
Responses (3)
Rajkumar K S
Rajkumar K S Accepted Answer Pending Moderation
  1. Wednesday, 10 August 2022 13:33 PM UTC
  2. PowerBuilder
  3. # 1

Hi John,

Thank you for your reply..

 

What style(s) of DataWindow? Freeform, tabular, grid, crosstab...? tabular, grid only

Detail band only, any band or subset of bands? In all the bands

What is the end goal (what is to be done with the selected/identified DWObjects? Are you needing to create a dynamic report builder? What is the use-case? The purpose for this change is to create a dynamic report in runtime.

Would any dynamically-made changes have to be saved for later use/reuse? Yes dynamic runtime changes should be saved.

 

Regards

Rajkumar K S

C-squarre

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 9 August 2022 18:13 PM UTC
  2. PowerBuilder
  3. # 2

Hi Rajkumar ;

   The way I have done this before was to protect all the DWO columns. Then float a rectangle object (using the OpenIserObject command) over the DW Control for the drag/drop operation. Once the rectangle was resized / positioned over the columns via DD & acknowledged by the App user as correct, I used the rectangle's position & size to select the columns under the rectangle's surface area.  Food for thought.

HTH

Regards ... Chris

Comment
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Tuesday, 9 August 2022 17:56 PM UTC
  2. PowerBuilder
  3. # 3

Hi, Rajkumar -

Interesting. Some additional information, if you please:

What style(s) of DataWindow? Freeform, tabular, grid, crosstab...?

Detail band only, any band or subset of bands?

Does the "selection" mechanism have to be a lasso-type of operation?

What is the end goal (what is to be done with the selected/identified DWObjects? Are you needing to create a dynamic report builder? What is the use-case?

Would any dynamically-made changes have to be saved for later use/reuse?

The quick answer is there is not (as far as i know) a way to do this currently. The DataWindow was never designed with this kind of user interaction in mind. Depending on your needs/requirements, Appeon Infomaker might be a feasible solution.

Best regards, John

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.