Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: DEREK DODOO
  Where is DEREK DODOO?
 READING, UK
 United Kingdom
 DEREK DODOO
 Tags
Subject: SEARCH FOR AN ITEM FROM A NO. OF FIELDS
Thread ID: 189266 Message ID: 189266 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Thursday, August 14, 2008 7:34:40 AM         
   


Dear All,

I'm doing a search which has to go through a number of related fields for qualification
of an individual.

from the datafile structure below

IDNO ( C )
NAME ( C )
QUAL1 ( C )
QUAL2 ( C )
QUAL3 ( C )
QUAL4 ( C )
QUAL5 ( C )


the system has to search through fields
QUAL1
QUAL2
QUAL3
QUAL4
QUAL5

which contain information on qualifications.


QUESTION.

1. If I issue a search for instance for 'HND' the program should search through fields
QUAL1
QUAL2
QUAL3
QUAL4
QUAL5


However 'HND' is just a substring or part of the content of the field.

For instance field QUAL2 content is say 'MARKETING HND' for an individual.

A program to search for say the substring 'HND' through the qualification fields
QUAL1
QUAL2
QUAL3
QUAL4
QUAL5


Thanks

ENTIRE THREAD

SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 7:34:40 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by surinder singh @ 8/14/2008 7:47:33 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 8:12:29 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by surinder singh @ 8/14/2008 8:34:19 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 8:17:10 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 8:48:23 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 8:57:28 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/14/2008 9:22:01 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Borislav Borissov @ 8/14/2008 9:35:09 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by DEREK DODOO @ 8/16/2008 2:37:29 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Stefan Wuebbe @ 8/16/2008 8:55:49 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Jim Booth @ 8/16/2008 7:09:36 AM
RE: SEARCH FOR AN ITEM FROM A NO. OF FIELDS Posted by Anders Altberg @ 8/16/2008 6:20:38 PM