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.
