extract results from database

[gumby659]

I want to be able to re-create a test report from the results database and do statistical analysis on the results of specific tests. Are there any querries or other database tools that have already been developed for this?

[SarahM]

Hi Gumby,

As far I know there aren't any tools developed specifically for this kind of a task. However depending on the environment you're using there will probably be tools developed for easily retrieving information from databases.

In TestStand we have SQL step types that allow you to easily retrieve data from databases. There are two examples that ship with TestStand I would suggest looking at in addition to the help for these step types.
C:\Program Files\National Instruments\TestStand 3.1\Examples\Database
(This path will vary depending on the version of TestStand and your installation directory.)

If you're using LabVIEW or LabWindows/CVI we have special tools developed to simplify communicating to databases.

c.vp?cid=6429〈=US>LabVIEW Database Connectivity Toolkit

NI LabWindows/CVI Enterprise Connectivity Toolset

There are also lots of examples available by searching our website.

If you're using another environment there are probably tools available as well, I just don't know enough to recommend any.

I hope this helps!

Regards,

Sarah Miracle
National Instruments