Skip to main content

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

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
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
------------------------------
Terms & ConditionsAccessibility statement