How can I get Found() to return .T. on a SEEK

[mHeit]

Trying to do an incremental search.

Created cursor adapter that contains a cursor with insurance adjuster full names in 'adjuster' field (John Doe, Jane Doe, etc).
My select command is:"select distinct ins_info.adjuster from ins_info".
Also after cursor is created I create an index: INDEX ON UPPER(adjuster) TAG adjuster

In the Interactivechange event of the textbox I use, I put:

SELECT(this.LookupAliasName)
set near on
SEEK alltrim(this.TypedInValue)
if FOUND()
*do some processing
endif
set near off

*****
How come no matter what I type Found() returns false? Everytimes I type a letter the pointer moves to the closest matching record. But Found() never returns True.
What gives?

Thanks

 

[mHeit]

Sorry, figured it out.

Needed to set Exact off. Then it works fine. Duh!

 

[skoko]

You don't need ALLTRIM if near is set to ON.
Also, no needs for FOUND() either.

IF SEEK (this.TypedInValue)
 *do some processing
ENDIF

 

[mHeit]

Great! thanks for the extra info.