Re: Change field type programmatically?
Hi Olivier, Good point ... that will ease the pain somewhat! Pat On 1 December 2017 at 13:42, Olivier Deschanels via 4D_Tech < 4d_tech@lists.4d.com> 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 <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 > ** -- * 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 **
Re: Change field type programmatically?
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 **
Change field type programmatically?
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 **