Manuel: When I'm constructing variables like you are, I NEVER embed the actual value in the where clause. Too difficult to deal with quotation marks, etc. I find that if you just do something like this: SET VAR vWhere = 'Company CONTAINS .vSearchValue' you don't have to worry about that kind of stuff. Have you tried this? Karen -----Original Message----- From: Manuel De Aguiar <mwdeagu...@gmail.com> To: rbase-l@googlegroups.com Sent: Wed, Jan 18, 2023 7:26 pm Subject: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Hello everyone, I think I tried every combination possible, but the right one, to use the property command LOOKUPWHERECLAUSE for the variable lookup list box object and it simply does not work..Using the RRBYW20 database from R:BASE X.5, Enterprise, U.S. Version, Build: 10.5.5.10818 I added a search feature to the form: DynamicListViews and it simply does not work. When you have a long list of customers it would be nice to have a way to limit the display using a CONTAINS where clause. For example I may want to list only those companies that have an 'Inc' on the company name.. If I add the following WHERE clause on the object: Company CONTAINS 'Inc' and run the form it behaves properly and displays those companies that have 'Inc' on their name. However if I try to do it programatically.SET VAR vWhere = + ('Company CONTAINS' & CHAR(39)+ 'Inc' +CHAR(39) & CHAR(39) ) It fails to display a list of any company. I tried different combinations without success. If anyone has an answer. I will GREATLY APPRECIATED IT.......Thank youManuel de AguiarM|D Enterprises323-243-1224 cel...@mdenterprises.net -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABiOS48kRk3p6e6JCf28vZtnuK-HbgmsHkau640iB5cZiU5ZcA%40mail.gmail.com. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/252017736.2969006.1674135764892%40mail.yahoo.com.