StrataFrame Forum

Error when setting a BO on a ComboBoxEdit Control

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

By Bill Cunnien - 7/10/2008

I thought all was well with the update because yesterday I edited and built the application several times and even had two updates to deploy.  Today, while trying to set a BO on a combobox control (DevEx), I encountered the error below.  My gut tells me that this has something to do with my inability to open the solutions preferences window.  Perhaps a field was not updated in the SF database.  I will reinstall the framework and select the update database option.  I'll report back here shortly.

SqlException
  Invalid column name 'pref_ShowFieldsInAlphaOrder'.

Source     : .Net SqlClient Data Provider

Stack Trace:
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
   at MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)
   at MicroFour.StrataFrame.Data.DataLayer.GetDataTable(DbCommand Command, Boolean RegisterNotification)
   at MicroFour.StrataFrame.Business.BusinessLayer.FillDataTable(DbCommand CommandToExecute)
   at MicroFour.StrataFrame.Extensibility.BusinessObjects.DTEPreferencesBO.FillBySolutionName(String SolutionName)
   at MicroFour.StrataFrame.Extensibility.ExtensibilityBasics.GetMethodsOnTypeForListPopulation(String TypeFullName, IServiceProvider Provider, ListControl ComboToPopulate)
   at MicroFour.StrataFrame.Extensibility.ListPopulationEditorDialog.ᜁ(Object A_0, EventArgs A_1)
By Trent L. Taylor - 7/10/2008

This explains a lot...including your other problem on your other post.  You did not update your data structures, which have changed.  You need to reload the update and BE SURE to allow the StrataFrame structures to be updated.
By Bill Cunnien - 7/10/2008

Ok.  I ran the installation, again.  Now, I cannot open any form.  None of the DevEx controls can be initialized.  I updated and rebuilt the InheritedUI solution (again).  I then rebuilt my application.  Nothing.  All forms using any DevEx control are bombing.  I will stay at this, but if you have any ideas about how to correct this, I would appreciate it.
By Bill Cunnien - 7/10/2008

Using the tools supplied by DevEx I reconverted my application to the 8.1.6 version of the control suite.  Then, I rebuilt my application.  The forms are coming up, now.  And, the comboboxedit control now responds properly when assigning a BO as a datasource.  Awesome!  w00t  Now, back to work.  Smooooth
By Trent L. Taylor - 7/10/2008

Cool Cool