SAP Knowledge Base Article - Preview

2091124 - SAP PowerBuilder removes the extra whitespace and line feed code in DataWindow SQL

Symptom

SAP PowerBuilder removes the extra whitespace and line feed code in DataWindow SQL.


Sample SQL in DataWindow:

SELECT 'A'    "1",
'B'     "2"
FROM     dummy

DB Trace Log:

(4b00008): LOGIN: (30.416 MS / 30.416 MS)
(4b00008): CONNECT TO TRACE ODBC:
(4b00008): SERVER=EASDemoDB125
(4b00008): DBPARM=ConnectString='DSN=EAS Demo DB V125;UID=dba;PWD=<******>' (0.346 MS / 30.762 MS)
(4b00008): PREPARE: (0.001 MS / 30.763 MS)
(4b00008): BEGIN TRANSACTION: (0.013 MS / 30.776 MS)
(4b00008): PREPARE:
(4b00008): SELECT 'A' "1", 'B' "2" FROM dummy (0.295 MS / 31.071 MS)

However, in the case of SQL with the search criteria, line feed code is does not remove.

Sample SQL in DataWindow:

SELECT 'A' "1",
           'B' "2"
FROM dummy
WHERE "dummy"."A" = :test1

DB Trace Log:

(1481068): LOGIN: (16.947 MS / 16.947 MS)
(1481068): CONNECT TO TRACE ODBC:
(1481068): SERVER=EASDemoDB125
(1481068): DBPARM=ConnectString='DSN=EAS Demo DB V125;UID=dba;PWD=<******>' (0.616 MS / 17.563 MS)
(1481068): PREPARE: (0.001 MS / 17.564 MS)
(1481068): BEGIN TRANSACTION: (0.009 MS / 17.573 MS)
(1481068): PREPARE WITH BIND VARIABLES:
(1481068): SELECT 'A' "1",
'B' "2"
FROM dummy
WHERE "dummy"."A" = ?


Read more...

Environment

  • SAP PowerBuilder 12.5.x
  • SAP PowerBuilder 12.6

Product

PowerBuilder 12.5 ; SAP PowerBuilder 12.5 ; Sybase PowerBuilder 12.0

Keywords

CR, 773585 , KBA , BC-SYB-PB , PowerBuilder , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.