Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you pass named parameters to SQL SP?
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01455791
Message ID:
01519141
Views:
41
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
Previous
Reply
Map
View

Click here to load this message in the networking platform