[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