Welcome!
This community is for professionals and enthusiasts of the Genio platform.
Share your questions and challenges, and help your partners!
'NA' when the field is numeric
Sometimes it happens that I don't have data, so I want that a numeric field gets 'NA' instead of 0.
In fact, 0 (zero) have meaning in my table, so it must be 'NA' in those cases.
This default in numeric fields are defined on constraints in your SGBD (eg. SQL Server).
The default constraint will put 0 on database, without that will be save with "NULL".
So for do that you will need to remove the constraint or redefine that with the value that you need.
Note: Always when you rebuilding the database schema or install a new version of your software the constraint will be rebuilt and you will have to remove that.
Hey Maksym,
I used your code but never changed. Did I make something wrong?
In addition to missing the parameter.
You don't need to put '// USE /[MANUAL ...]/' in manwin's body. But if you want to, is missing a line break before 'column.Expression ...' otherwise all code will be commented.
And change please the 'p.ValExistenc' to your field 'p.ValPrazo'.
Keep Informed
About the Community
Question tools
Stats
Asked: 21/11/2019 上午11:52 |
Seen: 1831 times |
Last updated: 29/11/2019 下午12:10 |
You are missing the parameters, in Maksym's example the parameter is: MENU_341_ARTIG_EXISTENC.
Your's can be different though, you need to check in the source file what's correct parameter.