Thank you all for your assistance. :)
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A.
Razzak Memon
Sent: Wednesday, December 10, 2008 12:57 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: LookUpWhereClause
In addition ....
If you need to concatenate or define the vWhereClause string with
TEXT values, try the following technique:
Example:
-- Defining Global Search
-- Database: RRBYW16
-- Table: OrderSummary
-- Associated columns used in search criteria:
. RegistID
. SLastName
. SFirstName
. SCompany
. SCity
. SState
. SZipCode
. SCountryName
. SEMail
. BLastName
. BFirstName
. BCompany
. BCity
. BState
. BZipCode
. BCountryName
. BEMail
-- Search Keyword
SET VAR vKeyword TEXT = 'whatever'
-- Pre-define variables
SET VAR vQuotes = (CVAL('QUOTES'))
SET VAR vMany = (CVAL('MANY'))
SET VAR vSearchString TEXT = NULL
SET VAR vWhereClause TEXT = NULL
SET VAR vSearchString = (.vQuotes+.vMany+.vKeyword+.vMany+.vQuotes)
-- Define vWhereClause
SET VAR vWhereClause = +
('(CTXT(RegistID)) LIKE'&.vSearchString&'OR ' + +
'SLastName LIKE'&.vSearchString&'OR ' + +
'SFirstName LIKE'&.vSearchString&'OR ' + +
'SCompany LIKE'&.vSearchString&'OR ' + +
'SCity LIKE'&.vSearchString&'OR ' + +
'SState LIKE'&.vSearchString&'OR ' + +
'SCountryName LIKE'&.vSearchString&'OR ' + +
'SEMail LIKE'&.vSearchString&'OR ' + +
'BLastName LIKE'&.vSearchString&'OR ' + +
'BFirstName LIKE'&.vSearchString&'OR ' + +
'BCompany LIKE'&.vSearchString&'OR ' + +
'BCity LIKE'&.vSearchString&'OR ' + +
'BState LIKE'&.vSearchString&'OR ' + +
'BCountryName LIKE'&.vSearchString&'OR ' + +
'BEMail LIKE'&.vSearchString)
-- Refresh the Variable Lookup ListView WHERE Clause
PROPERTY ListViewCompID REFRESHLIST 'TRUE'
RETURN
Have fun!
Very Best R:egards,
Razzak.
This electronic message contains information from The Ohio Masonic Home, its
operating subsidiaries or affiliates. The information may be confidential,
privileged or otherwise protected from disclosure. The information is intended
to be received solely by [email protected], for use as designated in the
message. If you are not the designated recipient, you are instructed not to
review, disclose, copy, distribute or otherwise use of this transmission or its
contents. If you have received this transmission in error, please notify The
Ohio Masonic Home immediately at [EMAIL PROTECTED]; in addition, please delete
your record of transmission. Sending, receiving, downloading, displaying,
printing material that is harassing, fraudulent, offensive, intimidating,
defamatory, or otherwise unlawful or inappropriate is strictly prohibited by
The Ohio Masonic Home.
