Base Object Method Prevents Adding Records

[Ruslan Zasukhin]

On 10/23/04 7:58 PM, "Thomas" <totoole at rocko.lab.csuchico.edu> wrote:

>>> The Base Object Method's Unique property is set to true.
>> 
>> As I have think.
>> 
>> Then you have 2 records with the same value.
>> Check this.
> 
> I checked this by setting the Base Object Method's Unique property to
> false, then importing the records, then setting the Unique property
> back to true. If there were duplicate records, wouldn't VAPP prevent
> the Unique property from being set back to true?
> 
> Thanks for your help.

Yes, it must refuse build unique index.

Also you can do such SQL after import

    SELECT f, count(f)
    FROM T 
    GROUP BY f
    ORDER BY f DESC

In this case if some value has duplicate it will be on top


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------