We have recently gone from PowerBuilder 12.6 to PowerBuilder 2017 R3
The method GetSqlSelect() (in DataWindow) has changed its behaviour in a compiled environment. If the datasource in the datawindow isa saved with graphical design then the method GetSqlSelect() does not return the SQL inits original state, the SQL state is converted to all lower case. Example: ”WHERE” is returned as ”where”. ”ORDER BY” is returned as ”order by” and so on. If we run the code in PowerBuilder everything is running as it did previously.
When compiled we are running with a swedish runtime. We have tried copying PDWE170.DLL and PBOLE170.DLL from the english runtime, but it does not make any difference. PBODB170.INI looks the same as PBOBD126.INI.
Is there anyway to get around this problem so that the GetSqlSelect is returned without being converted to lowercase?
We are currently facing a huge amount of work to make sure we use Upper() before searching the SQL with Pos() since we have used the functionality and Pos is case-sensitive.
Note: We are running OLE DB to connect to the SQL Server
Regards
Johan Tufberg
FWIW: Make sure that you are deploying all the PB 2019 R2 runtime DLL's with you new EXE. Helped a nice lady the other day with a similar issue. She was deploying the EXE into a folder with the PB 2019 GA runtime DLL's already present and *not* the R2 runtime DLL versions. That caused similar issues when run from the EXE but was OK from the IDE. Food for thought. HTH
Regards ... Chris