Devart Forums

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?

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.