>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.

9 thoughts on “>New Edit Table Styles

  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?

  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.

      1. anne

        Hello Sir Martyn. I already tried the limit command and this is my code,
        itemcount = Get_Property(“.TABLE_ITEM”, “LIMIT”)
        call msg(@window, itemcount)

        the TABLE_ITEM is the name of my edit table.
        i tried to call the itemcount to see if there is a value to return but nothing happen.

  3. I tried the code below on one of my edit tables in OI 9.4 and I get a value returned. Which version of OpenInsight are you using and do you have a WORKS subscription. I think that you might need some technical help that goes beyond my basic knowledge.

    That said, have you tried you code but putting @Window: before the table name, as in the OI syntax example?

    Also, if you drop a debug after your call msg statement, what value is in the debugger window for itemcount?

    declare function get_property
    value1 = Get_Property(@window: “.EDT_RECIPIENTS”, “LIMIT”)
    Call Set_Property (@Window : “.BUTTON_18”, “TEXT”, value1)
    RETURN 0

  4. Actually, I just changed my code to the following and I get back the numeric 5, being the number of columns in the table, so putting in the @Window: seems to work.

    I suspect that you are looking for the number of rows. The value of value1 in my code is 5.56, where I have 5 columns and 56 rows in the table. You will therefore need to do something to return the second of the two values. That one is beyond my limited knowledge but it should be a trivial thing for whoever supports you through OI WORKS to help.

    If you don’t have WORKS support, please drop me an email via http://www.revsoft.co.uk. Our office email is displayed in the top right corner of the website.


    declare function get_property

    value1 = Get_Property(@window: “.EDT_RECIPIENTS”, “LIMIT”)

    Call Set_Property (@Window : “.BUTTON_18”, “TEXT”, value1)
    call msg(@window, value1)

    RETURN 0

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s