1. Troy Cowan
  2. PowerBuilder
  3. Wednesday, 31 July 2024 13:37 PM UTC

PB 2021 build 1509

Windows 10 Enterprise

I think I may have found a defect in Powerbuilder's grid datawindow creation wizard.  It seems to insert non-ascii characters into the resulting source code when you manually create the Select statement and have a complicated column description with no alias.

This select statement causes the problem to occur: 

select
    CASE WHEN to_char(sysdate, 'YYYY') = '2024' THEN
        CASE WHEN to_char(sysdate, 'Month') = 'July' THEN
            'Today is within July 2024'
        ELSE
            'Today is within 2024 but not July'
        END
    ELSE
        CASE WHEN to_char(sysdate, 'Month') = 'July' THEN
            'Today is within July but not 2024'
        ELSE
            'Today is not within 2024 and not July'
        END
    END
from
    dual

Go through the wizard to create a new grid datawindow, use Convert to Syntax and type/paste in this Select statement. Complete the Wizard and save it. Then look at the Header for that column in the painter or in the code. You will see some non-ascii characters. 

If you put an alias at the end of the column definition when creating the datawindow, the problem does not occur. 

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 31 July 2024 14:12 PM UTC
  2. PowerBuilder
  3. # 1

Hi Troy;

  Since PB 2021 build 1509 went out of maintenance on 2023.09.04 and is not eligible for standard support any longer, I would suggest upgrading to the latest PB 2022 R3 build 3356 and then retrying this issue.

  Note that after migration, the DW Objects are not migrated. A simple trick is to open the DWO in "Source" mode and change the 1st line of the DWO from "release 17;" (for example)   to "release 22;".  Then save the DWO source back to the PBL. This will force the DWO to be properly migrated to the current PB release.

HTH

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.