Subject | param length limit |
---|---|
Author | tailuo2002 |
Post date | 2006-01-14T05:30:50Z |
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 ?
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 ?