Hi, there
I like use SQL store procedure to update data from an Add-On, and I use SBO 2005 plus VB.Net. I meet a problem of which chance is properly to create SQL sp, it can create in two point, in time of instal or Add-On run time, I prefer Add-On run time, it can avoid get connect information when install, do you agree with these way?
If I create sp in Add-On run time, who can provid <b>a SBO DIAPI command that run create sp SQL string</b>. I have looked for it from SDK help, I only find the way to run sp is using recordset.command to excute sp.
but I can not find a object method to create sp.
Thanks for your help.
Lanjun