Skip to main content

Starting Focused Traverse Loops

Let's focus the start of the loop. Assume the variable substr holds the substring, and that the substring is not empty. Instead of setting ln to "", as we did in the previous example, we want to start the Traverse() loop based on the substring. But we can't simply set ln equal to the substring. What if substr equals a last name that's already in the database? Then the loop will start with the next name, even though there's an exact match for substr in the index, because of the initial Traverse().

To deal with this, use Traverse() once in reverse, to set ln equal to the lastname preceding substr. Then the loop can proceed and generate the names that follow substr. But we still need to focus the end of the loop so that we don't get “Swoboda”.

substr = "J"
ln = traverse(^PersonI("Name", substr), -1)
    ln = traverse(^PersonI("Name", ln) )
    if ln = "" then exit do
    println ln

The example code is in the loopstart subroutine of BAStraverse.BAS. Run it—passing the substr—using the Terminal.

SAMPLES>do loopstart^BAStraverse("J")
SAMPLES>do loopstart^BAStraverse("Jones")

FeedbackOpens in a new tab