>>Won't VFP then update all those records you appened to the view if the view is >updateable. Seems like a lot of work. I just use SPT for ad-hoc queries, then >when the user selects a record to edit I bring that record down using a view >parameterized on the PK.
>
>If you USE the view with NOUPDATE then it shouldn't
>
But what if you want the view to be updatable (which in my opinion is the only time a view gives you much convenience, anyway)?
>
>Another point: Does SPT have and advantages over views when it comes to transactions/multi-user updates? I doubt it but opinions are welcome.
>
I can't think of any. You can still set a view's connection for manual transactions.