trying to set a new field in a new table as primary key $SQl_Command:="ALTER TABLE [Anmlprot_File_Link] ADD PRIMARY KEY (Journal_Key)"
Begin SQL Execute Immediate : $Sql_Command end SQL table : [Anmlprot_File_Link] exists Field : Journal_Key exists as a field in [Anmlprot_File_Link] Journal_Key defined as: String 255, Unique, Indexed, Null, UUID, Auto UUID When I run the above sql line of code - the field is NOT set to be a primary key. As an aside, is setting a field as primary key an option (check box) in the Field properties dialog? Thanks Chip --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
