Search with wildcard in multiples fields

[Ken Langendock]

I'm not exactly sure what you are trying to do but maybe this approach would
help.

  TEMP T-StartsWith CHARACTER * 25 &
       RESET AT STARTUP

  DEFINE D-NameSize &
       = SIZE(TRUNCATE(T-StartsWith))

FILE Filename PRIMARY &
     OCCURS 16 &
     CACHE 255
  ACCESS SEQUENTIAL &
         REQUEST T-StartsWith

  SELECT IF (T-StartsWith EQ " " OR &
             T-StartsWith EQ UPSHIFT(fieldname OF filename[1:D-NameSize]))
OR &
            (T-StartsWith EQ " " OR &
             T-StartsWith EQ UPSHIFT(fieldname2 OF filename[1:D-NameSize])) 

Ken

-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Etienne Rompré
Sent: March 4, 2009 1:53 PM
To: powerh-l at lists.sowder.com
Subject: Search with wildcard in multiples fields

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é
-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe <password>' in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.

No virus found in this incoming message.
Checked by AVG. 
Version: 7.5.557 / Virus Database: 270.11.7/1982 - Release Date: 03/03/2009
4:09 PM
 

No virus found in this outgoing message.
Checked by AVG. 
Version: 7.5.557 / Virus Database: 270.11.7/1982 - Release Date: 03/03/2009
4:09 PM