RE: Display 'N/A' for null values

[Software FX]

When a NULL value is read from a database we replace it with a predefined value (CHART_HIDDEN) that should make chart "hide" the marker.

Regards,

Juan Cegarra

Software FX, Inc.

support.softwarefx.com

-----Original Message-----

From: Chris Peterson [mailto:cpeterson@blueflameinc.com]

Posted At: Wednesday, September 27, 2000 3:30 PM

Posted To: Client

Conversation: Display 'N/A' for null values

Subject: Re: Display 'N/A' for null values

You may be asking' Why not just return 'N/A' from your query?

ChartFX is expecting a numeric, and gives an error if the result is a

character.

"Chris Peterson" <cpeterson@blueflameinc.com> wrote in message

news:kwiJKaLKAHA.2224@sfxserver.softwarefx.com...

> I want to display 'N/A' on a chart when I get a null value from the

server.

> I DON'T want to display zero, because that has a different meaning, that

> there is data, and its zero. Null means we don't have any data.

>

> How can I do this in ChartFX?

>

> Thanks for any help.

>

>