trying set set key as unique using sqlJoshua 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>AAlso note that in 4D v14 the field
will be set to Unique automatically and
this cannot be disabled.
Just to clarify, this happens for PRIMARY KEYs, not just any field :)
Technical Account Manager
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
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":
The keyword is UNIQUE.
Also note that in 4D v14 the field will be set to Unique automatically
and this cannot be disabled.
Reply to this message
Summary created 4/7/14 at 12:36PM by Intellex Corporation
Comments welcome at: firstname.lastname@example.org