last record

[Jessica]

I'm trying to do a simple loop to find a matching record.

I want to loop through a d/b to find a matching record but I don't know how to exit if I'm at the last record.

How do I do this?

"If this is last record, exit loop"

THanks

[SteveB]

Use 'Exit Loop If' script command (immediately below the Loop command).

[BobWeaver]

Also, you can select the "exit after last" option in your "Go to record/request [next]" script step.