Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP with SQL Server -- Pkey
Message
 
 
À
16/01/2001 14:55:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00464309
Message ID:
00464353
Vues:
24
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform