Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using primary index
Message
From
01/12/1998 13:46:45
 
 
To
01/12/1998 13:35:44
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00162863
Message ID:
00162866
Views:
21
>Hi, i've been using a table with a primary index key. After a while, i`m getting a message of uniqueness of index has been violated.
>
>Is it because i could have a bad coding or is it a problem with VfoxPro5.0 ?

The message indicates that you're trying to add records with the same primary key as an existing record in the file, or alter the primary key of an existing record in the file to be the same as another primary key.

If you're using APPEND BLANK to add records to the table, you'll get this error when two BLANK records are being added to the table at the same time, whether by the same person or by two different people. Using INSERT rather than APPEND BLANK...REPLACE avoids this problem neatly.

>
>Thanks for your attention.
>
>One day, i'll be good (hopefully).
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform