>>I own a product that was dicontinued in 1987, It was call Friendly Finder and worked with any xbase file for searching any field in any table(any without a memo field). I am wondering if anyone knows if something new is available for VFP or how to build one? I currently use SQL and run the query after every keystroke but this is slow.
>
>If the field you're searching for is indexed, and the order is set, then simply
IF NOT FOUND()
> lnrecno = RECNO(0)
> IF lnrecno > 0
> GO lnrecno
> ENDIF
>ENDIF
will work.
Hi George,
Is there any major difference between RECNO(0) and a SEEK() with SET NEAR ON - other than the obvious (the first doesn't move the record pointer). Which makes me wonder if INDEXSEEK() respects SET NEAR ON?
censored.