Yes it has been way too many years since we've seen each other, Manuel! Thanks for the kind words. I miss seeing all my programmer friends in person for sure Glad that suggestion worked for you. Karen -----Original Message----- From: Manuel De Aguiar <mwdeagu...@gmail.com> To: rbase-l@googlegroups.com Sent: Sat, Jan 21, 2023 4:06 pm Subject: Re: [RBASE-L] - VAR Lookup List Box PROPERTY LOOKUPWHERECLAUSE
Hi Karen! It has been so many years that we last saw each other in person. Maybe 20 years ago? You are always so kind with your time. Today I had time to revisit this challenge and I wanted to tell you it works! The WHERE clause in the variable Lookup List Box is like this: and with a pop up dialog box the user enters the phrase he wants the CONTAINS to look for. If the user enters the % symbol then all rows are displayed.I am not sure why the PROPERTY <Prop ID> LOOKUPWHERECLAUSE .vSrch did not work but I have spent way too much time on this to worry about it.Thank you and I wish Razzak could plan a convention/Reunion this summer for us all to meet once again. I think that would be great.Again Thank youManuel de aguiar323-243-122...@mdenterprises.net😊 On Thu, Jan 19, 2023 at 5:42 AM 'Karen Tellef' via RBASE-L <rbase-l@googlegroups.com> wrote: 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. -- 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/CABiOS4_GfHACPhWP%3DNuCrvRuLBppaDEH-gsUh39HrTRT1pv%3Dsg%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/433517407.373386.1674399015718%40mail.yahoo.com.