>Thanks Elmer, I already understood that. I was trying to point out that the SQL SELECT would pick up the deleted records in an uncommited table/cursor.

Yes, but SQL Select will also not get new records that are added but uncommitted when buffering = 5. Try this. With set deleted on, create a cursor, set buffering to 5, do not do tableupdate, select * from that cursor. You should get no records because the 2 records added are buffered and not yet committed. It works the same for deleted records. If you tableupdate the 2 new records, then delete one of them without tableupdate, when you select * you will get both records with neither deleted. However once the buffered deleted record is committed, when you select * you will get only one record.