Query using Promt Form with empty Fields

KnightWare

Can you create a Query FIND string that reads the "Filters" from a form, and ignores if one is undefined?

Query:
FIND BO_OBJ WHERE
BO_OBJ.ATTRIBUTE_A = BO_PROMPT.PROMPT_A and
BO_OBJ.ATTRIBUTE_B = BO_PROMPT.PROMPT_B and
BO_OBJ.ATTRIBUTE_C = BO_PROMPT.PROMPT_C

Works great if both PROMPT_A,B & C have data, but when empty, I want it ignored. The query runs against an external SQL DB View.

BLOMASKY

FIND BO_OBJ WHERE
(BO_OBJ.ATTRIBUTE_A = BO_PROMPT.PROMPT_A OR BO_PROMPT.PROMPT_A IS UNDEFINED) and
(BO_OBJ.ATTRIBUTE_B = BO_PROMPT.PROMPT_B OR BO_PROMPT.PROMPT_B IS UNDEFINED) and
(BO_OBJ.ATTRIBUTE_C = BO_PROMPT.PROMPT_C BO_PROMPT.PROMPT_C IS UNDEFINED)

KnightWare

This seems to be bringing back ALL the data.

KnightWare

Then again maybe not. More testing.....

BLOMASKY

make SURE you have the parenthesis in the right place. You need to enclose the OR statements in ()

Bruce