by martinh » Tue Jan 24, 2012 1:18 pm
Last post on this subject was 2005.
Now it is 2012 and Servoy 5.2 / 6.0
Is there already a solution for this situation?
I have a column in the database numeric(9, 4)
Default format is #,##0.00##
So it shows:
DB Value Format
5,0000 5,00
5,2500 5,25
5,2570 5,257
But in case of value 0, I would like to see an empty field (so blank when zero).
Otherwise I must allow NULL values in the database and let 0 be a NULL value, but that is not really what I prefer.
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2