PROFESSIONAL NEWSGROUPS
WINDEV
,
WEBDEV
and
WINDEV Mobile
Home
|
Recent messages
|
Connect
|
Sign out
|
English
Home
→
WEBDEV 2024
→
PROBLEM: string values from database padded with blanks (OLE DB / ODBC)
PROBLEM: string values from database padded with blanks (OLE DB / ODBC)
Started by vvido, Oct., 04 2018 11:34 AM - 2 replies
Connect yourself…
vvido
#1
Registered member
94 messages
Posted on October, 04 2018 - 11:34 AM
Connection type: OLE DB / ODBC
Database: Ms Sql Server 2012
When I read the values of string columns from the database, the returned values are padded with blanks to the full size defined in the analysis.
The strings in the database are stored correctly without blanks at the end of string. (If I run the len query in the database: 'test 1' length is 6; 'test 123' length is
.
But when I get the values and display them in the table or form, all strings from this column in database are same size (the length defined in the analysis) - blank characters are added at the end.
QUESTION: which 'Extended information' in the 'Advanced' tab of Connection information should be used to avoid blank padding of database strings ?
Report
0
0
Alphakush
#2
Registered member
30 messages
Posted on October, 10 2018 - 4:29 PM
Hey,
Why not use the function NoSpace("string", sscRight) ? Don't know if it can help you, or if you already tried this..
Report
0
0
vvido
#3
Registered member
94 messages
Posted on October, 11 2018 - 10:56 AM
Thanks for your suggestion, but this only solves the individual string padding after it has been read from the database.
I would like the driver to perform this action instead of running such code after each read from the database.
Report
0
0
→ Go back to WEBDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (earlier versions)
Français
English
Español
Portuguesa
Close this window
Search type
Only topics
All the messages
Search period
Any time
Past hour
Past 24 hours
Past week
Past month
Past year
Cancel
Preview of your message
Adding an image
Import an image from a URL
Send an image from a file of your disk
Drop a file or click "Browse..."
or
Cancel
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Text