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)
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>