cursor/initialize_get_find_TheKing.c

static RDM_ROWID_T kingRowId;
static RDM_ROWID_T kingsClubRowId;

static RDM_RETCODE initializeDBAForTheKingAndHisClub (RDM_DB db)
{
    RDM_RETCODE rc;
    RDM_CURSOR theKing = NULL;

    rc = rdm_dbGetRowsByKeyAtKey (
        db, KEY_ADULT_ADULT_NAME, "The King", 0, &theKing);
    if (rc == sOKAY)
    {
        rc = rdm_cursorGetRowId (theKing, &kingRowId);
        rc = rdm_cursorGetOwnerRowId (theKing, REF_MEMBERS, &kingsClubRowId);
    }
    rdm_cursorFree (theKing);

    return rc;
}

static RDM_RETCODE getTheKing (RDM_CURSOR *theKing, RDM_DB db)
{
    RDM_RETCODE rc;
    rc = rdm_dbGetRowsAtRowId (db, TABLE_ADULT, kingRowId, theKing);

    /* Create a singleton for it */
    if (rc == sOKAY)
    {
        rc = rdm_cursorGetSelf (*theKing, theKing);
    }
    return rc;
}

static RDM_RETCODE findTheKing (RDM_CURSOR adults)
{
    RDM_RETCODE rc;

    rc = rdm_cursorMoveToRowId (adults, kingRowId);

    return rc;
}