Updated Statement Error - Msg 121, Level 15, State 1

[T111]

Hi,
If I try a simple updated e.g.
update referrals set notes = ''

I get the following error
Msg 121, Level 15, State 1
The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

If I try a similar simple update on a different table within the same database it works fine.

Any ideas appreciated.
Thanks!

 

[bborissov]

From this message I understand that you use construction like this:

INSERT INTO SomeTable (Field list here)
SELECT (field list)
FROM ....

So your SELECT clause contains MORE fields in field list that your Field list in INSERT clause.


If you use this:

INSERT INTO SomeTable
SELECT (field list)
FROM ....

Then your SELECT clause contains MORE fields than fields you have in "SomeTable".

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[gmmastros]

there is probably a trigger on the referrals table that is causing this problem. I suggest you look there first.


-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[bborissov]

OOOOOOOOOOOOOOOOOOPS,
I totally missed the first part of the message.
Sorry T111.


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[hmckillop]

lol bborissov, though its possible this is the problem within the trigger George mentions.

Good spot George.

"I'm living so far beyond my income that we may almost be said to be living apart

 

[markros]

LOL Yes, definitely sounds like a trigger with the problem Boris describing.

 

[T111]

Yep that was it, a trigger for each update inserted all rows from deleted - "select * from deleted" and inserts into the history table. I recently added a new field and never added it to the history table, thanks guys!