rtree/deleteZipcode.c

static RDM_RETCODE deleteZipCode (RDM_DB db)
{
RDM_RETCODE rc = sOKAY;
RDM_CURSOR cursor = NULL;
    POINTSOFINTEREST_CITY_KEY keyVal = {{0}};
RDM_RANGE_KEY range = {0};
 
/* Set the key value for the lookup */
                                                    
    strcpy (keyVal.city, "Nampa");
 
/* Set key lookup information */
                                                    
    range.value = &keyVal;
    range.range = RDM_RANGE_OPEN;
    range.bytesIn = sizeof (POINTSOFINTEREST_CITY_KEY);
    range.numKeyCols = 1;
 
/* Start an update transaction */
                                                    
    rc = rdm_dbStartUpdate (db, RDM_LOCK_ALL, 0, NULL, 0, NULL);
if (rc == sOKAY)
    {
/* Get a range cursor based on the city key */
                                                    
        rc = rdm_dbGetRowsByKeyInRangeKeyRange (
            db, KEY_POINTSOFINTEREST_CITY, &range, &range, &cursor);
if (rc == sOKAY)
        {
/* Move to the first (should be only) row in the cursor */
                                                    
            rc = rdm_cursorMoveToFirst (cursor);
while (rc == sOKAY)
            {
/* Delete the row */
                                                    
                rc = rdm_cursorDeleteRow (cursor);
 
if (rc == sOKAY)
                {
                    rc = rdm_cursorMoveToNext (cursor);
                }
            }
 
/* We expect sENDOFCURSOR when we break out of the loop */
                                                    
if (rc == sENDOFCURSOR)
            {
                rc = sOKAY;
            }
 
/* Free the cursor */
                                                    
            (void) rdm_cursorFree (cursor);
        }
 
if (rc == sOKAY)
        {
/* Commit the successful transaction */
                                                    
            rc = rdm_dbEnd (db);
        }
else
                                                    
        {
/* Rollback the failed transaction */
                                                    
            (void) rdm_dbEndRollback (db);
        }
    }
 
return rc;
}