Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary key
Message
From
13/05/2004 07:00:59
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00903491
Message ID:
00903518
Views:
8
Solution 1:
filter the primary key
(but this removes the index from the directory of the usable indices from the optimization)
ALTER TABLE ... ADD PRIMARY KEY ProductID FOR !DELETED() TAG PK_Index
Soluzion 2:
replace the deleted record primary key with a not valid value.
you can define a deleted trigger for do this.
Previous
Reply
Map
View

Click here to load this message in the networking platform