>My guess is that somewhere you have an open transaction. Did you configure the VFP connection to use manual transactions with the SQLSETPROP() function. The turns on implicit transaction within SQL Server. You'll have to issue SQLEXEC(c, "COMMIT TRANSACTION") on the same connection that the view is using.
>
>BTW, implicit transaction are engaged until you use SQLSETPROP() to reset them.
>
>-Mike
Hi Mike,
You hit the nail right on the head with your last remark (ie implicit transactions). I had managed to stop Fox from hanging by peppering my code with SQLCOMMIT()'s, but I didn't really appreciate why I had to do so.
In my connection management object, I now set the TRANSACTIONS property to auto, so that Fox handles it for me, and I no longer need the SQLCOMMIT()'s. Thanks very much for finally nailing this one for me!
BTW - Does this mean that when TRANSACTIONS is on manual, when you start work with the server, Fox automatically begins a transaction IN SQL SERVER (rather than a Fox Transaction) and that therefore it's up to you to do an SQLCOMMIT() or and SQLROLLBACK() to end the transaction?