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: [image: image.png] 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 you Manuel de Aguiar 323-243-1224 [email protected] 😊
On Thu, Jan 19, 2023 at 5:42 AM 'Karen Tellef' via RBASE-L < [email protected]> 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 <[email protected]> > To: [email protected] > 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 you > Manuel de Aguiar > M|D Enterprises > 323-243-1224 cell > [email protected] > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/CABiOS48kRk3p6e6JCf28vZtnuK-HbgmsHkau640iB5cZiU5ZcA%40mail.gmail.com > <https://groups.google.com/d/msgid/rbase-l/CABiOS48kRk3p6e6JCf28vZtnuK-HbgmsHkau640iB5cZiU5ZcA%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rbase-l/252017736.2969006.1674135764892%40mail.yahoo.com > <https://groups.google.com/d/msgid/rbase-l/252017736.2969006.1674135764892%40mail.yahoo.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABiOS4_GfHACPhWP%3DNuCrvRuLBppaDEH-gsUh39HrTRT1pv%3Dsg%40mail.gmail.com.
