This is my stored procedure:
CREATE PROCEDURE [ScanTranSummary_Update]
(@ScanTranSummary_ID int,
@ScanTranSummary_CompanyCode char (2),
@ScanTranSummary_Location char(10),
@ScanTranSummary_ItemCode char(15),
@ScanTranSummary_PackQuantity char(6),
@ScanTranSummary_Quantity numeric(9),
@ScanTranSummary_Comments varchar(30),
@ScanTranSummary_TimeStamp char(18) )
AS
UPDATE
[tblScanTranSummary]
SET
ScanTranSummary_CompanyCode = @ScanTranSummary_CompanyCode,
ScanTranSummary_Location = @ScanTranSummary_Location,
ScanTranSummary_ItemCode = @ScanTranSummary_ItemCode,
ScanTranSummary_PackQuantity = @ScanTranSummary_PackQuantity,
ScanTranSummary_Quantity = @ScanTranSummary_Quantity,
ScanTranSummary_Comments= @ScanTranSummary_Comments,
ScanTranSummary_TimeStamp = @ScanTranSummary_TimeStamp
WHERE
ScanTranSummary_ID = @ScanTranSummary_ID
GO
This is my asp code:
strSQL = "EXEC ScanTranSummary_Update '" & Request.Form("ScanTranSummary_CompanyCode" & "', '" & Request.Form("ScanTranSummary_Location" & "', '" & Right(request("ScanTranSummary_ItemCode", 15) & "', '" & replace(Request.Form("ScanTranSummary_PackQuantity","C","" & "', '" & Request.Form("ScanTranSummary_Quantity" & "', '" & Request.Form("ScanTranSummary_Comments" & "', '" & Request.Form("ScanTranSummary_TimeStamp" & "'"
It won't update my table tblScanTranSummary
CREATE PROCEDURE [ScanTranSummary_Update]
(@ScanTranSummary_ID int,
@ScanTranSummary_CompanyCode char (2),
@ScanTranSummary_Location char(10),
@ScanTranSummary_ItemCode char(15),
@ScanTranSummary_PackQuantity char(6),
@ScanTranSummary_Quantity numeric(9),
@ScanTranSummary_Comments varchar(30),
@ScanTranSummary_TimeStamp char(18) )
AS
UPDATE
[tblScanTranSummary]
SET
ScanTranSummary_CompanyCode = @ScanTranSummary_CompanyCode,
ScanTranSummary_Location = @ScanTranSummary_Location,
ScanTranSummary_ItemCode = @ScanTranSummary_ItemCode,
ScanTranSummary_PackQuantity = @ScanTranSummary_PackQuantity,
ScanTranSummary_Quantity = @ScanTranSummary_Quantity,
ScanTranSummary_Comments= @ScanTranSummary_Comments,
ScanTranSummary_TimeStamp = @ScanTranSummary_TimeStamp
WHERE
ScanTranSummary_ID = @ScanTranSummary_ID
GO
This is my asp code:
strSQL = "EXEC ScanTranSummary_Update '" & Request.Form("ScanTranSummary_CompanyCode" & "', '" & Request.Form("ScanTranSummary_Location" & "', '" & Right(request("ScanTranSummary_ItemCode", 15) & "', '" & replace(Request.Form("ScanTranSummary_PackQuantity","C","" & "', '" & Request.Form("ScanTranSummary_Quantity" & "', '" & Request.Form("ScanTranSummary_Comments" & "', '" & Request.Form("ScanTranSummary_TimeStamp" & "'"
It won't update my table tblScanTranSummary