Hello, Just in case …
You can select several fields in the structure window and change their type through a right clic. Even if the fields are in different tables. Regards, Olivier > Le 1 déc. 2017 à 14:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> a écrit > : > > Using v16: > I have a large number of fields (hundreds) that I want to change from > String to Text. Is there any way to do this programmatically? I thought I > might be able to do it via SQL commands, but apparently 4D doesn't support > the ALTER FIELD function. > I'd prefer not to spend the rest of the day changing them al manually :) > > Pat > > -- > ************************************************* > CatBase - Top Dog in Data Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > ************************************************* > ********************************************************************** > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************