TS Database Operation

[MosRo]

Hi,

I would like to know if there is an efficient way to read (or map) parameters from
MS Access database into TS for UUT test.

At the moment my sequence reads one record each time in loop iteration.

(The total number of records founded in the DB table is known parameter).

To retrieve valves from the DB The same SQL Query is used each time in the same Sequence.

My aim is to read and retrieve the whole table at one time like MS Access retrieves it.

In other way to get all the relevant data at one time into TS without performing the

Loop iteration, my current TS version is 4.01.

An example DB is attached to this message.

Thanks.

[Jervin Justin]

Hi MosRo,

The easiest way I can think of is to use property loaders to load the limits, etc from the database.

First, you would have to export your limits to the database in a way that the property loader can read them in automatically later.

Then when your program loads, you can use a property loader in the setup steps to automatically load the limits from the database.

TestStand Help: Property Loader