database question

[jarrett]

I have an index created in a table called (agency; candidate key). In the
program if I enter a agency which is numeric 6, Then delete. If I try to
enter another agency with the previous number I get a unique index violation
error. Even if I reindex and validate the database it won't go away. This
is being stored in the DBC I assume. If I open the table the agency does
not exist and the index does not find it. Anyone ever had this problem?

[Tamar E. Granor]

On 14 Jan 2002 19:13:38 GMT, "jarrett" <cooley222@excite.com> wrote:

>
> I have an index created in a table called (agency; candidate key). In the
>program if I enter a agency which is numeric 6, Then delete. If I try to
>enter another agency with the previous number I get a unique index violation
>error. Even if I reindex and validate the database it won't go away. This
>is being stored in the DBC I assume. If I open the table the agency does
>not exist and the index does not find it. Anyone ever had this problem?

Keep in mind that deletion in VFP is a two-step process. You mark the
records as deleted, but they're still in the table until you pack.
It's a lot like the Windows recycle bin, where the file is still on
your computer until you empty the bin.

The reason you're not seeing the record is that you must be operating
with DELETED set ON, which hides deleted records.

Tamar