NI TestStand

cancel
Showing results for 
Search instead for 
Did you mean: 

TestStand Database

Hello,
I would like to merge two tables UUT_RESULT and STEP_NUMERICLIMIT in one table to be able to reach all these data in the same line.
Is it possible to do that? and how to do it?
0 Kudos
Message 1 of 3
(2,855 Views)
Hi,

I'm not an expert but if I had to do it I would build a new schema (Database Options), and manually add the fields of one table to the other.

If there's a shorter way to do it, I would like to know too...

If you need help in doing it manually please state so.

Rafi
0 Kudos
Message 2 of 3
(2,821 Views)
It can certainly be done by adding additional columns in the UUT_RESULT table and creating your own schema but you might be better off creating a report (I'm assuming you're using Access) to present the data. What you want to do is frowned upon in database design because the data is not normalized. The original schemas in TestStand were like this with a UUT_RESULT table and a STEP_RESULT table. It was not normalized because there were columns always unfilled. For a pass/fail test step, the numeric limit and string limit columns were unfilled, for a numeric limit test step, the string limit and pass/fail columns were unfilled, etc. This results in inefficient writes, database size, searches, etc.
0 Kudos
Message 3 of 3
(2,810 Views)