The NEW Row State
A row in the NEW state contains newly added data. A NEW row was originally an UNDEFINED row into which data has been entered by the user or the program. If the user adds a new row by moving past the end of the data set and filling the newly opened row with data, the row has a state of NEW. This row remains in the NEW state even if a putrow statement overwrites the values the user entered. If a NEW row is deleted, however, it ceases to exist. It is important to distinguish between a NEW row added by the user and a row inserted into the table field with the insertrow statement. The latter row has a state of UNCHANGED, not NEW.