check if data already exist in database

[yamasce]

Hi,

After I have obtained UUT serial no., I want to check if it is already recorded in the database before the test proceed further. I need to loop through the records and feed each of them into LabVIEW module to store them as array and perform the comparison. This works well, at least for small database. My question is, what are the more efficient and faster ways of doing this if the database is huge?

Thanks

[Dennis_Knutson]

You just need a WHERE clause in your SELECT statement. This is SQL basics and really not TestStand specific.

[RaviShrigiri]

As already replied you can use a simple SQL statement to fetch it.

Just to add further there is a built in database step type which you can use to get the data (refer database example).

Hope this helps.

Ravi