3 Replies Latest reply: May 19, 2011 6:53 AM by Nick Swift RSS

    Record locking when loading data into a QV app

      Hi,

       

      Using QV10, we've started to get some problems around record locking when reloading data into our apps.  It mainly seems to happen when we reload an app from our local desktop QV that is running a SQL (2005) stored procedure from within the script.  We are using the standard ODBC SQL Server drivers to do this.

       

      This problem seems a little intermittent, but the symptons are the SP runs very slowly (but does complete) and users in our live software application experience deadlock errors when trying to access parts of the system using the tables these SPs are using.

       

      Has anyone else experienced similar things?  Is there a setting or way around this?  I'm not sure how QV performs its record locking, but it certainly appears to be locking something it shouldn't!

       

      Thanks

      Nick