Re: Adding fields to tables using SQL

2017-03-02 Thread Keisuke Miyako via 4D_Tech
IMPORT STRUCTURE is powerful, but I don't think it can modify existing tables... http://doc.4d.com/4Dv16/4D/16/IMPORT-STRUCTURE.301-3036688.en.html maybe the plugin entry-point is more forgiving (haven't tried) https://github.com/miyako/4d-plugin-structure-access > 2017/03/03 5:56、bob.miller---

Re: Adding fields to tables using SQL

2017-03-02 Thread Charles Miller via 4D_Tech
On Thu, Mar 2, 2017 at 3:56 PM, bob.miller--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I've tried this with SQL: > > ALTER TABLE GlobalPricebook ADD TRAILING PB_LTPrefix01 VARCHAR (20) NOT > NULL > Base upon v15 docs I do not see the ability to add NOT NULL or NULL to command. I assume you

Adding fields to tables using SQL

2017-03-02 Thread bob.miller--- via 4D_Tech
Hello, I'm tired of the structure editor and how it requires you to add fields one at a time and how the field palette disappears each time 4D loses focus. I created my own little "Field Adder"utility where I can specify a table, then drop a list of field names and data types from two rows