Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP with SQL Server -- Pkey
Message
 
 
To
16/01/2001 14:55:38
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00464309
Message ID:
00464353
Views:
25
>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.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform