At 10:27 AM 28/05/2003 +0000, you wrote:

>Hello,
>
> BCB6sp4, IBO4.2Hg, FB-1.0-796
>
> I dynamically generate the SQL string used in a TIB_DSQL
>component. The string is:
> INSERT INTO MBTABLE VALUES('152
>10917 ',?,?,?,?,?,?,?,?,?,?,?,?,?,?)
>
> When I call Prepare(), the following error is generated:
>
> "Value out of range" EIB_ColumnError
>
> If I take the string and use IB_SQL to prepare it, it works fine.
>
> Any thoughts?

Yup, this problem yells "Monitor me!"

Put a monitor in your app and also start the monitor in IB_SQL. You will
find immediately you run each instance of the statement in its respective
environment what is the difference in the SQL being sent to the API.

I think I'd want to watch and see whether the trailing blanks are being
stripped off in IB_SQL. I'm curious to know what is the datatype of that
string of digits and blanks, too.

Helen