General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Maybe a good reason to go to VFP 6 then, Wim, since it will execute there.
Good luck,
Jim N
>This Will not execute (syntax error). Tried it allready.
>Thnx anyway...
>
>
>>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
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only