Do not understand this error


Author
Message
ckelsoe
ckelsoe
StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)
Group: Forum Members
Posts: 13, Visits: 97
I am getting the error below that I do not understand. The field ID does exist as a PrimaryKey in an Access database.

System.ArgumentException was unhandled by user code
  Message="Column 'ID' does not belong to table tblCertHolders."
  Source="System.Data"
  StackTrace:
       at System.Data.DataRow.GetDataColumn(String columnName)
       at System.Data.DataRow.get_Item(String columnName)
       at FMLCertHolderConversion.boCertHolders.get_ID() in D:\FMLCertHolderConversion\FMLCertHolderConversion\boCertHolders.Designer.vb:line 239
       at FMLCertHolderConversion.boCertHolders.Field_ID_Descriptor.GetValue(Object component) in D:\FMLCertHolderConversion\FMLCertHolderConversion\boCertHolders.Designer.vb:line 735
       at MicroFour.StrataFrame.Business.BusinessLayer.get_Item(String FieldName)
       at MicroFour.StrataFrame.UI.Windows.Forms.ListView.CreateListViewItem(BusinessLayer BusinessObject)
       at MicroFour.StrataFrame.UI.Windows.Forms.ListView.PopulateListView(Object[] Parameters)
       at MicroFour.StrataFrame.UI.Windows.Forms.ListView.InitializeObject()
       at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.InitializeFormLoadObjects()
       at MicroFour.StrataFrame.UI.Windows.Forms.BaseForm.BaseForm_Load(Object sender, EventArgs e)
       at System.EventHandler.Invoke(Object sender, EventArgs e)
       at System.Windows.Forms.Form.OnLoad(EventArgs e)
       at System.Windows.Forms.Form.OnCreateControl()
       at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
       at System.Windows.Forms.Control.CreateControl()
       at System.Windows.Forms.Control.WmShowWindow(Message& m)
       at System.Windows.Forms.Control.WndProc(Message& m)
       at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
       at System.Windows.Forms.ContainerControl.WndProc(Message& m)
       at System.Windows.Forms.Form.WmShowWindow(Message& m)
       at System.Windows.Forms.Form.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)

Here is the code that causes the error.

<Browsable(False), _
BusinessFieldDisplayInEditor(), _
Description(
"ID"), _
DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)> _
Public Property [ID]() As System.Int32
Get
Dim loRow As DataRow
loRow =
Me.CurrentRow
If loRow.RowState = DataRowState.Deleted Then
Return CType(loRow.Item("ID", DataRowVersion.Original), System.Int32)
Else
Return CType(loRow.Item("ID"), System.Int32)
End If
End Get
Set(ByVal value As System.Int32)
Me.CurrentRow.Item("ID") = value
End Set

End Property



Charles R Kelsoe
ckelsoe
ckelsoe
StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)
Group: Forum Members
Posts: 13, Visits: 97
Sinced there has not been a response,  I will add that this was strataframe generated code.

Charles R Kelsoe
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
Charles,

Is there any data in the business object when you reference this field?  If there is not any data in the business object you can get this error message.  If you call NewRow() before attempting to place data in the field do you get this same error?

ckelsoe
ckelsoe
StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)StrataFrame Beginner (33 reputation)
Group: Forum Members
Posts: 13, Visits: 97
This happens on the initial compile. I am not trying to add data or anything. I am just trying to compile the project for the first time.

Charles R Kelsoe
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
Charles,

The framework is trying to populate a ListView that you've dropped onto your form.  You have the PopulationDataSourceSettings configured to display the ID column in one of the ListView's columns.  The ID column has not been pulled from SQL Server, so it appears that whatever query you're executing within the PopulationDataSourceSettings, is not executing an SQL query that pulls in the ID column.  Check the "Method to Execute" and make sure that it fills the business object with a select statement that includes column "ID".

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