Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can you pass named parameters to SQL SP?
Message
 
 
To
19/03/2010 22:14:15
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01455791
Message ID:
01455902
Views:
55
You can not pass named parameters using SPT from VFP. In VFP parameters are defined by position, not by name.

>Thank you.
>
>>The best way is to use SPT parameters.
>>
>>SQLEXEC(, "EXEC mysp ?Param1, ?Param2, ....")
>>* OR
>>SQLEXEC(, "EXEC mysp @Param1=?Param1, Param2=?Param2, ....")
>>
>>
>>>
>>>How do you pass named parameters from VFP to SQL Server using SPT? (If it is possible)
>>>
>>>TIA.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform