I'd like to use this:

(WITH PART_OF=MASTER" AND COMPOSED_OF=') OR WITH PART_OF NE 'MASTER'

The only problem is the test button puts another WITH in front, making and invalid statemant.

I tried:

WITH PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=')

and several other variations but no joy….what is the secret?

arcs@arcscustomsoftware.com

[url=http://www.arcscustomsoftware.com/]ARCS, Inc.

Paxton,

If you just skip the WITH statement, it'll put it in there automatically, so just type:

PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=')

and it should change to:

WITH PART_OF NE 'MASTER' OR (WITH PART-OF=MASTER" AND COMPOSED_OF=') when you test/compile it.

-Stephen Revelation

Hi Setphen:

      Well, it SHOULD but it DOES NOT it says "(WITH is an invalid dictionary item...."

If I put a space between ( and WITH,

It says: "invalid words. (AND EQ)…."

Other Ideas? Thanks, arcs@arcscustomsoftware.com

[url=http://www.arcscustomsoftware.com/]ARCS, Inc.

Paxton,

Apparently, and I'm assuming that this is your selection criteria query, parentheses are not valid in your statement. I've tried using them in a similar fashion in RLIST and in my query and received the same sorts of errors. However, the logic or OR before the AND seems to have the same effect in this particular two-way logic scenario so that if you have:

PART_OF NE 'MASTER' OR WITH PART-OF EQ "MASTER" AND COMPOSED_OF EQ ''

and then click TEST, the WITH will precede the PART-OF at the beginning and the intended logic should prevail. I tested it here on one of my examples and all works fine.

-Stephen Revelation

Thanks,Stephen

I played around some more in AREV and found my syntax error.

The following will work in OI query. As you suggested, start with the part of the statement that does not need the ().

WITH PART_OF NE "MASTER" OR ( WITH PART_OF=MASTER' AND WITH COMPOSED_OF=')

works!

I apologize for taking your time, with my simple syntax error.

-Paxton

View this thread on the Works forum...