Mark,

SELECT gets its data from the disk file, the buffered change has not been posted to the disk file. The SELECT won't see the change until the buffer is tableupdated from the cursor.