- Craig Meinen
- PowerBuilder
- Thursday, 4 May 2023 02:31 PM UTC
Hi All.
I'm using PB2022 to develop an application that connects to a SQL Server database via MSOLEDBSQL. The syntax is shown below.
// Profile Database (MSSQL)
SQLCA.DBMS = "MSOLEDBSQL SQL Server"
SQLCA.LogPass = <***********>
SQLCA.ServerName = "NNN.NN.NN.NNN"
SQLCA.LogId = "sa"
SQLCA.AutoCommit = False
SQLCA.DBParm = "Database='XXX',TrimSpaces=1"
The problem is that his doesn't seem to be working for me. The character fields in my application still contain trailing blanks. In places where I can, I need to add the Trim function to correct this issue, but I cannot use that in all cases, so I need to find out what I can do to correct this.
Any assistance would be much appreciated.
Thank you.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.