Jim
are you serious, wish list for that?
I have to see that. What would be the purpose of using SQL with the uncommitted changes?


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