[FIX]Character creation

[MAXTRAXv3]

um..if you have to change alter to create you have some realy big problems!

[RepublicOfAstra]

remove your old procedure and change alter to create

It's easier just to modify an existing spInsertChar with this though.

[nghiemyeuthao]

Server: Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON.

how to fix it?

[Nekroido]

FIXED.

Check the first post. =]

[nghiemyeuthao]

sorry...i can't fix..when run in query it error..."Server: Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON."
how to fix it?please help me..anyone..??

[Nekroido]

sorry...i can't fix..when run in query it error..."Server: Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON."
how to fix it?please help me..anyone..??

Delete that procedure, change to "CREATE PROCEDURE" and execute.
Maybe it'll help.

[nghiemyeuthao]

I has been delete produce..But when create produce
CREATE PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,'1,000',0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0)
END
GO

error...Server: Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON.
I don't understand???please help me...thank so much

[Nekroido]

I has been delete produce..But when create produce
CREATE PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;

DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID

DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,'1,000',0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0)
END
GO

error...Server: Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 22
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON.
I don't understand???please help me...thank so much

Use this, I guess.

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace ,@nHair,NULL,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,@cn t,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, NULL,getdate(),getdate(),0)
END
GO

[nghiemyeuthao]

thank it work..it easy :)..thank so much...

[Nekroido]

thank it work..it easy :)..thank so much...

lol, thanx for thanxing ;)

[kn95951135]

That Problem at

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace ,@nHair,NULL,0,'1,000',0,0,0,0,0,0,0,0,0,0,0,0,@cn t,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, NULL,getdate(),getdate(),0)

just change it to

INSERT INTO Character
VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace ,@nHair,NULL,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,@cn t,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, NULL,getdate(),getdate(),0)

it shuld work i think~:irvine:

[bepetemish]

hmmm, good job, works better then the solution i made xD

I do found a little bug,, normal grenades doesn't get eqquipt.

[etiolated]

credits to myself for coming up with the fix.

[Linear88]

At the line:

VALUES(@nAID,@szName,@cnt,1,@nSex,@nCostume,@nFace,@nHair,NULL,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,getdate(),getdate(),0)

I think I should remove ,getdate(),getdate(),0). But will it affect anything?

[cpk]

sorry i don't know where you put this code.

"Just open your database, than new SQL-editor window, copy-paste the code"

I am the database now where