trying set set key as unique using sql

Joshua Fletcher (4/4/14 11:13PM)
Richard Wright (4/7/14 8:41AM)


Joshua Fletcher (4/4/14 11:13 PM)

color><param>00000,0000,DDEE/param>
/color>

-----Original Message-----
color><param>00000,0000,DDEE/param>AAlso note that in 4D v14 the field
will be set to Unique automatically and
this cannot be disabled.
/color>
Just to clarify, this happens for PRIMARY KEYs, not just any field :)

Kind regards,

Josh

--
Josh Fletcher
Technical Account Manager
4D, Inc

Richard Wright (4/7/14 8:41 AM)

It's really incredible that after 4 versions 4D still does not have
this. It means you cannot add the Unique property to a new field for a
commercial application. That's because existing data files will have
no values in the new field, will therefore fail the uniqueness test
and 4D will turn off the Unique attribute when opening the data file.

color><param>00000,0000,DDEE/param>DDate: Fri, 4 Apr 2014 23:11:06
+0200
From: Joshua Fletcher <JFletcher@...

Unique is a property of a field, not a table. ?4D does not have an
ALTER COLUMN or ALTER FIELD command, so you cannot alter an existing
field (I think that is what you are trying to do).

The only thing you can do via ALTER TABLE is add a new field and
declare it to be unique in the "field definition":

http://doc.4d.com/4Dv14/help/Command/en/page18456.html

The keyword is UNIQUE.

Also note that in 4D v14 the field will be set to Unique automatically
and this cannot be disabled.

Kind regards,
/color>

Reply to this message

Summary created 4/7/14 at 12:36PM by Intellex Corporation

Comments welcome at: feedback@intellexcorp.com