Specifies whether DataWindow Designer should trim trailing spaces from data values retrieved from the following datatypes: Char, Char for Bit Data, VarChar, and VarChar for Bit Data.
ODBC
OLE DB
PBTrimCharColumns = value
Parameter |
Description |
|---|---|
value |
Specifies whether DataWindow Designer should trim trailing spaces from data of type Char, Char for Bit Data, and VarChar for Bit Data. Values are:
|
'NO'
This parameter can only be set in the pbodb105.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, DataWindow Designer 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 update properties are set to “Key and updateable
columns.” To prevent this, change your DataWindow 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'.
To specify that DataWindow Designer should trim trailing spaces, add the following line to the section for the database you are accessing:
PBTrimCharColumns='YES'
