Hello, Linda

I think you want CreateMessageManager() to return your subclass (MessageManager) instead of the Mere Mortals "base class" (mmMessageManager).

Hope that helps,
---J

>I am trying to use the multi-language features of MM.Net. Because of the limits in FoxPro, I am subclassing the message manager to change the name of the messagetextfield and overriding the GetMessageCmd to reflect the field name change. I also changed the factory code, as indicated in the help file. The program does not seem to be picking up my overrides. What am I missing? My code and the full error message are below.
>
>Thanks.
>
>Linda
>
>
>I created a new class called MessageManager with the following code:
>
>

>    /// <summary>
>    /// Summary description for MessageManager.
>    /// </summary>
>    public class MessageManager : mmMessageManager
>    {
>        /// <summary>
>        /// Constructor
>        /// </summary>
>        public MessageManager()
>        {
>            this.TableName = "Message";
>            this.PrimaryKey = "MessagePK";
>            this.DescriptionField = "MessageTxt";
>            this.MessageKeyField = "MessagePK";
>            this.MessageTextField = "MessageTxt";
>        }
>        /// <summary>
>        /// Returns a list of all messages for a specific language.
>        /// </summary>
>        /// <param name="languagePK"></param>
>        /// <returns></returns>
>        public override DataTable GetAllMessages(object languagePK)
>        {
>            mmDataAccessBase dao = this.GetDataAccessObject();
>            IDbDataParameter param =
>                dao.CreateParameter(dao.ParameterPrefixChar + "LanguagePk", languagePK);
>            param.DbType = this.LanguageFieldType;
>            DataSet dsMessages = this.GetDataSet("select MessageKey,MessageTxt,DialogText from " +
>                dao.TableNameDelimitBegin + this.TableName + dao.TableNameDelimitEnd
>                + " where " +
>                this.LanguageField + " = " + dao.ParameterPrefixChar + "LanguagePk", "TMessages", param);
>            if (dsMessages == null)
>                return null;
>
>            return dsMessages.Tables[0];
>        }
>
>    }
>

>
>I then changed the Factory.cs file to include:
>
>

>    public override mmMessageManager CreateMessageManager()
>    {
>        return new mmMessageManager();
>    }
>

>
>
>When I run the program I get an OLEDB error that it cannot find the field MessageText, which is the field name I have changed. The full stack trace of the error is:
>
>OleDbException (0x80004005): SQL: Column 'MESSAGETEXT' is not found.]
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr) +65
> System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) +181
> System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) +307
> System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) +77
> System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) +188
> System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) +122
> System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +29
> System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +183
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +308
> System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +152
> OakLeaf.MM.Main.Data.mmDataAccessOleDb.FillDataSet(DataSet ds, IDbDataAdapter dbAdapter, String tableName, Boolean clearOnFill) +445
> OakLeaf.MM.Main.Data.mmDataAccessOleDb.FillDataSet(DataSet ds, IDbCommand command, String tableName, Boolean clearOnFill) +111
> OakLeaf.MM.Main.Data.mmDataAccessOleDb.FillDataSet(DataSet ds, String command, String tableName, CommandType cmdType, IDbDataParameter[] dataParms, Boolean clearOnFill) +246
> OakLeaf.MM.Main.Business.mmBusinessObject.FillDataSet(DataSet ds, String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams) +379
> OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, CommandType cmdType, IDbDataParameter[] dataParams) +86
> OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, String databaseKey, IDbDataParameter[] dataParams) +94
> OakLeaf.MM.Main.Business.mmBusinessObject.GetDataSet(String command, String tableName, IDbDataParameter[] dataParams) +87
> OakLeaf.MM.Main.Globalization.mmMessageManager.GetAllMessages(Object languagePK) +617
> OakLeaf.MM.Main.Globalization.mmMessageManager.GetMessageCache(Object LanguagePk, Boolean ForceReload) +337
> OakLeaf.MM.Main.Globalization.mmMessageManager.GetMessageCache(Object LanguagePk) +56
> OakLeaf.MM.Main.Globalization.mmMessageManager.GetMessage(String messageKey, Object languagePK, Boolean returnMessageKeyIfNotFound) +181
> OakLeaf.MM.Main.Globalization.mmMessageManager.GetMessage(String messageKey, Object languagePK) +59
> OakLeaf.MM.Main.Web.UI.WebControls.mmLabel.LocalizeText(Object languagePK) +163
> OakLeaf.MM.Main.Web.UI.WebControls.mmLabel.LocalizeHandler(Object sender, mmLocalizeEventArgs e) +54
> OakLeaf.MM.Main.Web.UI.mmLocalizeDelegate.Invoke(Object sender, mmLocalizeEventArgs e) +0
> OakLeaf.MM.Main.Web.UI.mmBaseWebPage.OnLocalize(Object languagePK) +126
> OakLeaf.MM.Main.Web.UI.mmBaseWebPage.OnLoad(EventArgs e) +165
> System.Web.UI.Control.LoadRecursive() +74
> System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3036