----- much snipped
>
>Let's also consider the fact that SQL Server will finish a transaction when a server reboots from a crash/power failure. This is built into the product requiring no coding from the programmer. Could you even emulate this with VFP?
>
>Jack Mendenhall
>Reinsurance Management, Inc.
----- end snip

J.

I'm *not* talking about that deep of a facility at all!!! Something VERY very simple, really. The most I would expect as far as transaction back-out is concerned is, on recognizing the absence of a prior connection that has some outstanding work being done for it, a rollback (if within a "transaction") or simply flush what's been done to date.

What I am after is some pretty good way to protect the data from careless users or poor power suppliers. Something significantly BETTER than what we have today with FP/VFP, but nowhere near what a SQL-Server offers.
Really, a chance to overcome the two most sensitive areas surrounding any "cheap" solution like VFP. Not a Caddy or a Rolls, just a Corvair with safety features.

Cheers,

Jim N