Hello,



I moved my translation strings from xml to a sql-table, using the DDT. No error so far, all went well. Also the translation works pretty well on every single form with the standard language. But the framework seems to miss a column called 'lng_eventid' when I change the language at runtime.



Any hint?



Thanks in advance and friendly greetings,



Ralph





Errormessage:



SqlException

Ungültiger Spaltenname 'lng_eventid'.



Source : .Net SqlClient Data Provider



Stack Trace:

bei System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

bei System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

bei System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

bei System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

bei System.Data.SqlClient.SqlDataReader.get_MetaData()

bei System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

bei System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

bei System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

bei System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

bei System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)

bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.SqlDataSourceItem.GetDataTable(DbCommand Command, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.Data.DbDataSourceItem.GetDataTable(QueryInformation QueryInfo, OnChangeEventHandler CallBack)

bei MicroFour.StrataFrame.UI.Localization.LoadLanguageTable(Boolean IgnoreExceptions)

bei MicroFour.StrataFrame.UI.Localization.SetActiveLanguageButtonText(Int32 LocaleID)

bei MicroFour.StrataFrame.UI.Localization.SetActiveLanguage(String ApplicationKey, Int32 LocaleID, String UserName)

bei MicroFour.StrataFrame.UI.LanguageSelectionDialog.cmdSelect_Click(Object sender, EventArgs e)

bei System.Windows.Forms.Control.OnClick(EventArgs e)

bei System.Windows.Forms.Button.OnClick(EventArgs e)

bei System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)

bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)

bei System.Windows.Forms.Control.WndProc(Message& m)

bei System.Windows.Forms.ButtonBase.WndProc(Message& m)

bei System.Windows.Forms.Button.WndProc(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)

bei System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)

bei System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

Hi Trent,



> Anytime that you see this message (regarding DBEProfile)

> it means that your StrataFrame connection is invalid.



You're absolutely right. But I didn't change the connection for sure. Really!



Beside that: Shouldn't that exeption be handled by framework, giving a descriptive message what went wrong?



OK, now I get another error message:



"Altering table 'MessageLanguages' failed."



It's because of ALTER TABLE seems to try to add a column with no defaults or disabled null values (I don't believe the german error message will tell you much more). And yes, the next error message is about a missing column named 'lng_EventId'.



What do I have to look for next?



Thank you very much and friendly greetings,



Ralph