Hi Olivier, Good point ... that will ease the pain somewhat! Pat On 1 December 2017 at 13:42, Olivier Deschanels via 4D_Tech < [email protected]> wrote:
> 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 <[email protected]> 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:[email protected] > > ********************************************************************** > > ********************************************************************** > 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] > ********************************************************************** -- ************************************************* 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:[email protected] **********************************************************************
