If the field is set as an Alpha field then you could activate the "Auto UUID"
option with this code:
Begin SQL
ALTER TABLE Table_1 MODIFY uidField ENABLE AUTO_GENERATE;
End SQL
You could also set that field to the primary key using this code:
Begin SQL
ALTER TABLE Table_1 ADD PRIMARY KEY( uidField);
End SQL
However I don't think you can change the field type from TEXT to ALPHA via SQL.
Since it sounds like the data was never populated, why not just drop the
existing field like this:
Begin SQL
ALTER TABLE Table_1 DROP journal_key;
End SQL
...then re-add it back as described here:
http://kb.4d.com/assetid=76991
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
