Unanswered question

Is it possible to initialize a counter variables with SQL variable's value. It is required to avoid duplicate SSNs?

I am using a counter variable to generate SSN numbers in my script. Currently,whenever I run the test, this counter variable needs to be initialized with the maximum SSN number in database. In this way I can avoid generating duplicate SSNs during the test, My application throes validation exception If I try to create a customer with same SSN twice which would result in script gets failed. My SQL variable will return the maximum SSN value from database and I want to initialize the counter variable with this value. Please let me know, any suggestion.

Deva R.
Deva R.

Deva R.

Level
0
31 / 100
points

No answers