Hi Helen,

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.

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?

Neville

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 26, 2003 9:28 PM
Subject: Re: [IBO] TIBOQuery bug?


> At 08:41 PM 26/03/2003 +0000, you wrote:
> >Using a TIBOQuery through a TIBODatabase (version 4.21) with SQL
something
> >like:
> >
> >select acode, aname from sometable
> >where acode like :s
> >or aname like :s
> >
> >After about four changes of the parameter using parambyname (closing the
> >query before change, then opening it) the query blows up.
> >
> >If I change one of the :s parameters for :s1, thus it doesn't have the
> >same parameter in the query twice, then it performs fine with absolutely
> >no other changes.
> >
> >Could there be a bug associated with the use of the same parameter twice?
>
> No, it's a bug in your statement!
>
> Parameters and parameter values are not the same thing. A parameter is an
> object associated with a database column. The token ":paramname" is a
> reference to the parameter, not its value. You can apply the same VALUE
to
> two different parameters, but you can't apply the same parameter to two
> different columns.
>
> Helen
>
>
>
>
>
___________________________________________________________________________
> 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/
>
>
>