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 youManuel de AguiarM|D
Enterprises323-243-1224 [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.
--
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.
