Hi,
is there a workaround to prevet removing trailing spaces for char data type?

Thank you,
Yury

Just pad right the result to the length of the field.

Some functions you might find useful:

function pad(sStr:string; nSize: integer): string;
var
 i: integer;
begin
 for i := 1 to nSize - length(sStr) do sStr := sStr + ' ';
 pad := sStr;
end;

function padl(S:string; nLen: integer): string;
begin
 while length(s) < nLen do S := ' ' + S;
 padl := S;
end;

function padl0(S:string; nLen: integer): string;
begin
 while length(s) < nLen do S := '0' + S;
 padl0 := S;
end;

function padr(sStr:string; nSize: integer): string;
begin
 Result := pad(sStr, nSize);
end;


Jerry

"yury" <yury@favour.com.au> wrote in message
news:4F52B06F-9999-4115-B9DB-7FE987BC79C9@news.elevatesoft.com...
> Hi,
> is there a workaround to prevet removing trailing spaces for char data
> type?
>
> Thank you,
> Yury
>

Yury,

DBISAM does not automatically remove trailing spaces from CHAR (FixedChar)
fields - blank spaces are only automatically trimmed from VARCHAR (String)
fields. So, the workaround is to use the CHAR type instead of VARCHAR.

--
Fernando Dias
[Team Elevate]