I want to use transactions to commit changes to SQL Server (get the connection name,SQLCOMMIT or SQLROLLBACK through SQL Pass-Through). The examples I see show the user committing changes by "connection name". If I have "invoice header/invoice detail" tables open in two different forms with the same connection name, what happens when I SQLCOMMIT changes from one of them? Do we commit changes from both forms?

In VFP, I always use private datasessions. Can I treat remote views like local views opened in a private datasession?