Problems with Database Connectivity Toolkit and LV 7.x

[Alan Hahn]

I am using ver1.0.1 version of the Database Connectivity Toolset along with LV 7.0 and 7.1.

The issue are the LV7 library time vi's. The LV7 versions of the "Get Date/Time in Seconds" now returns a time stamp instead of simply seconds as it use to. Since I need to connect to a Database Toolkit vi "DB Tools Format Datetime STr VI" that needs the old seconds value, I am stuck. I don't see a conversion for time stamp to seconds (although a conversion for the other direction exists). I suppose I can try and make this calulation, but it is a PIA.

Is there an update to the Database toolkit to handle LV 7?

Thanks

[Alan Hahn]

I guess I figured out a kludge. It turns out that the Database VI I was refering to can be easily modified to avoid the "seconds since 1904" issue. In this way I can get my time in.

[rolfk]

Alan Hahn wrote:

> I am using ver1.0.1 version of the Database Connectivity Toolset
> along with LV 7.0 and 7.1.<br><br>The issue are the LV7 library
> time vi's. The LV7 versions of the "Get Date/Time in Seconds" now
> returns a time stamp instead of simply seconds as it use to. Since
> I need to connect to a Database Toolkit vi "DB Tools Format Datetime STr VI"
> that needs the old seconds value, I am stuck. I don't see a conversion
> for time stamp to seconds (although a conversion for the other direction
> exists). I suppose I can try and make this calulation, but it is a PIA.

It is much simpler than that! Just use a Conversion node to convert the
timestamp to a DBL precision or uInt32 value. Those conversion nodes
know how to handle timestamps.

> Is there an update to the Database toolkit to handle LV 7?

If you load an older VI into LabVIEW 7.x the load operation should
automatically insert a conversion function. Since it apparently didn't
just do it yourself.

Rolf Kalbermatter