set of several fields : Unique ?

[Ruslan Zasukhin]

On 9/11/04 4:36 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

> 
>>> e.g. I have a database (fields: street, zip, city) for 3 000 000 of
>>> the
>>> streets.
>>> 
>>> All these streets must be unique.
>>> But Unique in every city. ( it can have identical street names but in
>>> different cities there)
>> 
>> To set UNIQUE flag on combination of several fields
>>     you need simply to use BaseObject Method.
>> 
> 
> yes, but I shall have a big file of index (name+zip+city X 3 000 000).

Then what you ask about ?

Yes, you have big db, and you will have big index.
There is no other way.


-- 
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
-------------------------------------------------------------