>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.

Correct. But the purposeful design of VFP's SQL is to include only "REAL" data in a query result.

There is a wish list entry asking for an option to specify that UNcommitted changes be includeable too. Maybe you want to add your voice to it!?

cheers