Just make sure you put your parenthesis in the right way and you should be
fine.
If you need to have two parameters with the same name and be treated as a
single parameter IBO will allow that if the physical data type of the
columns being compared to are the same.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Paul Schmidt" <paul@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, March 13, 2001 8:47 AM
Subject: [IBO] Order of Perameters


>
> Hi List:
>
> This is more an IB question then an IBO question, but since we seem
> to have the same gurus here, and in IB Support, I'll post here.... I
> haven't tried this, but would like to know if I am thinking the right
> way....
>
>
> I have the following select :
>
> SELECT * FROM Table1 WHERE ((x = :x1 AND w= :w1 ) OR y= :y1 OR z=
> :z1) AND
>
> Yes X1, Y1, Z1 and W1 are parameters, here are the possibilities
>
> X1/W1, Y1 and Z1 all contain values, that will return a different set
> of records, which set can I expect to get back, the set belonging to
> X1/W1, Y1 or Z1?
>
> X1, W1 and Y1 are NULL, in which case we do NOT want to match the
> NULL, we want to get the set matching Z1 instead, will this happen?
>
> X1 = 'YONGE' , w1 = 'TORONTO' we want YONGE ST in TORONTO we do not
> want, under any curcumstances YONGE ST in MOOSENOSE
>
> Am I being reasonable or am I far enough in left field to be off the
> planet.....
>
> Thanks
>
> Paul
>
>
>
>
>
>
>
>
> Paul Schmidt,
> Tricat Technologies
> Email: paul@...
> Website: www.tricattechnologies.com
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>