Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleted unique index key
Message
De
04/04/2003 04:19:15
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/04/2003 06:20:59
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00773462
Message ID:
00773907
Vues:
14
>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.

Metin,
Behaviour is normal. You need to force an update on index (or reindex). To force update you could do something like :
update myTbale set key=key where key=1
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform