In the code below I setup the var vPCatList to only include parts with PcatID's
Codes included in the var and display the choices for the user to select from.
If i use then var in a popup's where clause i get syntax error. IF I use the
same where clause with the var, in a choose box's where clause no error. I
don't understand why it works with the choose and not the popup
---Exit EEP in form---
--IntHw1.EEP
SET VAR vPCatList TEXT = NULL
IF .vHWCatID = 7 THEN --HW
SET VAR vPCatList TEXT = ('IN(42,45,48,49,52,55,56,64)')
ENDIF
IF .vHWCatID = 8 THEN --Locks
SET VAR vPCatList TEXT = ('IN(62,63,64,65,66)')
ENDIF
IF .vHWCatID = 14 THEN --Sill
SET VAR vPCatList TEXT = ('IN(44,83)')
ENDIF
---Where Clause from Popup---
WHERE CatID = .vHWCatID AND PCategoryID IN (SELECT PCategoryID FROM PartsList
WHERE CatID = .vHWCatID AND PCategoryID &vPCatList)
---Choose Box---
CHOOSE vXX FROM #VALUES FOR ((CTXT(PCategoryID)) & PCategoryDesc)PCategoryID
FROM ProductCategory WHERE CatID = .vHWCatID AND PCategoryID IN (SELECT
PCategoryID FROM PartsList WHERE CatID = .vHWCatID AND PCategoryID &vPCatList)
Victor Timmons
Tiz's Door Sales, Inc
425-258-2391
