row locking / repeatable read

Readers, A PowerBuilder program I am developing reads in data a state at a time. I am using repeatable read to prevent other users from accessing the state. The problem: the select statement always reads one more row than necessary and locks it, thus locking the next state in the table. One solution I found was to use rowid's to retrieve the rows for the state, but this requires retrieving all the row id's at a lesser isolation level before switching to repeatable read and using rowid's for retrieve of rows for state. Does anyone have a better solution? Drew.