So the parameters are associated with columns of different dimensions?
That could explain why there is a problem. I'd really like a test case.

PS. Let's try to trim up messages a little better please...

Jason Wharton
CPS - Computer Programming Solutions
Mesa Arizona
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "nevillerichards" <neville@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, March 27, 2003 1:41 PM
Subject: Re: [IBO] TIBOQuery bug?


> I'm using Dialect 1 on Firebird 1.
>
> The columns weren't vastly different (6 chars versus 30 chars), but if
> that's how it has to be, then I can cope, now that I know what the score
is.
> Thanks.
>
> Neville
>
> ----- Original Message -----
> From: "Daniel Rail" <daniel@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Thursday, March 27, 2003 8:17 PM
> Subject: Re: [IBO] TIBOQuery bug?
>
>
> > Hi,
> >
> > At March 27, 2003, 15:37, nevillerichards wrote:
> >
> > > I think I understand what you are trying to tell me, but it doesn't
> explain
> > > why the query should have worked four times exactly as I (perhaps
> > > erroneously) expected, and blew up on the fifth. Neither have I come
> across
> > > the same limitation in Borland's (sorry) TQuery.
> >
> > Sometimes the BDE is more forgiving. Also are you connecting to your
> > database with Dialect 1 or Dialect 3? And, which version of Interbase
> > or Firebird are you using?
> >
> > > If I can't use the same parameter at two different places in a query,
or
> as
> > > you put it: I can't apply the same parameter to two different columns,
> why
> > > doesn't something tell me that, rather than just blowing up?
> >
> > What are the datatypes of the 2 columns? If the datatypes are
> > significantly different(one varchar bigger than the other), then you
> > might encounter problems. I'm currently using queries where the same
> > parameter name is used with against more than one column, but I make
> > sure the columns are of the same datatype and almost the same size.
> >
> > --
> > Best regards,
> > Daniel Rail
> > Senior System Engineer
> > ACCRA Group Inc. (www.accra.ca)
> > ACCRA Med Software Inc. (www.filopto.com)