Did you try it without the "where" in your expression:
'SBwriter=.vSBWriter and SBbktitle=.vSBbktitle order by BKtitle'
And maybe try parens around the expression:
('SBwriter=.vSBWriter and SBbktitle=.vSBbktitle order by BKtitle')
Just some Friday-type guesses.
Doug
Bill Eyring wrote:
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
