>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>>
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>>'
ENDTEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.