DevForce Community Forum : Update error http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Update error Tue, 12 May 2026 20:42:45 -700 Thu, 26 Sep 2013 06:27:52 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4378 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Update error : So dumb!There was a trigger on... http://www.ideablade.com/forum/forum_posts.asp?TID=4378&PID=16914#16914 Author: Togas
Subject: 4378
Posted: 26-Sep-2013 at 6:27am

So dumb!

There was a trigger on the table, it was using an asterisk.

 


]]> Thu, 26 Sep 2013 06:27:52 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4378&PID=16914#16914 Update error : I have this code which updates... http://www.ideablade.com/forum/forum_posts.asp?TID=4378&PID=16913#16913 Author: Togas
Subject: 4378
Posted: 26-Sep-2013 at 6:10am

I have this code which updates my entity any time a field changes:


    Private Sub SaveOrderFromTracking(field As String)
      field = field.Remove(0, 24)
      Dim oldVal As String = CStr(SelectedOrder.EntityAspect.GetValue(field, EntityVersion.Current))
      Dim newVal As String = CStr(SelectedOrder.EntityAspect.GetValue(field))
      Dim OrderId As String = SelectedOrder.EntityAspect.GetValue("OrderId")

      If oldVal = newVal Then Exit Sub

      _mgr.SaveChangesAsync({SelectedOrder}, Nothing, Sub(args)
                                                        If Not args.HasError Then
                                                          Dim newMessage As Message = New Message(OrderId, MsgType.FieldChange, field, oldVal, newVal)
                                                          Messages.Insert(0, newMessage)
                                                        Else
                                                          MessageBox.Show(args.Error.Message)
                                                        End If
                                                      End Sub)
    End Sub


This was working but I added a new field to the table, now I get this error.

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.

I ran a tracer on my SQL server and this is the TSQL being generated:

exec sp_executesql N'update [dbo].[Fastenal_Order]
set [Serial] = @0
where ([OrderId] = @1)
',N'@0 varchar(50),@1 int',@0='test23',@1=1447


Any thoughts on what's going on?
]]> Thu, 26 Sep 2013 06:10:12 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4378&PID=16913#16913