LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Data Variant to TimeStamp problems in LV8.2

I have had a very odd problem with Database Variant to Data vi once upgrading to LV8.2
 
Basically when trying to convert a timestamp that is returned to me from an SQL select function, the timestamp cannot be converted with this vi. There are no issues with converting other numerical data.
 
I've attached two vi's which are basically the same. One is saved in LV 8.2 , one inLV8.0. The one in 8.0 if run in LV8.0 will work without issue. The LV8.2 version is now outputting the Error 91 with Possible reason - 'The data type of the variant is not compatible with the data type wired to the type input. The 8.0 version passes with flying colours. I've included a case structure on the 8.2 version, just to show that the numeric conversions run without issue in 8.2, it's just the timestamp that seems to cause a problem. Granted data variants with from SQL Selects will show up with the 'Data' header, but I couldn't save any of those values as 'default values' in this example vi, so I put things together this way. In the context of my actual programs (with actual SQL SELECTS), this error does not pop up, but the output of the Database Variant to Data vi simply outputs a 00:00:00 (null) timestamp. This is quite a problem - does anyone know the source? Does this happen on your computers, or is there some problem with my LV8.2 setup?
 
Thanks for your help
Download All
0 Kudos
Message 1 of 5
(3,824 Views)
Hello Peter,
 
This is a known issue in 8.2.  For the time being, the workaround is to use the normal "Variant to Data" for timestamps instead of the "Database Variant to Data" function.  I apologize for the inconvenience, this should be resolved in future versions of LabVIEW.
 
Regards,
Justin D
Message 2 of 5
(3,805 Views)
"This is a known issue in 8.2. "
 
Could you please share the CAR# ?
 
Ben
Retired Senior Automation Systems Architect with Data Science Automation LabVIEW Champion Knight of NI and Prepper LinkedIn Profile YouTube Channel
0 Kudos
Message 3 of 5
(3,799 Views)
Thank you for the post Justin.
 
That's quite an issue ... it did a number on a couple of my programs.
 
regards,
peter
 
0 Kudos
Message 4 of 5
(3,791 Views)

Sure thing Ben.  This is CAR#:40DGB184

Justin D

0 Kudos
Message 5 of 5
(3,781 Views)