Visual FoxPro keeps changed (and new) records in a buffer. New records have negative numbers (recno() returns "-1" for the first record the user adds, "-2" for the second, etc.). Definitive (positive) values for recno() are available only after the record is successfully saved with TableUpdate().
You can either try to save all new and modified records (HELP TableUpdate()), or, if you feel the need to do this, save one record at a time (HELP GetNextModified()).
You can also test whether the current record is modified, new, or unchanged (HELP GetFldState()).
Regards, Hilmar.
>I see, but in that case, can i APPEND BLANK to add records to the tables? How does it know how many to rollback?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)