Implementing a schema and database questions

[Shako]

Hi

I am new to Teststand and im using version 2010 sp1.

I have looked and worked through the "Create a schema from Scratch" example.

But i still dont understand the full purpose of the schema and how it knows what data to get?

Why wouldnt you just place the data into a database yourself?

Like how could i for example take a response text from a message popup and place it into the database using the schema?

If i create a stament in a schema to get the limits from a numeric limit test is it possible to place some numeric limit test into one table and some numeric limit test for another table?

[TaylorG]

Hi Shako,

I hope you are doing well today!  While you can create your own schema from scratch, as is shown in the Creating a TestStand Database Schema from Scratch example, there are built-in schemas that ship with TestStand.  The best practice to have custom schemas is to begin with the schema that is shipped with TestStand and modify it to fit your tables you have in your database.  A TestStand schema contains the statements, table definitions, and TestStand expressions that instruct TestStand how to log results to a database.  

Along with the example you have mentioned, there is an example of database logging that ships with TestStand.  If you go to 

Start»All Programs»National Instruments»TestStand 2010»Examples

and then open the Database folder, there is an example project where you can see how to use the Database Steps in TestStand to communicate with and log results to a SQL database.  Also, please refer to Chapter 6 of the TestStand Reference Manual for more information regarding logging results to a database.  This can be found by going to 

Start»All Programs»National Instruments»TestStand 2010»Documentation»Manuals»NI TestStand Reference Manual

on your machine.  I hope this helps, Shako.  Have a great day!