Jump to content
Software FX Community

skip null in dataset?


User (Legacy)

Recommended Posts

Is there a way to skip over null values in a recordset to avoid having

breaks in the plot line? For example:

29-JUN-06 07:07:17 2048 2512 2639

29-JUN-06 07:07:28 2048 2512 2640

29-JUN-06 07:07:38 2047 2511 2641

29-JUN-06 07:07:49 2046 2511

29-JUN-06 07:07:52 2641

29-JUN-06 07:08:02 2046 2511 2642

29-JUN-06 07:08:13 2046 2511 2641

29-JUN-06 07:08:23 2048 2512 2640

I know I can just dump the recordset into an array and build the each series

by iterating through that but I would like to avoid that overhead if I can.

Link to comment
Share on other sites

Is there a way to skip over null values in a recordset to avoid having

breaks in the plot line? For example:

29-JUN-06 07:07:17 2048 2512 2639

29-JUN-06 07:07:28 2048 2512 2640

29-JUN-06 07:07:38 2047 2511 2641

29-JUN-06 07:07:49 2046 2511

29-JUN-06 07:07:52 2641

29-JUN-06 07:08:02 2046 2511 2642

29-JUN-06 07:08:13 2046 2511 2641

29-JUN-06 07:08:23 2048 2512 2640

I know I can just dump the recordset into an array and build the each series

by iterating through that but I would like to avoid that overhead if I can.

Link to comment
Share on other sites

  • 1 month later...

You would need to separate each series from the others so that they have 

independent X-Values.

The following KB article explains how to achieve this:

Q6001007. How can I plot charts with an unequal number of points per

series?

http://support.softwarefx.com/ShowArticleSep.aspx?Type=KB&Product=CfxNet62&Source=http://support.softwarefx.com/kb/600/1/007.htm

--

Francisco Padron

www.chartfx.com

"Bert" <rocky.rhoads@wgint.com> wrote in message

news:loiznl3mGHA.2336@webserver3.softwarefx.com...

> Is there a way to skip over null values in a recordset to avoid having

> breaks in the plot line? For example:

>

> 29-JUN-06 07:07:17 2048 2512 2639

> 29-JUN-06 07:07:28 2048 2512 2640

> 29-JUN-06 07:07:38 2047 2511 2641

> 29-JUN-06 07:07:49 2046 2511

> 29-JUN-06 07:07:52 2641

> 29-JUN-06 07:08:02 2046 2511 2642

> 29-JUN-06 07:08:13 2046 2511 2641

> 29-JUN-06 07:08:23 2048 2512 2640

>

>

> I know I can just dump the recordset into an array and build the each

> series

> by iterating through that but I would like to avoid that overhead if I

> can.

>

>

Link to comment
Share on other sites

You would need to separate each series from the others so that they have 

independent X-Values.

The following KB article explains how to achieve this:

Q6001007. How can I plot charts with an unequal number of points per

series?

http://support.softwarefx.com/ShowArticleSep.aspx?Type=KB&Product=CfxNet62&Source=http://support.softwarefx.com/kb/600/1/007.htm

--

Francisco Padron

www.chartfx.com

"Bert" <rocky.rhoads@wgint.com> wrote in message

news:loiznl3mGHA.2336@webserver3.softwarefx.com...

> Is there a way to skip over null values in a recordset to avoid having

> breaks in the plot line? For example:

>

> 29-JUN-06 07:07:17 2048 2512 2639

> 29-JUN-06 07:07:28 2048 2512 2640

> 29-JUN-06 07:07:38 2047 2511 2641

> 29-JUN-06 07:07:49 2046 2511

> 29-JUN-06 07:07:52 2641

> 29-JUN-06 07:08:02 2046 2511 2642

> 29-JUN-06 07:08:13 2046 2511 2641

> 29-JUN-06 07:08:23 2048 2512 2640

>

>

> I know I can just dump the recordset into an array and build the each

> series

> by iterating through that but I would like to avoid that overhead if I

> can.

>

>

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...