|
Null Values in Tables Overview: If you want to have a Table with input of numeric values and if you want to see / store / retrieve the difference between an empty cell (= ‘Null’) and a cell with a numeric value in it, which could be a Zero too, then this is for you! At first it seems to be a surprise: There’s a check box for each numeric Table Column: ‘Null if empty’. But if you want to test a column whether it’s Null or NOT Null and try to use a command like IF Table.MyNumericColumn..Null = True THEN <== SYNTAX ERROR ! you will think that you’re lost, because WinDev does not support the ..Null property for a Table column! The first secret is to use: IF Table.MyNumericColumn..displayedValue = “” THEN There are three examples, slightly different, which demonstrate all how to build such a Table. Mr Alexandre Leclerc gave the first project idea of how to solve the problem in a decent way! The idea was to brushcolor Table cells = Null in yellow and to have Table cells containing numerics (even a Zero!) with white background color. first example from Alexandre:http://www.windev.at/files/delmebigtime.rar next, I had been able to build a first full-blown working example for a Browsing Table:http://www.windev.at/files/WD14TableColsAndNullValues.zip further I built a very similar project for a Memory Tablehttp://www.windev.at/files/WD14TableColsAndNullValues3.zip Now, Alexandre added a code-reduced version of the same project:http://www.windev.at/files/WD14TableColsAndNullValues.rar
|
