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
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.