Re: Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
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

Re: Change field type programmatically?

2017-12-01 Thread Olivier Deschanels via 4D_Tech
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

Change field type programmatically?

2017-12-01 Thread Pat Bensky via 4D_Tech
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