Helen Borrie :

Thanks for your reply.

But, I can execute the sql in IBExpert , how do you explain this?



--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

>
> At 05:30 AM 14/01/2006 +0000, you wrote:
> >Hi,
> >
> >I'm using D7+IBX+Firebird 1.5.2
> >
> >
> >This is the SQL in IBQuery1:
> >
> >select * from grp where gno like :p1
> >
> >The datatype of gno is varchar(12)
> >
> >When I assigned '001001001001%' to p1 in application, an error
> >raised as:
> >
> >---------------------------
> >Trying to store a string of length 13 into a field that can only
> >contain 12.
> >---------------------------
> >
> >It's so strange.
> >
> >The P1 is not a field, why it is limited to 12 ?
>
> Sure it's a field. It's defined from the metadata returned to the

client

> when the query is prepared on the server, to be a field of the

same size

> and type as GNO.
>
> So the only part of this that is strange is why you use LIKE (a

wildcard

> search) for a test that is offering a search string consisting of

the full

> 12 bytes. All you're doing here is asking for all values that

exactly

> match or might have one or more characters following the matching
> string. The search is invalid, because the column definition

precludes the

> existence of any values longer than 12. If you intend to pass all

12

> characters to the param, use an equality search.
>
> ./hb
>