Thanks for the response Mr Miyako.
I tried using IMPORT STRUCTURE and immediately got errors:
1100 Wrong source field
1020 Wrong field reference in database myDatabase
1227 Table name is already used
When I exported the ‘old’ structure and diffed the .xml files I found the
following differences:
- the ‘old’ structure have a “keep_record_stamps=“false” attribute in some of
the tables which isn’t present in the ’new’ structure. Here’s an example:
<table name="Business_Category_Code" uuid="C4FBFD0527AD2D4EAAA5B1E5CC29DE11"
id="29" keep_record_stamps="false">
- The new field references in the ‘new’ structure. This was expected.
Tom Benedict
> On Jun 25, 2019, at 14:41, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> 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:57、Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>のメール:
>> 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.
>
>
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************
