Thanks Bill,
Indeed, it maybe a long lasting error; this database was created with R:Base
4.5 ++ long ago.
Do you think using the Delete command is more safe than using RBDEFINE?
Ben
-----Oorspronkelijk bericht-----
Van: Bill Downall <[EMAIL PROTECTED]>
Aan: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: vrijdag 20 april 2001 13:44
Onderwerp: Re: Autonumber problem
>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
>
>
>
>
