[V4MD] unique between two fields

[info at vallemediatime.com]

----- Original Message -----
From: <info at vallemediatime.com>
To: "Valentina Beta" <valentina-beta at lists.macserve.net>
Sent: Sunday, November 06, 2005 10:55 AM
Subject: Re: Re[6]: [V4MD] unique between two fields


> Hi Ruslan
>
> ----- Original Message -----
> From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
> To: <valentina-beta at lists.macserve.net>
> Sent: Sunday, November 06, 2005 10:10 AM
> Subject: Re: Re[6]: [V4MD] unique between two fields
>
>
> > On 11/6/05 10:44 AM, "info at vallemediatime.com" <info at vallemediatime.com>
> > wrote:
> >
> > > Hi Ivan,
> > >
> > > and if I have one (or more) UShortField together stringFields what is
> the
> > > correct way or value thay I must use?
> > >
> > > in eg look at  36 + ?
> > >
> > > Discipline = gDb.createTable("Discipline ")
> > > Discipline .createStringField("Discipline_Name",  36)
> > > Discipline .createUShortField("Discipline_Teacher_ID")
> > > Discipline .createUShortField("Discipline_Room_ID")
> > >
> > > Discipline .createStringField("Discipline_NameTeacherRoom",  36+?  ,
> > > [#fUnique],
> > > "Discipline_Name || Discipline_Teacher_ID ||  Discipline_Room_ID" )
> >
> > You ask about maximal length ?
> >
> > Ushort this is 65535 maximum, so 5 chars.
> >
> > Actually guys all is not so simple,
> > Concatenation of numbers can have ambiguity
> >
> >     1 + 11  == 111
> >
> >     11 + 1  ==  111
> >
> > I think it needs add spaces between numbers.
>
> I agree,
> I will try with space and add 1 char for every space, right?
> eg
> Discipline = gDb.createTable("Discipline ")
> Discipline .createStringField("Discipline_Name",  36)
> Discipline .createUShortField("Discipline_Teacher_ID")  -- add 5 chars + 1
> for space
> Discipline .createUShortField("Discipline_Room_ID")    -- add 5 chars + 1
> for space
> Discipline .createStringField("Discipline_NameTeacherRoom",  36+12  ,
> [#fUnique], "Discipline_Name |' '| Discipline_Teacher_ID |' '|
> Discipline_Room_ID" )
>
> Paolo

I've tested now and the concatenations with space not works
eg
 |' '|  not works
||     works

can you check this?
Thanks Paolo