Write Values into Database

[Tumbler]

Hello,

i have a small problem. I want to insert some values from FileGlobals after a passed device test into a database.

I will use the TestStand SQL Statments. But it doesn't work.

I attached my exaple. Every time i get an Syntax Error in Insert Into.

Thnaks a lot

Tumbler

[Tumbler]

Hello,

now i can wrote values into database. But i have another problem.

In my Database i have made a correlation with UUT_Result and Step_Result. I want that all data i wrote to the same time in correlation.

I have insert a new example.

[nikolair]

Hi,

did you try to use the TesStand Datalogging options? You can enable the database logging on Configure => Database Options and then design your own database tables. NI brings different standard schemes, one can create a copy and modify it to log UUT results and Step results only.

The database logging will be managed from the TestStand process model itself and one dosn't need to use the database steps for each  single command.

The results one needs to log in the database can be user defined when one manages the property object "result list" in TestStand, for example by creating own steptypes.

In your case, it seems that you don't need to care about that because the data you're logging is part of the standard result collection of TestStand.

The following links might be helpful for further information to that:

http://digital.ni.com/public.nsf/allkb/F5ADBC61222343B586256CE00055E6D6?OpenDocument

http://digital.ni.com/public.nsf/allkb/D30EC9BBA0D740C286256C760049DABD?OpenDocument

regards,

Nikolai