cursor/printOurCommonChildrenNames.c

static RDM_RETCODE printOurCommonChildrenNames (
RDM_CURSOR mother,
RDM_CURSOR father)
{
RDM_RETCODE rc;
char name[32];
RDM_CURSOR mothersChildren = NULL;
RDM_CURSOR fathersChildren = NULL;
 
    rc =  rdm_cursorGetMemberRows (
        mother, REF_MOTHERS_CHILDREN, 
        &mothersChildren);
if (rc == sOKAY)
    {
        rc = rdm_cursorGetMemberRows (
            father, REF_FATHERS_CHILDREN, &fathersChildren);
    }
 
if (rc == sOKAY)
    {
        rc = rdm_cursorMoveToNext (mothersChildren);
    }
/* Iterate over all mothers children */
                                                    
while (rc == sOKAY)
    {
        rc = rdm_cursorMoveToPosition (fathersChildren, mothersChildren);
if (rc == eNOTINCURSOR)
        {
            rc = sOKAY;
        }
else if (rc == sOKAY)
        {
            rc = rdm_cursorReadColumn (
                mothersChildren, COL_CHILD_CHILD_NAME, name, sizeof (name),
                NULL);
if (rc == sOKAY)
            {
                printf ("Common child: %s\n", name);
            }
        }
if (rc == sOKAY)
        {
            rc = rdm_cursorMoveToNext (mothersChildren);
        }
    }
if (rc == eNOTOWNER || rc == sENDOFCURSOR)
        rc = sOKAY;
 
rdm_cursorFree (mothersChildren);
rdm_cursorFree (fathersChildren);
 
return rc;
}