error 0

[topazee]

Msg 242, Level 16, State 3, Line 1
The conversion of a char data type DATETIME returned a value out of range for date and time.
The statement has been terminated.

[topazee]

apparently it must be the date and time that is the problem

[abrasive]

Ya, it is something with the datetime. But that datetime is a valid datetime in the US. I think it may have something to do with how different countries write datetime.

See if this works:

SET DATEFORMAT YMD;
INSERT INTO PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');

[topazee]

always error

Msg 208, Level 16, State 1, Line 2
Nom d'objet 'PointLog' non valide

[topazee]

I think sql server management studio is in French for which I have the error written in French

[abrasive]

What if you explicitly tell it the location of PointLog, like this?

SET DATEFORMAT YMD;
INSERT INTO PS_GameData.dbo.PointLog(UseType,UserUID,CharID,UsePoint,ProductCode,UseDate)
VALUES(1,1,3,349,'AC_1000 75_1','2011-02-17 19:41:38');

[topazee]

here's what gives me

[abrasive]

It looked like that worked then, so probably your SQL Server expects dates to be in some format other than YMD.

You can try adding

SET DATEFORMAT YMD;

into your [dbo].[usp_Save_User_BuyPointItems_NCash] stored procedure and it should fix that varchar to datetime conversion error you were getting there.

[topazee]

I have tried to add it gave me this message


(1 row (s) affected)

[abrasive]

Originally Posted by topazee

I have tried to add it gave me this message


(1 row (s) affected)

When you updated your stored procedure? or when?

[topazee]

When I carried the new query code and then execute it gives me

(1 row (s) affected)

[topazee]

I just still do not buy item mall