Skip to Content
0
Former Member
Nov 01, 2005 at 04:25 PM

How to create a store procedure using SBO DIAPI

168 Views

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