Is it possible not to load null-values into DBChart?
Posted: Thu Jul 12, 2007 10:30 am
I have a table connected with DBChart. I have many signals that are draw on the same chart. These signals have different sampling rates, which means that for one signal I may have 100 samples, while for another I may have only 10. Yet they all live in the same table.
When the signals are loaded into the DBChart, the null values are also included in the series. Having nulls in the series complicates many calculations I make, therefore I would like to get rid of them.
Currently I use a loop to remove all the nulls from the series, using IsNull(i), and Delete(i). However, for large datasets (200K+) and many nulls, this is sometimes taking like 6 minutes, which really is too much.
Is it possible to ask DBChart simply to ignore the nulls, and dont load them into the series?
Regards,
Sigurdur
When the signals are loaded into the DBChart, the null values are also included in the series. Having nulls in the series complicates many calculations I make, therefore I would like to get rid of them.
Currently I use a loop to remove all the nulls from the series, using IsNull(i), and Delete(i). However, for large datasets (200K+) and many nulls, this is sometimes taking like 6 minutes, which really is too much.
Is it possible to ask DBChart simply to ignore the nulls, and dont load them into the series?
Regards,
Sigurdur