Error when setting a BO on a ComboBoxEdit Control

Bill Cunnien — Thu, 10 Jul 2008 09:43:57 GMT

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)

RE: Error when setting a BO on a ComboBoxEdit Control

Trent L. Taylor — Thu, 10 Jul 2008 09:43:57 GMT

Cool :cool:

RE: Error when setting a BO on a ComboBoxEdit Control

Bill Cunnien — Thu, 10 Jul 2008 09:39:27 GMT

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:

RE: Error when setting a BO on a ComboBoxEdit Control

Bill Cunnien — Thu, 10 Jul 2008 09:26:39 GMT

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.

RE: Error when setting a BO on a ComboBoxEdit Control

Trent L. Taylor — Thu, 10 Jul 2008 08:30:19 GMT

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.

StrataFrame Forum » StrataFrame Application Framework - V1 » Issues » Error when setting a BO on a ComboBoxEdit Control

Error when setting a BO on a ComboBoxEdit Control

RE: Error when setting a BO on a ComboBoxEdit Control

RE: Error when setting a BO on a ComboBoxEdit Control

RE: Error when setting a BO on a ComboBoxEdit Control

RE: Error when setting a BO on a ComboBoxEdit Control