JayeshC
asked on
Keyword Search
Hi.
I am working on a database program right now and i was wondering if anyone knew how to do a keyword search of an array.
so basically i load a data file, and then i wanna search the array for anything close to it. and then output the result. does anyone know of any tutorial programs that teach this or do you know how to do this. Visual Basic 6.0 code only. Thanks alot.
and the search will be from a textbox
I am working on a database program right now and i was wondering if anyone knew how to do a keyword search of an array.
so basically i load a data file, and then i wanna search the array for anything close to it. and then output the result. does anyone know of any tutorial programs that teach this or do you know how to do this. Visual Basic 6.0 code only. Thanks alot.
and the search will be from a textbox
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
database? ah, recordset!
dim rsSearch as adodb.recordset
dim fldSearch as adodb.field
dim strSearch as string
'populate recordset you fill in
set rsSearch = objSomething.getSomeRs
with rsSearch
if .Recordcount then
do while not .eof
for each fldSearch in .fields
if strSearch = fldsearch.value then
'do something
end if
next
.move next
loop
end if
end with
dim rsSearch as adodb.recordset
dim fldSearch as adodb.field
dim strSearch as string
'populate recordset you fill in
set rsSearch = objSomething.getSomeRs
with rsSearch
if .Recordcount then
do while not .eof
for each fldSearch in .fields
if strSearch = fldsearch.value then
'do something
end if
next
.move next
loop
end if
end with
ASKER