Monday, 10 August 2009

New Edit Table Styles




Did you know that OpenInsight release 9.1 includes a form and stored procedure called TEST_NEW_EDITTABLE_STYLES. This test form provides examples for programming the new edit table styles and the associated stored procedure has all of the code exposed for developers to review how things are done.

Some of the examples included in the test form include:

  1. Options button within a cell that calls the options event for the edit table control.
  2. Using vertical styles.
  3. Forcing uppercase in rows.
  4. Multiline processing.
  5. Including drop down controls in cells, columns and rows.
  6. Including drop down edit controls in columns.
  7. Using a Multi-Line Header.
  8. How to change the test in the row buttons (all buttons and also only some buttons).

The test form can be run from the Application Manager or the Form Designer in the normal way. The accompanying stored procedure can be viewed using the System Editor by opening the TEST_NEW_ET_STYLES stored procedure, it too can be opened from the Application Manager window.

3 comments:

  1. Very useful example. Question ? A new feature was added in 9.1 as default to turn cell yellow when selected. Why does this not work in this example?

    ReplyDelete
  2. The Edit Table Focus Cell Settings are used to set the cell colours across the application and I suspect that those have not been defined in your application, or are over written by the example form.

    The Edit Table Focus Cell Settings can be set from within the Application Environment Settings in the Database Manager. They are found on the Window/Form settings tab.

    I guess that I ought to blog this new feature – watch this space. In the meantime, please let me know if you want to see an example of this in my new 9.1 examples application, along with several other interesting 9.x features.

    ReplyDelete
  3. Thanks, I forgot they need to be set in Db Mgr.

    ReplyDelete