>>Won't the record be written to the table when the record pointer is moved?
>
>I guess it would depend if the buffering is on or off. Then, a choice has to be made to take the value of the buffer related to the previous record or the one from the disk.
Problems here...you make a few changes to a record, press the key to copy contents of a field from the previous record...so the record pointer is moved...and changes are written to the record...but not all changes have been made!!!
The other problem....in a multiuser environment...what was the previous record...if you simply SKIP -1, you could get a record added by another user.
Craig
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer