>Is there an easier way to detect if the record pointer is at the first or last record than EOF and BOF (which require I SKIP past them, causing problems).
>
>there has to be something better that what I have - something like :
>
>PROCEDURE myEOF
>LOCAL llRet
>
>IF .NOT. EOF()
> SKIP
> llRet = EOF()
> SKIP -1
>ELSE
> llRet = .T.
>ENDIF
>
>RETURN llRet
>
>Tim
IF RECCOUNT() > 0
lnCurrRec = RECNO()
GO TOP
lnTopRec = RECNO()
GO BOTTOM
lnBottomRec = RECNO()
DO CASE
CASE lnCurrRec = lnTopRec
WAIT WINDOW "At Top Record"
CASE lnCurrRec = lnBottomRec
WAIT WINDOW "At Bottom Record"
OTHERWISE
WAIT WINDOW "Someplace in the middle
ENDCASE
ENDIF
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer