Questions? Feedback?powered byOlark live chat software
Bug 2844

sort with computed fields in a datawindow are loosing in PB 2019 14 June, 2019

Juan Pedro Sanz Diez
11 June, 2019
Product: PowerBuilder Category: DataWindow
Version: 2019 Publishing: Public
Status: Scheduling Priority: P1
Classification: Appeon bug Resolution:
Juan Pedro Sanz Diez 14 June, 2019
Ok, 

Thanks you.

Regards.

Juan Pedro.
Ken Guo 14 June, 2019
Hi Juan,

We are analyzing and fixing this issue as a priority. Our aim is to have it fixed in the next MR. At this moment, the exact release date is not decided. We will keep you updated. 

Regards,
Ken
Juan Pedro Sanz Diez 14 June, 2019
Good day, Ken.

We need to know if there was any advance with the issue or if there is an expected date for the fix.

Thanks in advance.

Juan Pedro.
Juan Pedro Sanz Diez 12 June, 2019
Thanks a lot for the quik reply. Waiting expectantly for the fix.

regards

Juan Pedro..
Ken Guo 12 June, 2019
Hi Juan,

Thanks for reporting this problem! We reproduced it on our end and will do further research to figure it out. We will keep you posted about the progress.

Regards,
Ken
Juan Pedro Sanz Diez 11 June, 2019
Thanks.
Ken Guo 11 June, 2019
Hi Juan ,

I'm working on analyzing your case. I will keep you posted of the results here.

Regards,
Ken
Juan Pedro Sanz Diez 11 June, 2019
issue_sort_computed.rar (3KB)

*Phenomenon:
Hello,

My name is Juan Pedro. We have installed the Appeon Powerbuilder 2019 Build 2082. We have realized that in the new version the computed field in the datawindow's sort are loosing.

*Reproduce Steps:
I mean:

Appeon Powerbuilder 2017

1.- Add a field (F) in a datawindow
2.- Add Computed field (CF) in a datawindow.
3.- Go to rows -> sort and select F and CF for the second. OK and close.
4.- Go to rows -> sort and both F and CF are there.
5.- Save datawindow 
6.- Go to rows -> sort and both F and CF are there.
7.- close datawindow
8.- Open datawindow
9.- Go to rows -> sort and both F and CF are there.


Appeon Powerbuilder 2019

1.- Add a field (F) in a datawindow
2.- Add Computed field (CF) in a datawindow.
3.- Go to rows -> sort and select F and CF for the second. OK and close.
4.- Go to rows -> sort and both F and CF are there.
5.- Save datawindow 
6.- Go to rows -> sort and both F and CF are there.
7.- Close datawindow
8.- Open datawindow
9.- Go to rows -> sort and the CF ISN'T there.
10.- Close datawindow
11.- Edit Source Datawindow -> and the CF is There, in the sort. OK
12.- Open datawindow
13.- Go to rows -> sort and the CF ISN'T there. 
14.- Save datawindow
15.- Edit Source Datawindow -> and the CF ISN'T There, in the sort, any more.



Remarks:
1) If the computed field is alone in the sort, it works.
2) All fields behind a lost computed field , are loosing too, computed and not compute. Only not computed fields before the computed field are keeping.

3) see attached files.

Two problems:

1.- At runtime, it doesn't work, althought in edit source the field is in the sort.
2.- At maintenance, if we save any datawindow, computed fields are loosing, for ever.
OS:
Windows 10 
Platform:
All 
Database Type:
Microsoft SQL Server 
Database Version:
I think no matter with the issue. SQL Server 2008