Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Error 1884
Message
From
05/04/2016 04:32:07
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Index Error 1884
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01634277
Message ID:
01634277
Views:
77
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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Next
Reply
Map
View

Click here to load this message in the networking platform