On Fri, 20 Apr 2001 11:37:07 +0200, Ben Weeda wrote:
>Question1: Can I delete two of the three entries without causing
further
>trouble?
Ben,
In some older versions of R:Base, multiple autonum rows could be
created. It may have been because the old ones would not be removed
on an UNLOAD ALL; database rebuild. Or it may have been that
successive AUTONUMs on the same table and column without a
DELETE in between created the extra. I don't think these things
happen anymore in current versions.
One safe way I found to clean these up was to use the DELETE option:
AUTONUM column IN table DELETE
SELECT MAX (column) INTO vNext FROM table
SET VAR vNext = (.vNext + 1)
AUTONUM column IN table USING .vNext, 1
Bill
