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.