[Help]Usp_user_buypointitems error sql

[AxelMac]

 Spoiler

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


/****** Shoping Mall Fixed by sandolkakos Website: http://www.universalgamesonline.com.br ******/



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120)

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @UseType int
DECLARE @ReturnValue int

SET @UseType = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION


EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- ??? ??(Old, ?? UPDATE? ???? ????? ?? ???)
--UPDATE PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
-- GOTO ERROR
--END

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@ProductCode,@textDate)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

I have this in usp_user_buypointitems you could give me the correct one because I get the error: SQL STATE: 22007, NATIVE ERROR: 242 (0xF2)

I've read a post but I did not understand so I wrote there but no answer I hoped that here you can post the complete query

Thanks

[castor4878]

the initial post is the description of the same.

my detailled response explains how the issue was solved (with the @UseTime variable) but - due to a careless mistake - not used, the last SQL statement still uses @textDate, instead of the @UseTime variable.

Despite these details, you requested the full SQL proc. because ... apparently you are not able to replace one variable name by another. indeed this does not deserve an answer.
you have read the post ? actually ?!? so please re-read it, and read carefully the sentence above.

[AxelMac]

Originally Posted by castor4878

the initial post is the description of the same.

my detailled response explains how the issue was solved (with the @UseTime variable) but - due to a careless mistake - not used, the last SQL statement still uses @textDate, instead of the @UseTime variable.

Despite these details, you requested the full SQL proc. because ... apparently you are not able to replace one variable name by another. indeed this does not deserve an answer.
you have read the post ? actually ?!? so please re-read it, and read carefully the sentence above.

 Spoiler

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO


/****** Shoping Mall Fixed by sandolkakos Website: ******/



ALTER Proc [dbo].[usp_Save_User_BuyPointItems_NCash]

@UserUID int,
@CharID int,
@UsePoint int,
@ProductCode varchar(20),
@textDate varchar(30)

AS

DECLARE @UseTime datetime
set @UseTime=CONVERT(datetime, @textDate, 120)

SET NOCOUNT ON
SET XACT_ABORT ON

DECLARE @UseType int
DECLARE @ReturnValue int

SET @UseType = 1 -- ??

BEGIN DISTRIBUTED TRANSACTION


EXEC @ReturnValue = PS_UserData.dbo.usp_Update_UserPoint @UserUID, @UsePoint
IF ( @ReturnValue < 0 )
BEGIN
GOTO ERROR
END
-- ??? ??(Old, ?? UPDATE? ???? ????? ?? ???)
--UPDATE PS_UserData.dbo.Users_Master SET Point=Point-@UsePoint WHERE UserUID=@UserUID
--IF( @@ERROR<>0 OR @@ROWCOUNT=0)
--BEGIN
-- GOTO ERROR
--END

-- ??? ?? ??
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCo de,UseDate)
VALUES(@UseType,@UserUID,@CharID,@UsePoint,@Produc tCode,@UseTime)
IF( @@ERROR<>0)
BEGIN
GOTO ERROR
END

COMMIT TRAN
RETURN 1

ERROR:
ROLLBACK TRAN
RETURN -1


SET XACT_ABORT OFF
SET NOCOUNT OFF

is complet?