Very Computer

by **jaime Villarroel valde** » Fri, 14 Jul 1995 04:00:00

I need to search a line in a field with names (datas), the idea is show
the names that commenceing with the string that the user places when he
write char for char in a field named "Find Name":.

Example:

Find Name: _______car_______________________________ (put the name char
for char)

Field of names:
______________________________________________________ (show the names)
_car Mark_____________________________________________
_caro Mac_____________________________________________
_carolan jhon_________________________________________
_carolan Klen_________________________________________
_....._______________________________________________
______________________________________________________
______________________________________________________
______________________________________________________

by **Ken Luthe** » Tue, 18 Jul 1995 04:00:00

If I understand your question correctly, all you need to do is
SET EXACT OFF and activate an index tag that is UPPER() on your
name field. Doing a SEEK on UPPER('car') will find all the names
in your example.

--
Ken Luther
dCustom Systems Design, Inc.
71160,3707 (913)764-1606

by **Brian Copela** » Fri, 21 Jul 1995 04:00:00

J>I need to search a line in a field with names (datas), the idea is
J>show the names that commenceing with the string that the user places
J>when he write char for char in a field named "Find Name":.
J>
J>Example:
J>
J>Find Name: _______car_______________________________ (put the name
J>char for char)
J>

J>
J>
J>Field of names:
J>______________________________________________________ (show the
J>names) _car Mark_____________________________________________
J>_caro Mac_____________________________________________
J>_carolan jhon_________________________________________
J>_carolan Klen_________________________________________
J>_....._______________________________________________
J>______________________________________________________
J>______________________________________________________
J>______________________________________________________

The code below shows a method of using AT() and SUBSTR() to search a
field for the occurrence of a search string and the displaying the field
starting with the character where the search string appears.

read
m.search=alltrim(m.search)
go top
scan
m.start=at(m.search,cli_lname)
if m.start>0
* match is found
? substr(cli_lname,m.start,len(cli_lname)-m.start)
endif
endscan

Very Computer

I Need Help: Search a line in a field

I Need Help: Search a line in a field

I Need Help: Search a line in a field

I Need Help: Search a line in a field