Create Unique Index On Multiple Fields

Warren Kuhl warrenkuhl at gmail.com
Sun Nov 21 12:29:05 CST 2010


Ruslan,

I am on the 'create field or method' box.  I selected VarChar with a unique
flag.  I assume I click the Method radio button.  In the text box, what is
the syntax to combine two fields?

Warren

On Sun, Nov 21, 2010 at 12:07 PM, Warren Kuhl <warrenkuhl at gmail.com> wrote:

> Ruslan,
>
> Thanks....I will give this a try.  Thanks again for your help!
>
> Warren
>
>   On Sun, Nov 21, 2010 at 11:52 AM, Ruslan Zasukhin <
> ruslan_zasukhin at valentina-db.com> wrote:
>
>>  On 11/21/10 5:51 PM, "Warren Kuhl" <warrenkuhl at gmail.com> wrote:
>>
>> > I am trying to create a unique index on two fields (both fields together
>> have
>> > to be unique).  How do I do this in Valentina Studio.  I see how to make
>> each
>> > field unique...just not sure how to combine them.
>>
>> Hi Waren,
>>
>> You can solve this task in Valentina using very powerful concept
>>    Table Methods
>>
>> Also known as calculated field in FileMaker.
>>
>>
>> In WIKI exists description of all this ideas.
>>
>> In short, you create method in the same way as a field in table.
>> Then you define some Expression on that 2 fields.
>> Then mark METHOD field to be indexed and unique.
>>
>>
>> --
>> 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]
>>
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20101121/12448e05/attachment.htm>


More information about the Valentina mailing list