CREATE CURSOR temp (f1 c(10)) INSERT INTO temp VALUES ("bbb") INSERT INTO temp VALUES ("ccc") INSERT INTO temp VALUES ("aaa") INDEX ON f1 TAG f1 GO top SKIP -1 ? BOF() --------------------------> .T. ? RECNO() ------------------------> 3 REPLACE f1 WITH "xxx" ? f1 -----------------------------> "xxx" ? BOF() --------------------------> .F. ? RECNO() ------------------------> 3Granted I have almost never worked with BOF() but it took me a while to discover why
LOCATE FOR somecondtion SKIP -1 IF BOF() && Am I at top of file -- yup SKIP && thought I was going to top of file but was actually going to 2nd record ENDIFdidn't work properly