Larry,
I knew the answer was simple and sure proved that. I used your first example and it works like a champ. Thanks again, Paul From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Thursday, September 10, 2015 4:27 PM To: [email protected] Subject: [RBASE-L] - Re: Question about the Lookupwhereclause Property of aVariable Lookup ListView You're making life much harder for yourself than you need to: SET VAR tWhere = ('WHERE Column1 NOT IN (SELECT Column1 from table2) AND column2 = ''' + .vTextValue + '''') PROPERTY idDrivingTable LOOKUPWHERECLAUSE .tWhere CLEAR VAR tWhere or PROPERTY idDrivingTable LOOKUPWHERECLAUSE 'WHERE Column1 NOT IN (SELECT Column1 from table2) AND column2 = .vTextValue' -- Don't clear vTextValue! -- Larry _____ From: Paul Buckley <[email protected]> To: [email protected] Sent: Thursday, September 10, 2015 3:48 PM Subject: [RBASE-L] - Question about the Lookupwhereclause Property of a Variable Lookup ListView Good afternoon, I am using the latest build of eXtreme 9.5 - 64 and I've got a syntax question about the property command. According to R:DOCS, the syntax for a Variable Lookup Listview is: PROPERTY <Component ID> LOOKUPWHERECLAUSE 'value' My "value" needs to be: WHERE Column1 NOT IN (SELECT Column1 from table2) AND column2 = 'ABC123' When I build the where clause as a variable, SET VAR vwhereclause = ('WHERE Column1 NOT IN (SELECT Column1 from table2) AND column2 = ' + .vquote + .vtextvalue + .vquote), then build the property command as a variable, SET VAR vcommand = ('PROPERTY iddrivingtable lookupwhereclause' & .vquote + .vwhereclause + .vquote), and then execute an &vcommand. I get a syntax error for the property command. I know it's the quotes around my text field but I can't figure out how to get it to work. Any suggestions/ideas? Thanks, Paul Buckley
