Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you pass named parameters to SQL SP?
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01455791
Message ID:
01519141
Vues:
42
What do we need to change for OUTPUT parameters?

UPDATE, figured this out
private nTemplateID, nBlockCount
      nBlockCount = 0
      nTemplateID = thisform.oCurrentNode.values("TemplateID").value
      =mySQLExec("execute dbo.rsGetBlocks @TemplateID = ?m.nTemplateID, @BlocksCount = ?@nBlockCount OUTPUT" , 'rsTSBlocks',program())
>I used the second Sergey's example and change the order of parameters. And the data in SQL was filled according to the parameter names not position. I will test again to be sure that this is how it works.
>
>Update: I tested again and it looks like parameters can be passed by name. Why did you assume that they cannot?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform