>I Create a Table with a field X that is a primary key.
>
>I Input a record with X=1
>Delete the record, set deleted is on
>
>When I Insert record with X=1 again, Foxpro show the error: Unique index violation.
>
>The initial solution of the problem is:
>- In the filter of the index input !deleted() but....
>
>
>Is the unique solution ?????
>
>
>Thank You,
>
>Mauricio Mesa.
The filter you suggests works. You may want to add an additional tag (with the expression DELETED()) to the table. This will Rushmore Optimize the filter.