TrimSpaces – PB Docs 2021

Description

Specifies whether PowerBuilder should trim trailing spaces from
data values retrieved from the following datatypes: Char, NChar, Text,
NText, Char for Bit Data, VarChar, NVarChar, and VarChar for Bit
Data.

Applies to

ADO.NET

ASE and SYC SAP Adaptive Server Enterprise

DIR SAP DirectConnect

I10 Informix

IN9 Informix

JDB JDBC

ODBC

O90 Oracle9i

O10 Oracle 10g

SNC SQL Native Client for Microsoft SQL Server

MSOLEDBSQL Microsoft OLE DB Driver for SQL Server

Syntax

Default value

TrimSpaces=0 (ADO.NET, O90, O10, SNC, and IN9) or TrimSpaces=1
(DIR, ASE, and SYC). For JDBC, the default values depend on the
PBTrimCharColumns value in the registry. For ODBC, the default values
depend on the PBTrimCharColumns value in the PBODBnnn.INI file. (If the
PBTrimCharColumns keyword is missing for a particular database
connection, the default value for the ODBC interface is
TrimSpaces=0.)

Usage

By default, PowerBuilder trims spaces from the following
datatypes: Char, NChar, Text, NText, Char for Bit Data, VarChar,
NVarChar, and VarChar for Bit Data.

If your DBMS makes a distinction between Char data with trailing
spaces and Char data without trailing spaces when evaluating a WHERE
clause expression, you might receive the message Row changed between
retrieve and update when your DataWindow object’s update properties are
set to “Key and updateable columns”. To prevent this, change your
DataWindow object’s update properties. In embedded SQL, you can check
Sqlca.Sqlnrows after each update to determine if the update took place.
Avoid using Char data columns in the WHERE clause of an UPDATE or DELETE
statement when TrimSpaces=1.

Examples

To specify that PowerBuilder should not trim trailing
spaces: