>Hi All. Can anyone explain the logic that RECNO() should return a value of 1 when a file has no records? VFP8/SP1. Its in the docs but why? Surely RECNO() should return 0 if there are no records?


hi Jos,

When the recno() is one more than the number of records you have an eof() condition.

use Table && with records
go bottom
skip   && now recno() = reccount + 1 and eof()

create cursor ppp(ppp I)

?recno(), reccount(), eof()