>>I,ve made a search form for my little program but I.m having a bit of trouble getting the search form to search all the fields in a database, I can only get it to search one field. Can somebody help me?
>>
>>Thanks!
>>Bill Clark
>
>Boy we are critical of each other, no I will enjoy some.
>
>Robert,
>The guy wanted to search ALL fields not just indexed ones.
>Your FOR NEXT loop should have been a DO WHILE set up as so:
>DO WHILE !EMPTY(TAG(jx))
> jx = jx +1
>ENDDO
>Also, an index key can be compound, OF VARYING DATA TYPES,
>TRIMmed or mabey even SOUNDEXed in HEBREW by some (OR ONE).
>You'll need some damn good error trapping for that one.
>
>It is also likely that if he wants to search all fields,
>he wants more than a STARTS LIKE search.
>
>Tom,
>I think AFIELDS() is the way to fly.
>
>It is similar to what we talked about for finding something
>in an .scx file.
>Here is a stripped down version (So it fits within a message)
>of the function that I use for tables I no nothing about.
>The ones I know about, I usually do a SELECT SQL with lots
>of OR's in the WHERE clause.
Chris
Yeah, that's the way I read it too!
Thanks
Tom