Bill,
You could try building it like this
SET VAR vLUWhereClause TEXT = +
('PROPERTY vlu_vSBbktitle LOOKUPWHERECLAUSE' & .vWhere)
&vLUWhereClauseJan----- Original Message ----- From: "Bill Eyring" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]> Sent: Friday, June 13, 2008 12:53 PM Subject: [RBASE-L] - Property <compid> LlOOKUPWHERCLAUSE Question
I have a need to use the LlOOKUPWHERCLAUSE property for a variable lookup listbox control. I have a variable called vWhere which contains the where clause. (ex: 'where SBwriter=.vSBWriter and SBbktitle=.vSBbktitle order by BKtitle') I need to do it this way as there are many different combinations the user can select, therefore I cannot hardcode it. When I issue the command 'PROPERTY vlu_vSBbktitle LOOKUPWHERECLAUSE &vwhere', I get the error message '-ERROR - syntax is incorrect for the command PROPERTY (2045)' What am I doing wrong ? Thanks for the help. Bill Eyring
