I'd like a sample app with careful steps to repeat which will cause this
problem in my environment.
My intent is that you can do this and have it work flawlessly.

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 12:37 PM
Subject: Re: [IBO] TIBOQuery bug?


> 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