StrataFrame Forum

I am getting an error saying that a column does not belong to a view

http://forum.strataframe.net/Topic20283.aspx

By Marcia G Akins - 10/23/2008

So what the heck is going on here? The column proposal_pk is in the view and I can see it in the business object mapper.

Here is the stack trace:

ArgumentException
  Column 'proposal_pk' does not belong to table vw_notelist.

Source     : System.Data

Stack Trace:
   at System.Data.DataRow.GetDataColumn(String columnName)
   at System.Data.DataRow.get_Item(String columnName)
   at Trinity.BusinessObjects.boViewNoteLog.get_proposal_pk() in F:\Trinity_new\Trinity\BusinessObjects\boViewNoteLog.Designer.cs:line 824
   at Trinity.Forms.Notes.GetCurrentNote(Int32 tnNote_PK, Boolean tlPutInEditMode) in F:\Trinity_new\Trinity\Forms\Notes.cs:line 109
   at Trinity.Forms.Prospects.EditNote(Boolean tlPutInEditMode) in F:\Trinity_new\Trinity\Forms\Prospects.cs:line 630
   at Trinity.Forms.Prospects.grdNoteLog_DoubleClick(Object sender, EventArgs e) in F:\Trinity_new\Trinity\Forms\Prospects.cs:line 652
   at System.Windows.Forms.Control.OnDoubleClick(EventArgs e)
   at System.Windows.Forms.DataGridView.OnDoubleClick(EventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.DataGridView.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

What's even stranger is that this was all working 10 minutes ago!

By Marcia G Akins - 10/23/2008

Never mind - I figured it out. This one should already be familiar to me Tongue

The SP was not returning the column...

By Trent L. Taylor - 10/23/2008

Glad you found it Smile