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


Author
Message
Marcia G Akins
Marcia G Akins
Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
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!

Marcia G Akins
Marcia G Akins
Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)Advanced StrataFrame User (698 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
Never mind - I figured it out. This one should already be familiar to me Tongue

The SP was not returning the column...

Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 7K
Glad you found it Smile
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search