Creating Stored Procedures in VB

[JeffCarlin]

In a VB6 app, we have a module that updates the db when necessary with new/modified fields and tables. Basically, we use ADO and it works just fine. However, we will probably have to edit or add some SPs as well. How can this be done thru VB?

Thanks

 

[miq]

hi,
with proper access rights

go like this

create and open connection object then

cn.execute "create proc sp_newprocedure" _
"as select * from customers"

where cn is the connection object's name
sp_newprocedure is the stored procedure name


this is the simplest form. you can also create one with parameters.

also this can be done using recordset as well as command object


bye
miq

 

[JeffCarlin]

Great, thanks. Guess I treat it like any other "create" statement. Just execute the damned thing! Thanks again.