Is this a bug or intended?
When I use the simple form to create a query
IF OBJA.XYZ = 'P' AND
OBJA.ABC = 'W' OR
OBJA.ABC = 'Y' OR
OBJA.ABC = 'V' OR
OBJA.ABC = 'G'
It produces in the text form
FIND OBJA WHERE (OBJA.XYZ = 'P' AND OBJA.ABC = 'W') OR OBJA.ABC = 'Y' OR OBJA.ABC ='V' OR OBJA.ABC = 'G'
The result for the above FIND, of course, is not what was intended. I'm looking for XYZ = ' P' combined with anyone of the ABC values. Shouldn't the syntax produced be:
FIND OBJA WHERE (OBJA.XYZ = 'P)' AND (OBJA.ABC = 'W' OR OBJA.ABC ='Y' OR OBJA.ABC = 'V' OR OBJA.ABC = 'G'))
I modify the output in the 'text' form and it works as intended.
compound conditions for FIND
Hi,
I must admit that it seems like a shortcoming (albeit a small one) that the simple query builder allows you to build a complex query which it can't interpret.
It makes more sense that the simple query builder only builds what is can cope with - probably something that support needs to consider modifying.
Peter
I must admit that it seems like a shortcoming (albeit a small one) that the simple query builder allows you to build a complex query which it can't interpret.
It makes more sense that the simple query builder only builds what is can cope with - probably something that support needs to consider modifying.
Peter