sorry i forgot the formatting...
John,
You need to fill the "NOT DELETED()" clause in the filter box rather than adding it to your expression clause:
>
Field Type Expression Filter
myfield Primary myfield .NOT. DELETED()
>
You might want to add a regular index without the filter clause to speed up performance (rushmore)
Walter,
> I have a table that contains primary key. I get uniqueness error when I try to delete the record and create record with the same primary key. I was told that to have NOT DELETED() in primary key expression. However, i couldn't have the expression working in table designer.. can anybody help??
>My code in expression column
>
>
>Field Type Expression
>myfield Primary myfield .AND. .NOT. DELETED()
>
>
>
>VFP return expression is valid when I verify it. But I get another error message....
>
>Thank you