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