[RBASE-L] - RE: Question about the Lookupwhereclause Property of aVariable Lookup ListView

[Richardson, Jeff]

Instead of:

SET VAR vcommand = ('PROPERTY iddrivingtable lookupwhereclause' & .vquote + 
.vwhereclause + .vquote)

Does this work?

SET VAR vcommand = ('PROPERTY iddrivingtable lookupwhereclause ' + .vquote + 
.vwhereclause + .vquote)



-----Original Message-----
From: rbase-l@rbase.com [mailto:rbase-l@rbase.com] On Behalf Of Paul Buckley
Sent: Thursday, September 10, 2015 3:49 PM
To: Richardson, Jeff <jrich...@dmainc.com>
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