VB and Generating SQL stored procedures

[Gin_bee]

Hi All

At the minute I have a VB6 programme that is generating and saving SQL stored procedures depending on the database and tables selected. The user selects the database they want to work with and then the tables they want to use. I have the programme running so I can insert and get fields but I can't figure out how to delete any fields or update old records. Its been suggested that I use SQL_DMO, but does anyone have any ideas as to how I can do this???? I'm using SQL Server 6.5 and am testing the generted procedures through this. Thanks in advance, Gin

[Ianpbaker]

Hi Gin_bee

When you say Deleting and updating old records, do you mean creating a stored procedure to do theese or using the recordset in vb to delete and append the records.

Ian

[Gin_bee]

Hi Ian

I'm generating a stored procedure to alter records

[Ianpbaker]

In that Case
Create a stired procedure with the diffterent variables that you need and use an UPdate table Set field1 = ... WHERE field1 == ...

Hope this helps
ian

[jjferreira]

Originally posted by Gin_bee
Hi All

At the minute I have a VB6 programme that is generating and saving SQL stored procedures depending on the database and tables selected. The user selects the database they want to work with and then the tables they want to use. I have the programme running so I can insert and get fields but I can't figure out how to delete any fields or update old records. Its been suggested that I use SQL_DMO, but does anyone have any ideas as to how I can do this???? I'm using SQL Server 6.5 and am testing the generted procedures through this. Thanks in advance, Gin

I there i'm tying to do the same has you a SP generator, done that the problem that i have is how to Save th SP into the SQL server...

P.S. Has i'm a bit old fashion i'm using DAO, sorry