Hello.
I have a varchar column in my table:
table1, column1 (varchar).
When I execute the following sql:
DataSet.Add('Insert into Table1 (Column1) values (:Param1)')
with
Param1 := 'A ';
a new row in Table1 contains 'A' - without last blank ' '
When I make update - all is ok.
Is this a bug?
Trunc last blank
We couldn't reproduce the problem.
Please download the last DbxSda version.
If the problem is still present then send us a complete small test project
to reproduce the problem; it is desirable to use Northwind or Master schema
objects, otherwise include definition of your own database objects; don't
use third party components
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of DbxSda. You can see it in ReadMe.html
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.
Please download the last DbxSda version.
If the problem is still present then send us a complete small test project
to reproduce the problem; it is desirable to use Northwind or Master schema
objects, otherwise include definition of your own database objects; don't
use third party components
Also supply us following information
- Exact version of Delphi or C++ Builder
- Exact version of DbxSda. You can see it in ReadMe.html
- Exact version of Microsoft SQL Server and OLE DB provider that you use. You can see it in version info of SQLOLEDB.DLL and SQLNCLI.DLL.