powerh-l Digest, Vol 46, Issue 4

[Alan and Vicki]

----- Original Message ----- 
From: <powerh-l-request at lists.sowder.com>
To: <powerh-l at lists.sowder.com>
Sent: Thursday, March 05, 2009 2:00 PM
Subject: powerh-l Digest, Vol 46, Issue 4


> Send powerh-l mailing list submissions to
> powerh-l at lists.sowder.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.sowder.com/mailman/listinfo/powerh-l
> or, via email, send a message with subject or body 'help' to
> powerh-l-request at lists.sowder.com
>
> You can reach the person managing the list at
> powerh-l-owner at lists.sowder.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of powerh-l digest..."
>
>
> Today's Topics:
>
>   1. Search with wildcard in multiples fields (Etienne Rompr?)
>   2. RE:Search with wildcard in multiples fields (Ken Langendock)
>   5. Re:Search with wildcard in multiples fields (Etienne Rompr?)
>   6. Re:Search with wildcard in multiples fields (Nalder, Jay)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 04 Mar 2009 13:52:48 -0500
> From: Etienne Rompr? <erompre at koala-tech.com>
> Subject: Search with wildcard in multiples fields
> To: powerh-l at lists.sowder.com
> Message-ID: <49AECE00.3000404 at koala-tech.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi,
>
> PH 8.4
> OpenVMS with RMS files
>
> For PH and PHweb.
>
> Got an issue here.
>
> I need to be able to search in multiples fields in a file using one
> input field in the search screen.
>
> We are able to do it but we lose the wildcard use...
>
> A temp field with multiple search in the next screen called.
>
> Is there a way to do this kind of search screen while maintaining the @
> or the %@?
>
> Any help would be appreciated.
>
> Thanks!
>
>
> -- 
> Etienne Rompr?
>
>
> ------------------------------
>

My best suggestion would be the INDEX function -- approximates wildcards or 
"contains".

Pseudo code:

Temp search_text char*5 ....

Define ind_field_1 = index(field_1,search_text)
Define ind_field_2 = index(field_2,search_text)
and so on
...
...

Select if ind_field_1 ne 0 or ind_field_2 ne 0 or ....

No guarantees that the syntax is correct - basing this on memory only!
>