Have an app in VB6 against Oracle. Want to iterate through a number of records and insert sequential alphanumeric values into database. For example, "Sample X" is the most recent sample in the db, and has location value of "BOX1000", position "A5".
When I add a new sample, I will pull out those two location values and give the new sample values that represent that location + 1 ("BOX1000","A6"), etc. When I reach "A12", the next location will be ("BOX1000", "B1"), up to "G12", then ("BOX1001","A1"). You should see the pattern.
I can program this as a "Select Case", simply capturing the variables and assigning a new value based on that, but would require an extensive list(have simplified it for this question). Is there a way in VB6 to create some kind of function, or custom list, that would "know" what value to assign based on the current value, or must I specifically lay it all out in code?