User121994837 posted
Dear .NET Pros:
In the Time Tracker program I liked the DAL that was used so I incorporated it into another project.
It appears that when Executing Stored Procs the return value always returns -1 even if you return a ZERO in the stored proc.
I wanted to find out if anyone else encounted this error and found the fix for it?
Below is the code I am running.
I find it a little strange that the Time Tracker does not use a return param from the stored proc for standard error
checking.
-------------------------------------------------
VB.NET Code - Return Value always - 1?
-------------------------------------------------
Dim intRtnVal As Integer = 0
Try
intRtnVal = SqlHelper2.ExecuteNonQuery(ConfigurationSettings.AppSettings("CnnStr"), _
"AUSP_Update_ItemMaster", _
wItem.ItemNumber, _
wItem.Category, _
wItem.SubCategory, _
wItem.DescriptionShort, _
wItem.DescriptionLong, _
wItem.ImageThumbnail, _
wItem.ImageLarge, _
wItem.Price, _
wItem.Status, _
0)
Catch ex As Exception
LblErrMsg.Text = ex.Message
Exit Sub
End Try
-------------------------------------------------------------------------
Stored Proc: Always Returns ZERO for a test, but the DAL gives -1
-------------------------------------------------------------------------
ALTER PROCEDURE AUSP_Update_ItemMaster
(
@ItemNumber varchar (20),
@MainCategory char (15),
@SubCategory char (2),
@DescriptionShort varchar (150),
@DescriptionLong varchar (1024),
@ImageThumbnail image,
@ImageLarge image,
@Price money,
@Status varchar (1),
@Error int OUTPUT
)
AS
SET NOCOUNT ON
/* See if the record exists */
Select ItemNumber from AHS_ItemMaster where ItemNumber = @ItemNumber
/* Insert New Record Else Update The Old Record */
if @@ROWCOUNT = 0
BEGIN
INSERT INTO AHS_ItemMaster
(ItemNumber, MainCategory, SubCategory, DescriptionShort, DescriptionLong, ImageThumbnail, ImageLarge, Price, Status)
VALUES (@ItemNumber, @MainCategory, @SubCategory, @DescriptionShort, @DescriptionLong, @ImageThumbnail, @ImageLarge, @Price, @Status)
END
Else
Begin
UPDATE AHS_ItemMaster
SET MainCategory = @MainCategory,
SubCategory=@SubCategory,
DescriptionShort=@DescriptionShort,
DescriptionLong=@DescriptionLong,
ImageThumbnail=@ImageThumbnail,
ImageLarge=@ImageLarge,
Price=@Price, Status=@Status
WHERE ItemNumber = @ItemNumber
END
/*select @Error = @@Error
Return @Error*/
return 0
-------------------------------------------------------------------------------------------------------------------
Any help would be appreciated.
Thank you,
Patrick
http://www.SURFThru.com
