I have never done more than one field in a dynamic where clause. You can use the right click eep(or a small button with an arrow next to the field) and use a choose box. This is top of my head but you should get the idea. --declare variables set var vfield1 text,vfield2 text,vreturnvalue text --get lookup fields dialog 'Enter first value' vfield1 whtemp 1 dialog 'Enter second value' vfield2 whtemp 1 --display choose box based on lookup fields choose vreturnvalue from #value from tablename where WHERE (field1 CONTAINS .vfield1 OR field2 CONTAINS .vfield2) --put value in field on form PROPERTY <ComponentID> TEXTVALUE .vreturnvalue Dan Goldberg
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Claudine Robbins Sent: Monday, August 04, 2008 2:37 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PopUp Dynamic Where Clause OK, Jean Marc checked and they are. Only whichever is the first one in the WHERE clause gets evaluated, never both at the same time. _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, August 04, 2008 12:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PopUp Dynamic Where Clause Don't quote me on this, but I think I tried this once and both of the fields have to be displayed in your popup. Are both yours? Karen Follow-up question on this subject. WHERE field1 CONTAINS '&' works fine, but WHERE field1 CONTAINS '&' OR field2 CONTAINS '&' WHERE (field1 CONTAINS '&' OR field2 CONTAINS '&') Only brings up the results of the field1 comparison. Anything else I'm missing? TIA, Claudine
