Update database record using Teststand schema.

[Winther]

Hi.

We have a testsequence which is running in Teststand 4.1.1 and we are currently working on saving the results from the test in a database.

Here is what I would like to do:

Save all data from the test in one tabel with coloumbs for serial number, a result for each step and a few other things. This would give us one line/record for each DUT.

At the beginning of the test use database steps to create a new record in the tabel and insert the serial number.

Use a database schema to update the record for the serialnumber which is being tested.

And can not get this to work. It only seems to be possible to create new records with the database schema and not update existing ones...

Is this correct, or have I just not found the right way to do it yet?

Best regards

Stephan.

[Norbert_B]

Stephan,

i do not understand why you chose that approach:

At the beginning of the test use database steps to create a new record in the tabel and insert the serial number.
Use a database schema to update the record for the serialnumber which is being tested.

If you take a look into the default database logging of TestStand, the data for the logging is collected during the execution of the  sequence.

When your sequence finished execution,  the process model creates the report/logs to database. In this process, TestStand creates a new record containing the results of the previous run.

It is not "planned" that this mechanism alters existing records.

So you can either choose a) to adopt the schema used during database logging to match your table or you can choose b) to write your own database logging. I'd choose option a)..... 

hope this helps,

Norbert 

[Winther]

Hi Norbert.

I did manage to implement an UPDATE command in the schema, but we have decided on a different approach which is closer to the default schema, which has made things more easy.

As you mentioned, we also wanted to avoid writing our own logging rutines.

Thanks for your reply.