Running a (MS SQL 2000 SP3) Stored Procedure 0n ARS 5.1.2 patch 1484

[Menachem, Sharon]

**

I am trying to run a stored procedure from a filter that will check one form for status <> 3 and if it does not exist, will push a value to another form. 

 

After testing the stored procedure in the query analyzer I am now trying to run it through a filter with directsql. I see that the stored procedure runs and checks for the presence of status <> 3 but it does not continue and run the update to the second table. Any idea why not?

 

Here is the stored procedure:

ALTER   procedure RMD_usp_Check_CM_Approvals
(
 @cmNumber varchar(15)
)

 

as

 

--begin transaction
--commit
--rollback

 

if not exists
(select status from dbo.CM_Approvals
 where CM_Request_ID = @cmNumber
 and
 status <> 3)

 

update dbo.CM_Change_Management
set status = 2
where Request_ID = @cmNumber

 

Thanks very much,

Sharon

 

 

 

 

***********************************************************************************
This email message and any attachments thereto are intended only for use by the addressee(s) named above, and may contain legally privileged and/or confidential information. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the [EMAIL PROTECTED] and destroy the original message.
*********************************************************************************** __20060125_______________________This posting was submitted with HTML in it___