>Off course that is not the reason!! For example, if I use browse instead of SELECT, it will show all the changes and even appended record.

Yes, it's the reason. SQl Select doesn't use any open tables but opens it's own copies (similar to USE AGAIN). You can see that if you open your table in another work area using AGAIN clause.