Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-05 : 08:16:12
|
| Doug Holland writes "In my application I create a stored procedure to create views of a specified table.the stored procedure is created without any apparent problems, but when I loop through the table names, it only creates the first view.I am using the ado Proc.command process and passing the table name to the stored procedure.The function is called from a sub so that the parameters are re-initiallzed with each call, and the stored procedure or Visual Basic function never returns any errors, but only the first view is created...Any help on this subject will be greatly appreciated..Thanx in advance.Doug Holland" |
|
|
drymchaser
Aged Yak Warrior
552 Posts |
Posted - 2003-12-05 : 08:57:53
|
| We need to see the code to be able to give you more assistance. |
 |
|
|
|
|
|
Stored Procedure only runs once.