Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Execute stored procedure with multiple parameters
Message
 
To
21/03/2006 16:45:34
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01106409
Message ID:
01106523
Views:
24
This message has been marked as a message which has helped to the initial question of the thread.
>Hi
>How can I execute a stored procedure with multiple parameter?...
>
>Within the help Found this command line (but just one parameter...):
>
>
> * Execute stored procedure with an INPUT parameter.
> SQLEXEC(m.lnConn, 'exec byroyalty ?lnPercent','HalfOffAuthors')
>
>Thnaks in advance.

Or you could use named parameters (If you know the names of the parameters, of course):
TEXT TO lcSql NOSHOW PRETEXT 15 TEXTMERGE
     EXEC MySP @Param1=<<m.Param1Value>>,@Param2=<<m.Param2Value>> &&etc.
ENDTEXT
Keep in mind that way you must enclose all char parameters with single quotation marks, i.e. @Param2 expect char value and m.Param2Value is string you must do:
TEXT TO lcSql NOSHOW PRETEXT 15 TEXTMERGE
     EXEC MySP @Param1=<<m.Param1Value>>,@Param2='<<m.Param2Value>>' && etc.
ENDTEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Reply
Map
View

Click here to load this message in the networking platform