06-11-2009 01:24 AM
Hi,
I am new to Database Toolset.
In my case the test report consists of the test details with Pass/Fail result in the Table format. I am able to store the report in a word file using Report generation toolkit. How to store the same report in the Database (MS Access) along with date and time of test conduct.
Please guide me,
Here is the sample test report format which will be stored in the MS word file.
Regards,
Rajashekar
06-11-2009 02:24 AM
06-11-2009 02:33 AM
06-11-2009 03:37 AM
06-11-2009 04:03 AM
Thanks,
06-11-2009 05:59 AM
You'll need at least two tables in your database; one that stores overall test results (with date and time of test) and another with the data from the table in your sample doc. There needs to be a key in the first table relating the data in the second table. When you get to the point of writing your data you write the summary info into the first table and keep the key to write into the second table along with your data.
You can get by without using SQL because the DB toolkit DB Tools Insert Data.vi will handle that for you. That said, I always use SQL!
Take a look at a few of the database examples that ship with LabVIEW.
06-15-2009 06:31 AM
Yes what ever tou said is wright, I need to create two table one is for consolidated report and the other detailed report.
But the thing is that i will be having around 20 tests for a unit with unit serial no. I have to store both the consolidated result and detailed result for each unit along with date and time stamp. Each test has different format (colums), how to make this?
Thanks and Regards,
Rajashekar
06-15-2009 06:39 AM
06-15-2009 07:58 AM
I am having LabVIEW devlopment system with Report generation and Database toolkit. Is the NI test stand really required? Cant i use only the Database toolkit?
Thanks and Regards,
Rajashekar
06-15-2009 08:12 AM
Rajashekar wrote:Is the NI test stand really required? Cant i use only the Database toolkit?
Yes; I'm sorry for being unclear. The only reason I mentioned TestStand was that it writes tests to a database based on the test type (see attachment).
Your task isn't trivial, but it won't be too complicated if you understand relational databases.