Sql sql;
S_SOMETABLE rec;
sql*Select(rec).From(SOMETABLE).Where(key==1);
if (sql.Fetch(rec)
{
  //do something with the first record in rec
}

while (sql.Fetch(rec)
{
  //do something with all records
}