title says what version :) what does a length of 0 have to do with setting the field as a primary key?
On Mon, 17 Sep 2018 16:05:29 -0400, Charles Miller via 4D_Tech wrote: > Chip what version of 4D a UUID key has a lenght of 0 in at least v15 and > higher. > > > > On Mon, Sep 17, 2018 at 3:49 PM Chip Scheide via 4D_Tech < > [email protected]> wrote: > >> 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] >> ********************************************************************** > > > > -- > ----------------------------------------------------------------------------------------- > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D, Sybase & SQL Server connectivity > http://www.informed-solutions.com > ----------------------------------------------------------------------------------------- > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, disclosure, > printing, copying, storage, modification or the taking of any action in > reliance upon this transmission is strictly prohibited. Delivery of this > message to any person other than the intended recipient shall not > compromise or waive such confidentiality, privilege or exemption > from disclosure as to this communication. > ********************************************************************** > 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] > ********************************************************************** --------------- 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] **********************************************************************
