Hello Charles,
>To be more succinct ... isn't the proper approach to use both VFP
AND SQL Server transactioning istead of an either or approach?
when I get your message right the problem comes from VFPs behavior with Table Buffered Views. Update is done as long as everything works fine. When an error occurs VFP doesn't do a rollback on already updated records i a table buffered view.
We have already discussed this in our project and are using a own DAO. In this one we will wrap the real TableUpdate() into a VFP Transaction.
Perhaps this would be a good idea to integrate this behavior in the framework.
Marcus