You are welcome.
Thanks,
Jason
Jason Kramer
University Archives and Records Management
002 Pearson Hall
(302) 831 - 3127 (voice)
(302) 831 - 6903 (fax)
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey
Sent: Wednesday, June 19, 2013 1:19 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: How To... Suggestions ?
Jason:
With a little playing around, I nailed it. You made me look like a hero.
That's why I love this list.
Thanks,
Dick Fey
On 6/19/2013 11:13 AM, Kramer, Jason J wrote:
> I use a CFA that builds a WHERE clause for exactly this situation. The
> approximate format is:
>
> SET VAR vmywhere TEXT = NULL
> SET VAR vmyquery TEXT = 'SELECT <REST OF SELECT>' (NOTE: This is just
> the part of the SELECT statement UPTO, BUT NOT INCLUDING the WHERE clause) IF
> <CONDITION 1> IS NOT NULL THEN
> SET VAR vmywhere = <CONDITION 1>
> ENDIF
> IF <CONDITION 2> IS NOT NULL THEN
> IF vmywhere IS NULL THEN
> SET VAR vmywhere = <CONDITION 2>
> ELSE
> SET vmywhere = .vmywhere & 'AND' & <CONDITION 2>
> ENDIF
> ENDIF
> ...
> IF <CONDITION N> IS NOT NULL THEN
> IF vmywhere IS NULL THEN
> SET VAR vmywhere = <CONDITION N>
> ELSE
> SET vmywhere = .vmywhere & 'AND' & <CONDITION N>
> ENDIF
> ENDIF
>
> IF vmywhere IS NOT NULL THEN
> SET VAR vmyquery = .vmyquery & 'WHERE' & .vmywhere ENDIF
>
> &vmyquery
>
> I check each condition in turn and add it to the WHERE clause if the
> condition has been specified by the end user.
>
> Thanks,
> Jason
>
> Jason Kramer
> University Archives and Records Management
> 002 Pearson Hall
> (302) 831 - 3127 (voice)
> (302) 831 - 6903 (fax)
>
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Dick
> Fey
> Sent: Wednesday, June 19, 2013 12:03 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Re: How To... Suggestions ?
>
> Probably didn't make this very clear.
> Sometimes the search will include 2 of the options, others 3, 4, 5 or 6.
>
>
> On 6/19/2013 10:51 AM, Dick Fey wrote:
>> One of my people wants a form with the ability to search a table
>> based on 6 different product specs.
>> One to six specs may be entered to be searched, others will have no
>> values entered.
>>
>> Question;
>>
>> How to build a query statement that searches based on an unknown
>> number of values.
>> This can't be as hard as I am envisioning.
>>
>>
>> Dick Fey
>> Carpet Broker Inc.
>>
>>
>>
>>
>
>
>
