SQL Inventory

[nicksss03]

So I trynna to add the 168 inventory, I saw in this topic @

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

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!

[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.



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

[nicksss03]

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.



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!