Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Network:
Windows 2003 Server
I might have worked without the outputs as well.
>>I will admit that I am a lot more familiar with Sql Anywhere then Sql Server but I would call the sp this way
>>=mySQLExec("execute dbo.siriussp_rsGetBlocks @TemplateID = ?m.nTemplateID,?@nBlockCount, ?@nSeatsCount , 'rsTSBlocks'",program())
>>
>>Seems to me that if you pass a variable by reference then the value would be returned by the SP. I thought "output" was part of the parameter statement of the SP. Anyway, the above is how I would do this is Sql Anywhere.
>>
>This worked. Strange, but my original way (using named parameters) worked fine in one DB and didn't work in another. I tested it right now in working DB and after I made all parameters to be non-named, it worked.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement