Dataset problem

I have a table object that uses an SQL query to create a 1 row by 13 column dataset. I then use a numeric text filed to display the individual data value. I’m having a problem that when my dataset has a null value, the matching numeric text display doesn’t show a null or a zero but appears to have the last valid data.


You can try putting a check for None.
if (value=None, 0, toInt(value))

or you can modify the SQL query to return 0 instead of NULL

An easy way to ensure that you don’t return a NULL value from a SQL query is by using COALESCE in your query. Here is an example:

If column1 is NULL then 0 is returned.