[Babase] Conversion Errors - Deleting MEMBERS and CENSUS rows

Catherine Markham babase@www.eco.princeton.edu
Mon, 29 Aug 2005 14:55:06 -0400


Hi all,

Leah and I talked on Friday about some of the remaining conversion 
errors that deal with MEMBERS and CENSUS records.  Corrections for just 
one male (MCC, for example) involves deleting about 1,300 records from 
CENSUS alone (all have status = "E").  Since these rows have an old 
style status code, I think manual changes would also have to be made to 
MEMBERS.

Going through and marking individual rows for deletion has worked ok 
when I'm only correcting records for a few days up to a year or so 
(tedious, but got the job done).  I was hoping, though, that there was 
another method for cleaning up these remaining errors given the number 
of rows involved in each correction.

Karl, is there a better way to use FoxPro to delete records (I use the 
method of querying with "locate all for...", checking the row, marking 
it for deletion, and clicking "remove deleted records" button)?  Or 
would some sort of query or script possibly do the trick?

Maybe we could talk about it in a conference call later this week or 
whenever you all have a few minutes?

Thanks,
Catherine