- You are here:
- Home
- Q&A
- Q&A
- PowerBuilder
- PB2017 R2 Changing SQL in DataWindow changes GUI
- Arthur Hefti
- PowerBuilder
- Thursday, 1 February 2018 10:15 AM UTC
- Monday, 12 February 2018 06:55 AM UTC
- PowerBuilder
- # 1
Hi,
We are very sorry for the issue you are experiencing and the inconvenience this has caused you.
Now our team is preparing an emergency patch for this issue. The patch is under final validation. We will make it available to all users (tentatively on or before February 16, 2018) in our Download portal along with the download link of PowerBuilder 2017 R2.
Regards.. Ken
- Friday, 9 February 2018 04:52 AM UTC
- PowerBuilder
- # 2
As now after a week this is a confirmed but I would like to know when we could expect a fix. The workaround described is fine for occasionally changes in DataWindows but not for real live.
This serious bug prevents us from using R2 which has a big impact of a big project at a customer as they plan to move the whole repository (not PB only) from an internal SVN server to hosted GIT in February which would allow other developers work on the project without having access to the company network. We need to convince our customer to postpone this move as otherwise the PB programmers end up working with notepad in the source.
We definitely need a release date for this fix.
- Wednesday, 7 February 2018 15:33 PM UTC
- PowerBuilder
- # 3
This is a showstopper for us too, had to uninstall R2.
Why change this behavior in the first place?
Please fix this, and return to the old logic for dbname and name.
Frode Guldberg
- Monday, 5 February 2018 08:15 AM UTC
- PowerBuilder
- # 4
Hello,
as Arthur mentioned, this behavior makes the PB 2017 R2 absolutly useless for us too.
That the existing fields are inserted as new fields is only one problem.
Our program makes heavy use of the describe command dbname (e.g. dw_1.describe(ls_parm+".dbname")
and to access fields. So if one fieldname is not existing anymore, the whole program may not work anymore.
This new "feature" has to be fixed as soon as possible.
Best regards,
Heiko
- Friday, 2 February 2018 13:32 PM UTC
- PowerBuilder
- # 5
Just tried that testcase, i dont have the problem.
I tried:
'' as column_name1
and
column_name1 = ' '
- Thursday, 1 February 2018 15:27 PM UTC
- PowerBuilder
- # 6
Hi Arthur,
Release Bulletin for PB 2017 R2, section 2.3 describes this exact issue in DB-Name for computed fields.
/Michael
- Chris Pollach @Appeon
- Friday, 2 February 2018 05:05 AM UTC
If an SQL Clause uses an "AS MyName" then the DW should preserve the column as "MyName"!
-
Helpful Loading... Helpful 0
- Tobias Roth
- Friday, 2 February 2018 10:11 AM UTC
We can't upgrade to R2 as long as the problem exists
-
Helpful Loading... Helpful 0
- Roy Bungert
- Wednesday, 7 February 2018 09:42 AM UTC
A lot of our dws are already destroyed because all computed fields of a DW-SQL are removed from the dw and added at a new position!
-
Helpful Loading... Helpful 0
- Thursday, 1 February 2018 15:14 PM UTC
- PowerBuilder
- # 7
Hi Arthur;
To me technically, the R2 syntax looks proper as unfallkat is an SQL computed column.
Does the DWO still run OK?
Regards ... Chris
- Arthur Hefti
- Thursday, 1 February 2018 15:43 PM UTC
-
Helpful Loading... Helpful 0
- Page :
- 1
However, you are not allowed to reply to this question.