TRIM CHAR with Delphi 7

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for SQL Server in Delphi and C++Builder
Post Reply
anordlun
Posts: 15
Joined: Thu 24 Feb 2005 08:09

TRIM CHAR with Delphi 7

Post by anordlun » Thu 24 Feb 2005 08:14

Hi.
The thread: http://crlab.com/forums/viewtopic.php?t=419
describes how to trim char with c++ builder 6.

I'm trying to accomplish the same result with Delphi 7 and dll-version 2.50.4.0

How do I proceed?

Ikar
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Thu 24 Feb 2005 14:57

If you use TCRSQLConnection, then you should use

sqlConnection.Params.Values['TrimFixedChar'] := 'True';

Otherwise,

sqlConnection.Connected := True;
sqlConnection.SQLConnection.SetOption(TSQLConnectionOption(103), Integer(True));

anordlun
Posts: 15
Joined: Thu 24 Feb 2005 08:09

Post by anordlun » Fri 04 Mar 2005 10:35

Thanks. I will try that...

Post Reply