Thanks to Dawn, Jan, Doug and Larry for your help. Each reply was helpful. I decided to use Dawn's suggestion to use the &vWhere value in the Lookup Settings > Where Clause for the listbox. This worked well for me. Bill Eyring
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, June 13, 2008 4:54 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Property <compid> LlOOKUPWHERCLAUSE Question Bill, If you're always going to set vwhere equal to the where clause, why can't you just put &vwhere in the Lookup Settings > Where Clause for the listbox? That's how I do it. However, if that doesn't work for you, it could be a quotes issue. If you were to type directly into the PROPERTY command, you'd type something like: PROPERTY componentid LOOKUPWHERECLAUSE 'where x = x' You need those quotes. If your &vwhere variable doesn't include the quotes, maybe it's throwing it off?? Another Friday guess.... Dawn Hast "Bill Eyring" <[EMAIL PROTECTED]> wrote on 06/13/2008 03:53:38 PM: > 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
