Great idea Dan! Only Jean Marc's DBEdit is in a scrolling region and he only wants his user to enter ONE value that he wants to check against one or the other of TWO fields in the same lookup table.
Claudine _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Goldberg Sent: Monday, August 04, 2008 5:29 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: PopUp Dynamic Where Clause 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
