Skip to main content

Adding column to table without changing the uniface data model

  • June 20, 2023
  • 2 replies
  • 1 view
J
Forum|alt.badge.img

Hi,

what do you think about adding a column to table in SQL without updating the uniface model? The column will contain data from existing columns in the table (based on sql expression) and will be not used in Uniface components. In SQL it is called computed column. Do you think it is OK to use the new column in table without any connection to Uniface? Are there any risks with this solution?

BR,

Jozef



------------------------------
Jozef Prokopovic
Uniface Community Edition Shared Account
US
------------------------------

    2 replies

    Iain Sharp
    Forum|alt.badge.img+5
    • Iain Sharp
    • Inspiring
    • June 20, 2023

    Hi,

    what do you think about adding a column to table in SQL without updating the uniface model? The column will contain data from existing columns in the table (based on sql expression) and will be not used in Uniface components. In SQL it is called computed column. Do you think it is OK to use the new column in table without any connection to Uniface? Are there any risks with this solution?

    BR,

    Jozef



    ------------------------------
    Jozef Prokopovic
    Uniface Community Edition Shared Account
    US
    ------------------------------
    We do this with no ill effects already.
    The downside is that any data retrieval on this column has to be either outside uniface or via the sql or sql/data command.

    Regards,
    Iain
    Iain Sharp : Head of Technical Services, Jonas Metals Software
    J
    Forum|alt.badge.img
    • Jozef Prokopovic
    • Author
    • Participating Frequently
    • June 21, 2023
    We do this with no ill effects already.
    The downside is that any data retrieval on this column has to be either outside uniface or via the sql or sql/data command.

    Regards,
    Iain

    Thanks for the answer, yes that is exactly what we would like to achieve. We will consume the data of this column outside of Uniface with SQL or other option.  



    ------------------------------
    Jozef Prokopovic
    Uniface Community Edition Shared Account
    US
    ------------------------------

    Recent badge winners

    Explore all badges
    Terms & ConditionsAccessibility statement