OPERAND help

[lashwarj]

I am recieving an error saying missing operand. It is in the portion of my code where I do a select * from database

 

[DSummZZZ]

Rick,

I was just doing it for debug readability. Maybe something in the macro expansion is going on that I don't know about since it is working with just one item.

lashwarj,
Try it without adding the ';' and 'CRLF'. Just do it like this:

IF ThisForm.Donor_Check.Value = 1
IF !EMPTY(criteria)
criteria = criteria + " AND "
ENDIF
criteria = criteria + ;
" lcdonor $(upper(historian.donor)) "
ENDIF

IF ThisForm.photographer_Check.Value = 1
IF !EMPTY(criteria)
criteria = criteria + " AND "
ENDIF
criteria = criteria + ;
" lcphotographer $(UPPER(historian.photo_take)) "
ENDIF

Dave S.

 

[lashwarj]

All set folks I appreciate all of your assistance. you all rule.