x++ while select "next" record

select salesTable;

while(salesTable.RecId != 0)

{

    do something;

    if (you need to skip)

    {

        next salesTable;

        continue;

    }

    do something else;

    next salesTable;

}