Not sure, and AFAIR, but FB (at least 1.5.x) does not like
string-parameters to be longer then the actual declared fieldsize.

eg:...
field Name : varchar(5)
....
Name = :aName
.....
ParamByName('aName').asString:='Fabiano'
would cause an error.

Maybe (again, not sure) IBO autotrims the size of the passed parameter
with this setting?

regards,
John


personalsoft_fabiano wrote:

> Hi, today i had to enable the 'DefaultNoTrimming' property of my
> connection to workaround a problem, and i would like to know what
> behavior this property changes, and if and how it can affect the rest
> of my application.
>
> I've read that if this property is enabled, the developer needs to
> trim all fielsd by hand, but the test below doesn´t show this, so i´m
> probably misunderstanding the docs:
>
> Database.DefaultNoTrimming := True;
> Q.SQL.Text := 'select nome from cad1 where numcad1 = 0');
> Q.Open;
> ShowMessage('*' + Q.FieldByName('nome').AsString + '*');
>
> It shows "*<name>*", without trailing spaces.
>
> So what does this IBO trims when 'DefaultNoTrimming' is False?
>
> Regards,
>
> Fabiano
>
>
> ------------------------------------
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info papers,
> keyword-searchable FAQ, community code contributions and more ! Yahoo! Groups Links
>
>
>
>
>

--
John vd Waeter
mailto:john@...
http://www.jvdw.nl
http://www.shotinthedark.nl