Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Execute stored procedure with multiple parameters
Message
 
À
21/03/2006 16:45:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01106409
Message ID:
01106523
Vues:
22
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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform