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
