public override CommandResultCode Execute(IExecutionContext context, CommandArguments args)
        {
            ISettingsHandler handler = Application as ISettingsHandler;
            if (handler == null) {
                Error.WriteLine("The application doesn't support settings.");
                return CommandResultCode.ExecutionFailed;
            }

            if (args.MoveNext())
                return CommandResultCode.SyntaxError;

            VarColumns[0].ResetWidth();
            VarColumns[1].ResetWidth();

            TableRenderer table = new TableRenderer(VarColumns, Out);
            table.EnableHeader = true;
            table.EnableFooter = true;
            foreach(KeyValuePair<string, string> setting in handler.Settings) {
                if (setting.Key == ApplicationSettings.SpecialLastCommand)
                    continue;

                ColumnValue[] row = new ColumnValue[4];
                row[0] = new ColumnValue(setting.Key);
                row[1] = new ColumnValue(setting.Value);
                table.AddRow(row);
            }

            table.CloseTable();
            Error.WriteLine();

            return CommandResultCode.Success;
        }

        public override CommandResultCode Execute(IExecutionContext context, CommandArguments args)
        {
            PropertyRegistry properties = Properties;
            if (properties == null) {
                Application.Error.WriteLine("the current context does not support properties.");
                return CommandResultCode.ExecutionFailed;
            }

            if (args.MoveNext()) {
                string name = args.Current;
                PropertyHolder holder = properties.GetProperty(name);
                if (holder == null)
                    return CommandResultCode.ExecutionFailed;

                PrintDescription(name, holder, Application.Error);
                return CommandResultCode.Success;
            }

            ProperiesColumns[0].ResetWidth();
            ProperiesColumns[1].ResetWidth();
            TableRenderer table = new TableRenderer(ProperiesColumns, Application.Out);
            foreach(KeyValuePair<string, PropertyHolder> entry in properties) {
                ColumnValue[] row = new ColumnValue[3];
                PropertyHolder holder = entry.Value;
                row[0] = new ColumnValue(entry.Key);
                row[1] = new ColumnValue(holder.Value);
                row[2] = new ColumnValue(holder.ShortDescription);
                table.AddRow(row);
            }
            table.CloseTable();
            return CommandResultCode.Success;
        }

        /// <summary>
        /// Recursive SetColumns method for data pinning. This populates the buffer and
        /// calls the inherited SetColumns method.
        /// </summary>
        /// <param name="sesid">The session to use.</param>
        /// <param name="tableid">
        /// The table to set the columns in. An update should be prepared.
        /// </param>
        /// <param name="columnValues">
        /// Column values to set.
        /// </param>
        /// <param name="nativeColumns">
        /// Structures to put the pinned data in.
        /// </param>
        /// <param name="i">Offset of this object in the array.</param>
        /// <returns>An error code.</returns>
        internal override unsafe int SetColumns(JET_SESID sesid, JET_TABLEID tableid, ColumnValue[] columnValues, NATIVE_SETCOLUMN* nativeColumns, int i)
        {
            if (null != this.Value)
            {
                fixed (void* buffer = this.Value)
                {
                    return this.SetColumns(
                        sesid, tableid, columnValues, nativeColumns, i, buffer, checked(this.Value.Length * sizeof(char)), true);
                }
            }

            return this.SetColumns(sesid, tableid, columnValues, nativeColumns, i, null, 0, false);
        }

 public override CommandResultCode Execute(IExecutionContext context, CommandArguments args)
 {
     Columns[0].ResetWidth();
     Columns[1].ResetWidth();
     TableRenderer table = new TableRenderer(Columns, Out);
     foreach(KeyValuePair<string, string> alias in Application.Commands.Aliases) {
         ColumnValue[] row = new ColumnValue[2];
         row[0] = new ColumnValue(alias.Key);
         row[1] = new ColumnValue(alias.Value);
         table.AddRow(row);
     }
     table.CloseTable();
     return CommandResultCode.Success;
 }

 public void Add(GeneralItem generalItem)
 {
     try {
         ColumnValue id = new ColumnValue () { Item1 = "id", Item2 = generalItem.Id.ToString() };
         ColumnValue name = new ColumnValue () { Item1 = "name", Item2 = generalItem.Name };
         ColumnValue iconId = new ColumnValue () { Item1 = "iconId", Item2 = generalItem.IconId.ToString() };
         List<ColumnValue> columns = new List<ColumnValue> ();
         columns.Add (id);
         columns.Add (name);
         columns.Add (iconId);
         this.Insert (columns);
     } catch (MySqlException ex) {
         switch (ex.Number) {
         case 0:
             throw new DatabaseException ("Cannot connect to server.  Contact administrator", ex);
         case 1045:
             throw new DatabaseException ("Invalid username/password, please try again", ex);
         default:
             throw new DatabaseException (ex.Message, ex);
         }
     }
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.Status field.
 /// </summary>
 public void SetStatusFieldValue(ColumnValue val)
 {
     this.SetValue(val, TableUtils.StatusColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwSite_.SiteZip field.
 /// </summary>
 public void SetSiteZipFieldValue(string val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.SiteZipColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.CreatedBy field.
 /// </summary>
 public void SetCreatedByFieldValue(string val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.CreatedByColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwPropSBondBudgetDetail_.Total field.
 /// </summary>
 public void SetTotalFieldValue(long val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.TotalColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwPropSBondBudgetDetail_.sub_category field.
 /// </summary>
 public void Setsub_categoryFieldValue(string val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.sub_categoryColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwPropSBondBudgetDetail_.ParentID field.
 /// </summary>
 public void SetParentIDFieldValue(long val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.ParentIDColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwPropSBondBudgetDetail_.ID field.
 /// </summary>
 public void SetID0FieldValue(long val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.ID0Column);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.ScopeDescription field.
 /// </summary>
 public void SetScopeDescriptionFieldValue(ColumnValue val)
 {
     this.SetValue(val, TableUtils.ScopeDescriptionColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.LastEditDate field.
 /// </summary>
 public void SetLastEditDateFieldValue(DateTime val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.LastEditDateColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.LastEditByID field.
 /// </summary>
 public void SetLastEditByIDFieldValue(System.Guid val)
 {
     ColumnValue cv = new ColumnValue(val, System.TypeCode.Object);
     this.SetValue(cv, TableUtils.LastEditByIDColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.LastEditBy field.
 /// </summary>
 public void SetLastEditByFieldValue(string val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.LastEditByColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.CreatedDate field.
 /// </summary>
 public void SetCreatedDateFieldValue(DateTime val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.CreatedDateColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwPropSBondBudgetDetail_.DeptID field.
 /// </summary>
 public void SetDeptIDFieldValue(string val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.DeptIDColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's Scope_.ScopeGlobal field.
 /// </summary>
 public void SetScopeGlobalFieldValue(ColumnValue val)
 {
     this.SetValue(val, TableUtils.ScopeGlobalColumn);
 }

 /// <summary>
 /// This is a convenience method that allows direct modification of the value of the record's VwSite_.SiteID field.
 /// </summary>
 public void SetSiteIDFieldValue(decimal val)
 {
     ColumnValue cv = new ColumnValue(val);
     this.SetValue(cv, TableUtils.SiteIDColumn);
 }