1. Praveen Rajarao
  2. PowerBuilder
  3. Tuesday, 23 July 2019

Hi,

I migrated one of my PB12.5 apps to PB2019. 

I have a tree-view datawindow with Sort order defined in the design mode. 

When I migrated, this datawindow somehow lost the sort columns. So I manually added them back in 2019. 

However, when I run the application, the sort order disappears. No matter how many times I have tried to add this back, it just doesnt remain in the design mode. 

See attached screenshots. 

Anyone else facing this issue? 

Thanks

Praveen

Attachments (1)
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Praveen;

   I just tried a complete suite of DWO "sorting" tests on SQL computed columns, DWO computed columns, regular columns and any combination of the above.

  I could not reproduce your issue on my W10 based PB2019 IDE PC's.

Regards ... Chris

Comment
Hi Chris,



I zeroed in on the issue. It is only happening when I have a computed column and a regular column in the sort. If I have just the computed column then it works fine. Regular column sort is also fine. Only when it is a combination of both.



Similar to the issue here - https://www.appeon.com/standardsupport/search/view?id=2844



Thanks

Praveen
  1. Praveen Rajarao
  2. Tuesday, 23 July 2019
Hi Praveen ... I tried that combination as one of my test cases and the DWO did not loose any sort settings.
  1. Chris Pollach
  2. Tuesday, 23 July 2019
There are no comments made yet.
  1. Tuesday, 23 July 2019
  2. PowerBuilder
  3. # 1
mike S Accepted Answer Pending Moderation
0
Votes
Undo

there are some reported issues with sorting, including when used with compute fields

https://www.appeon.com/standardsupport/search/view?id=2844

 

see if that is similar to what you are seeing in your application

 

 

 

Comment
Yes, looks like this is related to what is already reported. Thanks.
  1. Praveen Rajarao
  2. Tuesday, 23 July 2019
There are no comments made yet.
  1. Tuesday, 23 July 2019
  2. PowerBuilder
  3. # 2
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Praveen;

  FYI: I just tried this in my PB2019 IDE and cannot replicate your Sort issue.

Q1: Is this DWO controlled by some sort of "Source Control"? If so, did you "Check Out" the DWO first?

Q2: Is there a possibility that your have the DWO in two locations?

Regards ... Chris

Comment
FWIW: Make sure that the PB App's work folder and it's sub-folders & files are *not* "write protected".

FYI: Just tested with computed columns being sorted as well. No issues with loosing the Sort settings.

  1. Chris Pollach
  2. Tuesday, 23 July 2019
One thing to be sure to check is that you don't have another dw with the exact same name in a PBL higher in the library list. If it works fine in design mode, but then is wrong when you run it, you may have another dw somewhere in another pbl that is being picked up before the one you are changing.
  1. Kevin Ridley
  2. Wednesday, 24 July 2019
Kevin - No, I have confirmed that there are no duplicates. Also, when I exit my application, the DW is losing the sort columns. So it is not a object hierarchy issue.
  1. Praveen Rajarao
  2. Wednesday, 24 July 2019
There are no comments made yet.
  1. Tuesday, 23 July 2019
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


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