Seems a corrupted index. Only solution I see is reindexing it.


>Hi,
>
>I have a situation with an index error on INSERT INTO
>
>What I do is basically:
>

>IF !SEEK(tcKey,cALias,cTAG)
> INSERT INTO ...
>ELSE
> REPLACE ...
>ENDIF
>

>
>The code runs for decades
>
>Today I get an error 1884 on the INSERT INTO on site.
>
>My errorlog shows:
>
>cAlias is active area, I am on record 193 of total 194 and I am on EOF(), there is no SET ORDER on this table. Any ideas? Ah, a part of the key is the user ID so it realy shoud not create the same record by accident?
>
>Lutz