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

> 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.

Helen,

I did what you said. The strings look identical.

MY APP
------
/*---
PREPARE STATEMENT
TR_HANDLE = 26980260
STMT_HANDLE = 26979936

INSERT INTO MBTABLE VALUES('152 10917 ',? /* PRM_0
*/ ,? /* PRM_1 */ ,? /* PRM_2 */ ,? /* PRM_3 */ ,? /* PRM_4 */ ,? /*
PRM_5 */ ,? /* PRM_6 */ ,? /* PRM_7 */ ,? /* PRM_8 */ ,? /* PRM_9
*/ ,? /* PRM_10 */ ,? /* PRM_11 */ ,? /* PRM_12 */ ,? /* PRM_13 */ )

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]



IB_SQL
------
/*---
PREPARE STATEMENT
TR_HANDLE = 10594388
STMT_HANDLE = 10575644

INSERT INTO MBTABLE VALUES('152 10917 ',? /* PRM_0
*/ ,? /* PRM_1 */ ,? /* PRM_2 */ ,? /* PRM_3 */ ,? /* PRM_4 */ ,? /*
PRM_5 */ ,? /* PRM_6 */ ,? /* PRM_7 */ ,? /* PRM_8 */ ,? /* PRM_9
*/ ,? /* PRM_10 */ ,? /* PRM_11 */ ,? /* PRM_12 */ ,? /* PRM_13 */ )

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/