Thanx, it was that

> Different data types which are not assignment compatible at the buffer
> level.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Sandeep" <sandeep@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, November 01, 2001 4:21 PM
> Subject: [IBO] Query Parameter List Bug
>
>
> > I have a query like this
> >
> > update tableA
> > set fldA = fldA / :pm1,
> > fldB = fldB / :pm1,
> > fldC = fldC / :pm1,
> > fldD = fldD / :pm1,
> > fldE = fldE / :pm1,
> > fldF = fldF / :pm1
> > where <some condition = :pm2 >
> >
> > when I do a prepare on query I get 2 parameters in ParameterList.
> > But I have a similar query where I all pm1's are interpreted as
> > different parameters. What could be causing it?
> >
> > Sandeep
> >
> > Software Developer
> > CFL
> > sandeep@...
> > http://www.cfl.co.nz
> >
>
>
>
>
> ___________________________________________________________________________
> 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/
>
>

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz