>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