If a parameter is associated with a literal it will reflect the column type
and length of the literal. InterBase dictates this, not the client tool.
Just because you have given them names doesn't magically cause InterBase to
do anything special for you. In fact, I cannot even send the name of the
parameters to the server. I have to parse them down to just a single
question mark.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: <fabiano@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, August 24, 2001 11:36 AM
Subject: Re: [IBO] Problems with TIBOQuery.Params


> And what is the problem with this?
>
> select ...
> where ( :name like '*' or name like :name )
>
> Now it returns just on parameter (vartext(50)), but when i put a
> value on it (with more than one character) and open the query it
> raises an exception.
>
> ... Isn't there some way of the parameters always assume the datatype
> assigned manually, don't overriding them?
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > This is a feature of InterBase itself.
> > You need to find a different solution.
> > I recommend you look into using the SQLWhereItems and OnPrepareSQL
> event.
> > See the tech info sheet on this or search the archives.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com