>Just wondering if there is a situation where getfldState(-1) can return a NULL value? I have an error in a "data audit trail" program and going through the memory vars at the time of the error shows that the var (lcFieldState) is type "N", but no value is shown (so it seems to be null?).
>
>I looked in the help file and I don't have my hacker's guide with me!
>
>Kevin
Kevin,
Yes, getfldate(-1) can return null
As far as I can see you get a Null return if you are beyond the last record of a table/cursor
go bottom
skip
?eof() && TRUE
?getfldstate(-1) && Null
Getfldstate() returns info about the record you are on.
eof() means that you are on no record at all and hence its return has no meaning
Gregory