Setting Unique

[Ruslan Zasukhin]

On 11/20/05 8:59 AM, "Ed Kleban" <Ed at Kleban.com> wrote:

>>> The Valentina Kernel manual states:
>>> 
>>> " If the flag Unique is changed at runtime and a table is not empty, then
>>> the index will be automatically rebuilt. This occurs because Valentina uses
>>> different formats for indexing unique and non unique fields. The unique
>>> index has more compact format because it does not need to store a count of
>>> records for each value (for unique field it is always 1). "
>>> 
>>> But what happens if you set the unique flag, and the table gets indexed, but
>>> it turns out the value really aren't unique?
>> 
>> Valentina refuse add such record.
> 
> I'm not sure what that means.  If you have already added all the records and
> then enable the unique flag, what happens?

Ah, I see

> Does Valentina refuse to set the unique flag?

YES. It will try to build index and fail,
And set OFF flag again

> Or does the flag get set but the items are not unique?

No, because this give us incorrect state.

Valentina try ALWAYS refuse incorrect states.

> Or does Valentina throw away any non-unique records?

Of course no. this is data of users!!!

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]