cursor/printAdultsInReverseSortedOrder.c

static RDM_RETCODE printAdultsInReverseSortedOrder (RDM_DB db)
{
RDM_RETCODE rc;
RDM_CURSOR adults = NULL;
 ADULT fAdult;
bool is_before_first;
 
 rc = rdm_dbGetRowsByKey (db, KEY_ADULT_ADULT_NAME, &adults);
if (rc == sOKAY)
 {
 rc = rdm_cursorMoveToLast (adults);
 }
 
 rc = rdm_cursorIsBeforeFirst (adults, &is_before_first);
while (rc == sOKAY && is_before_first == false)
 {
 rc = rdm_cursorReadRow (adults, &fAdult, sizeof (fAdult), NULL);
if (rc == sOKAY)
 {
 printf (
"Adult with id: %d and name: %s\n", fAdult.adult_id,
 fAdult.adult_name);
 rc = rdm_cursorMoveToPrevious (adults);
 }
if (rc == sENDOFCURSOR)
 rc = sOKAY;
if (rc == sOKAY)
 {
 rc = rdm_cursorIsBeforeFirst (adults, &is_before_first);
 }
 }
 
rdm_cursorFree (adults);
return rc;
}