Hi,
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
I am not the most powerful man in this world.
I am not the worst man in this world either.
I just as same as all of you.
I still need to learn from my mistakes...