[Babase] Conversion Errors - Deleting MEMBERS and CENSUS rows
Catherine Markham
babase@www.eco.princeton.edu
Fri, 02 Sep 2005 11:54:18 -0400
> Foxpro may have an SQL DELETE statement:
> DELETE FROM CENSUS WHERE SNAME = 'XXX' AND DATE >= "DDDDDDDD'
> AND DATE <= 'DDDDDDDD'
>
> It also has it's own DELETE statement which is something
> like:
> USE CENSUS
>
> DELETE FOR DATE >= 'DDDDDD' AND DATE <= 'DDDDD'
>
> PACK
>
> But you'll have to take a look at the manual to check
> what works. Whatever you do, do a backup first and run
> reinterp afterwords.
Thanks, Karl - this was a big help in pointing me in the right
direction. I found a menu in FoxPro that essentially writes the query
lines you gave me above (like "DELETE FOR DATE >= 'DDDDDD' AND DATE <=
'DDDDD'") to mark rows for deletion. Worked without a hitch in some
dummy tables - I'll keep playing a bit more though to be sure it can
handle that big changes to MEMBERS and CENSUS, but I think I'm on the
right track now.
Catherine