Setting Unique

Ed Kleban Ed at Kleban.com
Sun Nov 20 00:59:01 CST 2005




On 11/20/05 12:51 AM, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

> On 11/20/05 8:43 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?  Does Valentina refuse to set the
unique flag?  Or does the flag get set but the items are not unique?  Or
does Valentina throw away any non-unique records?





More information about the Valentina mailing list