Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleted unique index key
Message
 
 
To
03/04/2003 06:20:59
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00773462
Message ID:
00773584
Views:
12
>i have a table with unique index. and some records
>
>key recno
>---- -----
>1 10
>1 11
>1 12
>2 13
>
>index on key tag key unique for !deleted()
>
>set orde to key, and listed:
>
>key recno
>---- -----
>1 10
>2 13
>
>if i delete record 10, record 11 or record 12 doesn't appear. but i created unique index with deleted() keyword. i think if i delete record 10 must appear another record has key 1.

That's the way unique index works. It's better not to use unique index at all.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform