>Thanks Larry. How can I check to see if SQl server is releasing the primary key via the @@identify command quick enough? That is what it appears to be doing. My RV is on conn handle 5. If I run the sql passthrough command to get teh results of the @@ identitify, it tells me conn handle is busy. If i run the same line in the command window, it works from there and i can conduct a requery.
What is the Asynchronous property set to for your connection? If it is set to .F. (default), then you should not get any results until SQL Server has finished processing your RV update. If, however, it is set to .T., then SQL Server will immediately return control back to VFP and you have to constantly check to see if it is complete.
Also, what is the return value of Tableupdate() when you update the RV? Is it returning .T. indicating the update worked?
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao