PBTrimCharColumns – PB Docs 126

PBTrimCharColumns database parameter

Description

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

Controls

  • ODBC

  • OLE DB

Syntax

Parameter

Description

value

Specifies whether PowerBuilder should trim
trailing spaces from data of type Char, Char for Bit Data, and VarChar
for Bit Data. Values are:

  • NO

    (Default) Do not trim trailing spaces.

  • YES

    Trim trailing spaces.

Default

‘NO’

Usage

This parameter can only be set in the pbodb126.ini file. For
ODBC, you can set the TrimSpaces parameter in the Database Profile
Setup dialog box or in code to perform the same function.

By default, PowerBuilder trims spaces from the following datatypes:
Char, Char for Bit Data, VarChar, 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 PBTrimCharColumns=’YES’.

Examples

To specify that PowerBuilder should trim trailing spaces,
add the following line to the section for the database you are accessing:

See Also

TrimSpaces


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x