Searching a Database using TestStand

[Neilelph]

Hi.
I would like to search a database for UUT Serial Numbers, so that I avoid duplicates. At the moment I am looping through the appropriate table and comparing my existing serial number with that of each record retrieved. Unfortunately, if a match is not found, it reaches the end of the database and throws an error:

Record not found.


Error getting data from column "Device_ID". Native error code -2146825267 0x800a0bcd
ADODB.Field:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

My question is, how to I check if the record I have retrieved is the last one in the database using TestStand?

I have attached the database sequence of my code for clarity.

Regards.
Neil.

[Dennis_Knutson]

You're making it way too complicated. Do a query like "SELECT DEVICE_DETAILS.ID FROM DEVICE_DETAILS WHERE DEVICE_DETAILS.ID = " RunState.Root.Locals.UUT.SerialNumber. Then Locals.NumRecords will contain the number of records that have that serial number. Anything greater than 0 will mean a duplicate. No looping is required and you don't actually have to retrieve any data.

[Neilelph]

Don't know if you'll read this, but thanks for the feedback.

I'm a total novice at TestStand and SQL/Databases, so it's very much appreciated!

Cheers.