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;
}