And now for something completely different.



SELECT * FROM xxxx WHERE RECNO() = nnn INTO TABLE C:\TEMP\APPENDME.DBF
*
* make any changes to APPENDME record here
*
SELECT xxxx
APPEND FROM c:\temp\appendme.dbf
USE IN APPENDME
ERASE C:\TEMP\APPENDME.DBF




Two things happen:

1) You don't have "empty" records in your table
2) You have only one line of code where the table is changed, not two ( APPEND BLANK and GATHER ) or ( APPEND BLANK and REPLACE )