A string search??

[Guest_imported]

I would like to do a search for a given Social Security Number. And the second search would be the persons birthdate as dd/mm/yyyy. Thank you.

Juandiegomcc@yahoo.com

 

[troysf]

1. Use Locate For command is the two fields are not indexed.
2. use Seek() if the two fields are in the index.
3. Use SQL with Where Clause doing the qualifying.

Troy
San Francisco

 

[ramani]

To fetch the record having either a Security number or a date of birth from a file ...

USE (with index suitanly) or Select Myfile

LOCATE FOR mySecurityNumber = SocialSecurityNumber .OR. ;
myDateOfBirth = InRecordDateOfBirth
display as per your choice form

ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com

 

[dgrewe]

assuming you as indexes on ssan and birthdate

Use (table) order ssan alias ssan again in 0
use (table) order birthdate alias bd again in 0

do case
case seek(SSAN , "SSAN&quot
= UDF()
case seek(BIRTHDATE , "BD&quot
=UDF()
endcase


Procedure UDF
do stuff




David W. Grewe
Dave@internationalbid.com
ICQ VFP ActiveList #46145644