>All of these entries are red, and when I view the details of any of the lines, I get the string that I passed to SQL Server in mt SQLEXEC() i.e. "sp_NewCustomer 0". The symbol to the left of the #12 is a hand over a green circle, which the legend says signifies 'Blocking'. If I kill the process at the top, VFP is freed up. This has got me totally mystified. My stored procedure is wrapped in a BEGIN TRAN, COMMIT TRAN, I've even tried adding a CHECKPOINT statement at the end of the SP.
>
>The only clue that I have is that if I close all connections between editing/saving my view and then adding a new customer and doing a REQUERY(), it works fine.
>
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