Eirc,
I don't suppose you have set fields to trim spaces have you?
Alan

> -----Original Message-----
> From: Eric Handbury [mailto:ehandbury@...]
> Sent: Wednesday, 28 May 2003 10:17 PM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Re: EIB_ColumnError on Prepare()
>
>
> --- 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 ]
> ----*/
>
>
>
> __________________________________________________________________
> _________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> __________________________________________________________________
> _________
> http://www.ibobjects.com - your IBO community resource for Tech
> Info papers,
> keyword-searchable FAQ, community code contributions and more !
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>