Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting a value from SQL Server stored proc
Message
 
À
05/07/2000 13:15:52
Gary Foster
Pointsource Consulting LLC
Chanhassen, Minnesota, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00388397
Message ID:
00388476
Vues:
15
You need to use a named parameter and pass it by reference. Something like this.

lnId = 0
lnResult = THIS.oSQL.execute("Execute sp_ww_NewId ?@lnId")

On return lnID will hold the result value. In many instances you'll also generate the result value as part of a cursor in the SP. If that's the case you can just look at the returned cursor as well.

+++ Rick ---
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform