Would someone mind posting this in the priority support forum? We no longer have a support subscription, but I think this bug is pretty serious for client/server development. I sent an email to ProMatrix, but never received a response. Thanks.
--------------------------------
We are finally finishing up adding SQL Server support to our app, and I ran into a problem. Here’s how to repro:
1. Activity Tracking should be turned on.
2. Your SDATA and SVPM remote views should be set up to use a shared connection.
3. Open up the Security->Users form, make a minor change, and Save. This could be another admin form, but the important thing is that the connection has now been put in “Manual Transaction” mode by SQLSetProp().
4. Open any form in your app so that a record gets added to the activity log.
5. Open SQL Server Management Studio and execute the following query: select * from svpmactivity where svpmactivity.tdatetime > dateadd(day,-1,GETDATE())
6. The query will never complete until you close your app.
The problem is that VPMApp.AdminTool_ActivityTracking() performs a TableUpdate(), but no SQLCommit(). So, the transaction is left open on SQL Server and no other connections/users can access the table until the transaction or connection is closed. There are several other places in VPMApp and VPMDataHandler that have the same problem. I can fix on my end (I wrote a TableCommit() function that includes SQLCommit()), but if you decide to post a fix in the ProMatrix Library forum, please let me know.
Thanks,
Joel Leach