Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key
Message
From
31/12/1998 03:56:21
 
 
To
31/12/1998 03:52:28
Jocylyn Sy
Freelance Programmer
Cebu, Philippines
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00171828
Message ID:
00171829
Views:
28
>I've noticed that although a record has been deleted,
>when you enter the item again, Foxpro still complains
>that the item already exists when item is primarily key.
>
>I was wondering if there is a way to allow the
>re-entry of a primary key item that has deleted.

Jocylyn,

So long as a record with a primary key is in the table, whether or not it is marked as deleted, you may not enter a new record with the same key. If you do you will get a "uniqueness violated" error.

Is there any reason you cannot recall the deleted record and reuse it?

regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.com

No trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.
Previous
Reply
Map
View

Click here to load this message in the networking platform