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.
If it's just about customizing the value of a specific column in the list, you can use manwin 'CUSTOM_COLUMN'
Exemple:
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: 1881 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.