Database Variant to Data.vi not working for the Date datatype with LV 8.2?

[weszink]

I'm moving a large body of LV database code from LV 7.1 to 8.2 and find that the Database Variant to Data.vi is not working correctly when used with the Date datatype. It works fine with 8.0, and the common Variant to Data works also. Am I missing something? Thanks in advance for any assistance. Wes

[Crystal]

Hi, Wes

I'd like a little more info about the problem.  Is the data in the table of date/time format and you are trying to convert the variant to a timestamp?  If so, then use the plain Variant To Data function.  If not, please give me more info on the datatypes both before they were written to the database, what they are in the table, and what LV data you want them to be.

Thanks

[weszink]

Thanks for the prompt reply Crystal,
The data is stored in an Oracle database using the DATE type. I'm querying many rows along with other columns and converting each of the values as necessary for each column with the 'Database Variant to Data' vi. Only conversion to Timestamp is no longer working as of version 8.2. I recognize that plain Variant to Data works but I have many (100's) of VIs to change if that is the only solution (not the end of the world). Most often the dates are originally generated in the database using PL/SQL procedures calling SYSDATE which look like: 5/1/2006 11:56:26 AM (in TOAD anyway) which I then need to read into LV as type Timestamp.
Regards, Wes.

[Crystal]

I'm sorry about the problem; it was reported, but unfortunately wasn't reported until after 8.2 released.  The only workaround in the meantime is to use the regular Variant To Data function. 

[weszink]

Thanks. Turns out to not be such a big deal... I started using the new (to me) search and replace tool and was up and running with my application (>500 vis) in no time.

[Crystal]

That's great news.  I meant to point that feature out, but forgot.  Good thing you found it and it worked well for you.

[rvc]

I too have the same problem.  Where is this search and replace tool you are referring to?

Bob

[Will.D]

It's in Edit->Find and Replace.