Hello.
The stored procedure posted below appears to run fine, but when I go back to look at the record, no changes have been made. Any suggestions as to what may be going wrong will be greatly appreciated.
Thanks in advance.
Donna
Code:
ALTER PROCEDURE dbo.spUpdateRecord
/*Created 9/20/2005 by DSpivey
Updates records in tblMoniesReceived*/
(
@RoutingID varchar (13),
@Type varchar (5),
@RecDate datetime,
@From varchar (50),
@AmtRecd money,
@AmtDue money,
@LateFee money,
@Total money,
@CheckDate datetime,
@CheckNo varchar (20),
@LicNo varchar (7),
@SSN varchar (9),
@NPN varchar (20),
@NAIC varchar (5),
@Source varchar (4),
@Receipt varchar (6),
@SubReceipt varchar (6),
@TA varchar (50),
@Copies varchar (5),
@CRNum varchar (20),
@Misc varchar (100),
@Comments varchar (1000),
@EditDate datetime
)
AS
Update tblMoniesReceived
Set @RoutingID = vchRoutingID, @Type = vchEntryType, @RecDate =
dtReceivedDate, @From = vchReceivedFrom, @AmtRecd =
mAmountReceived, @AmtDue = mAmountDue, @LateFee = mLateFee,
@Total = mTotalDue, @CheckDate = dtCheckDate, @CheckNo =
vchCheckNumber, @LicNo = vchLicenseNumber, @SSN = vchSSN, @NPN =
vchNPN, @NAIC = vchNAIC, @Source = vchSourceCode, @Receipt =
vchReceiptType, @SubReceipt = vchSubReceiptType, @TA =
vchTitleAgent, @Copies = vchNumCopies, @CRNum = vchCRNumber,
@Misc = vchMiscDescription, @Comments = vchComments, @EditDate =
dtDateEdited
where vchRoutingID = @RoutingID
SET NOCOUNT ON
RETURN
Stored procedure problem
