SQL Inventory

So I trynna to add the 168 inventory, I saw in this topic @ [Only registered and activated users can see links. Click Here To Register...]

So I followed the SQL, and he/she said the "Do not use the Character_STR if you have another version of SQL so I compared the CHARACTER_STR and saw he/she just added the m_dwNameFont and the m_dwNameColor

After adding it @
ALTER proc [dbo].[CHARACTER_STR]
INSERT CHARACTER_TBL
SELECT m_chLoginAuthority = @om_chLoginAuthority,
UPDATE CHARACTER_TBL

After Executing it I had problem and it says

Quote:

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES

But I added them in CHARACTER_TBL
So where is the problem? Thanks for the helps!

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES

The error makes it pretty clear to be honest.

You're trying to insert more values than you have declared before.

[Only registered and activated users can see links. Click Here To Register...]

Make the amount of values you decalre you want to insert the same as the amount of values you are providing.

Quote:

Originally Posted by Naltalah There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES The error makes it pretty clear to be honest. You're trying to insert more values than you have declared before. [Only registered and activated users can see links. Click Here To Register...] Make the amount of values you decalre you want to insert the same as the amount of values you are providing.

I thought when you add them in design character tbl you already declared them in the same time. I just have low iq for sql thanks for the tip!