Mike,

I am using manual in VFP. My "middle tier" class automatically issues the rollback/commit every time it is run.

I have had no probelms with this, but do a double-take when someone like you (ie smart) advises otherwise. What specifically are scenarios where I would have a problem with this?

Thanks,
Ken

>The last time I checked, VFP implemented "manual" transaction using SQL Server implicit transaction setting. When you enable implicit transaction, an explicit transaction is automatically started whenever a DML query is submitted to the server. The transaction is in place until the user explicit terminates it with either a COMMIT or ROLLBACK. The fun begins when the next DML query is submitted, which automatically starts another explicit transaction. Hence the reason that you need to disable VFP's manual transactions.
>
>-Mike