Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary index with filter; can this be programmed???
Message
From
17/08/1999 09:56:29
 
 
To
17/08/1999 08:47:32
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254466
Message ID:
00254501
Views:
20
Try ALTER TABLE TableName ADD PRIMARY KEY uPrimaryKeyExpression TAG PrimaryKeyTag FOR NOT Deleted()

HTH

>Is it possible to do something like alter table or so, to create a primary index With a filter clause???
>
>I know this can be done with candidate indexes, but I don't know how to switch a candidate to primary.
>
>The filter clause is : !deleted()
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform