I am building COM add-ins to POS with VB.NET I'd like tu use QSRules.Session.Database to run stored procedure But I don't know how. Procedure has one input parameter and the other is output parameter. Can anyone know how I should do that?
You're not going to be able use the output parameter using the functions in QSRules. You need a command object to set the parameters and retrieve the output value after running the command. QSRules will let you run a sp that returns a recordset, but nothing that lets you work with a command as far as I know.
You can steal the connection string from QSRules by running a simple query then checking the ActiveConnection property of the returned recordset. Of curse, that connectionstring only works in ADO - if you want to use the .Net SQL Connection objects, you'll have to parse and reformat the connection string...
Glenn Adams Tiber Creek C> I am building COM add-ins to POS with VB.NET
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.