Re: Create Object Field Under Program Control?

2019-06-25 Thread Tom Benedict via 4D_Tech
Thanks for the response Mr Miyako. I tried using IMPORT STRUCTURE and immediately got errors: 1100Wrong source field 1020Wrong field reference in database myDatabase 1227Table name is already used When I exported the ‘old’ structure and diffed the .xml files I

Re: Create Object Field Under Program Control?

2019-06-25 Thread Keisuke Miyako via 4D_Tech
haven't investigated thoroughly, but I think it is possible to update an existing table with IMPORT STRUCTURE https://doc.4d.com/4Dv17/4D/17.2/IMPORT-STRUCTURE.301-4386048.en.html if the UUID matches. you might want to first test and confirm the behaviour with an existing DB. > 2019/06/25 23:5

Create Object Field Under Program Control?

2019-06-25 Thread Tom Benedict via 4D_Tech
Is there a way to add an object field to a table via 4D code? I went to create a SQL script to do this using ALTER TABLE but found in the documentation that object fields cannot be added via SQL. I have to add an object field to a number of tables in a number of databases, so it would be nice