[V4MD] unique between two fields

[info at vallemediatime.com]

Hi Ivan,

I've not better understand, sorry
my code for create table and fields is a bit different:

eg
Discipline = gDb.createTable("Discipline ")
Discipline .createStringField("Discipline_Name",  36)
Discipline .createStringField("Discipline_Year",  9)  -- (eg  2005-2006)

I've tried to modify this with your useful help but I get error...
Paolo


----- Original Message -----
From: "Ivan Smahin" <IvanSmahin at public.kherson.ua>
To: "Valentina Beta" <valentina-beta at lists.macserve.net>
Sent: Saturday, November 05, 2005 1:30 PM
Subject: Re[2]: [V4MD] unique between two fields


> Hello info,
>
> Saturday, November 5, 2005, 2:24:26 PM, you wrote:
>
>
>
> ivc> eg
> ivc> F1 Discipline F2 Year
> ivc>
> ivc> Music | 2005   --ok
> ivc> Music | 2006   --ok
> ivc> Math | 2005 --  ok
> ivc> Music | 2005   wrong
>
>
> create table t1 ( f1 string(20), f2 long, m1 string(30) method('f1 || f2')
unique )
>
> insert into t1 (f1,f2) values ( 'Music', 2005)
> insert into t1 (f1,f2) values ( 'Music', 2006)
> insert into t1 (f1,f2) values ( 'Music', 2005)  -- Exception!
>
>
>
> --
> Best regards,
>  Ivan                            mailto:IvanSmahin at public.kherson.ua
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>