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 - 2004-11-18 : 08:31:38
|
| Oscar writes "I want to update a column in table A after information has been added to table B. I have the UPDATE query working, but I do not know how to call the query from code. In other words, I have a web page that updates table A, then when that page closes, I need a line of code that calls the UPDATE query into action. In MS Access I just call the query, but in SQL the query is stored in the Query Analyzer. Do I use the same procedure as in MS Access, i.e.: set objCommand = Server.CreateObject("ADODB.Command") set rsRebriefUpdate = Server.CreateObject("ADODB.Recordset") objCommand.ActiveConnection = strConnect objCommand.CommandText = "qryRebriefUpdatetblEmployee" objCommand.CommandType = adCmdStoredProc set rsRebriefUpdate = objCommand.Execute" |
|
|
dsdeming
479 Posts |
Posted - 2004-11-18 : 09:11:21
|
| Did you create the query in QA using the CREATE PROCEDURE syntax, or is it just a script in a QA window?Dennis |
 |
|
|
|
|
|
Query Activation - SQL Server 2000