Over the last two years, I have been working on a utility to enter test data from a hand written test report into Access 2000 using Labview 6.1 with the Database Toolkit. Now I have been asked to add an edit feature to the utility. The idea is to display the data after a search by serial number and modify a couple of fields and then update the database table.
Several of the entries have infinity recorded in numeric fields. This was not a problem when I used the parameterized insert into query (DB Tools Insert Data.vi). I can add and read the Inf values. The database tables show 1.#Inf.
However, when I try to use a SQL command including a where statement, I get a data type mismatch error.
I would like any suggestions for modifying the update either in the formatting of the SQL statement or using a parameterized query.
Thanks,
Sandra Wells
