>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.
George
Ubi caritas et amor, deus ibi est