Ok let me rephrase my question. Why Does &vPCatList work in a choose box and not a popup. The '&' probably causing the problem but why
On 10 Jul 2003 at 11:34, Dan Goldberg wrote: > The first thing that I see missing is the comma before the return column > "PCategoryID". > > Dan > > > ---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) > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Victor > Timmons > Sent: Thursday, July 10, 2003 11:19 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - popup ver choose > > > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
