Change field type programmatically?

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Change field type programmatically?

4D Tech mailing list
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:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Change field type programmatically?

4D Tech mailing list
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 <[hidden email]> 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:[hidden email]
> **********************************************************************

**********************************************************************
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:[hidden email]
**********************************************************************
Reply | Threaded
Open this post in threaded view
|

Re: Change field type programmatically?

4D Tech mailing list
Hi Olivier,
Good point ... that will ease the pain somewhat!
Pat

On 1 December 2017 at 13:42, Olivier Deschanels via 4D_Tech <
[hidden email]> 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 <[hidden email]> 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:[hidden email]
> > **********************************************************************
>
> **********************************************************************
> 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:[hidden email]
> **********************************************************************




--
*************************************************
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:[hidden email]
**********************************************************************