Jennifer,
A couple of things. Your second piece of code only uses Location not
LocationID.
You can build your WHERE clause kind of like this.
This particular database I'm working on has Double Quotes
SET VAR vChooseCustA = ("("""+.vCustNoTxt+""")")
SET VAR vListChooseCust TEXT = (SRPL(.vChooseCustA,",",""",""",0))
SET VAR vWhere = ("WHERE DELDATE = .vChooseDate AND CUSTNO IN
"+.vListChooseCust)
Then in your listview you place this in your WHERE clause
&vWhere ORDER BY LastName ASC
Jan
-----Original Message-----
From: "Roberts, Jennifer" <[EMAIL PROTECTED]>
To: [email protected] (RBASE-L Mailing List)
Date: Wed, 10 Dec 2008 11:51:48 -0500
Subject: [RBASE-L] - LookUpWhereClause
Hello,
I have a variable listview, and I am trying to change the lookupwhereclause
through code. It was working before when the clause with written like this:
PROPERTY vlookuplist LookUpWhereClause ‘WHERE LocationID = 1 ORDER BY
LastName ASC’
PROPERTY vlookuplist REFRESHLIST ‘TRUE’
So why wouldn’t it work like this:
PROPERTY vlookuplist LookUpWhereClause ‘WHERE LOCATION =
‘#39’SMC’#39’ ORDER BY LastName ASC’
PROPERTY vlookuplist REFRESHLIST ‘TRUE’
Thank you,
Jennifer Roberts
Business Applications Specialist
Ohio Masonic Home
937.525.3080
x5788
