Thanks that’s what I thought. It would be great if there was a way to update certain fields in those hidden tables. An example would be relation name. Even if screwed up no permanent damage would be done. How can I create a feature request.
Regards Chuck Sent from my iPhone > On Apr 9, 2019, at 5:06 PM, Keisuke Miyako via 4D_Tech <[email protected]> > wrote: > > constraints created by SQL CREATE TABLE > > https://doc.4d.com/4Dv17R4/4D/17-R4/foreign-key-definition.300-4075512.en.html > > are visualised in the Structure Editor but they are not to be confused with > 4D Relations. > > under system tables, > > https://doc.4d.com/4Dv17R4/4D/17-R4/System-Tables.300-4075484.en.html > > both 4D relations and SQL constraints (primary / foreign key definition) fall > into the same category. > > the only way to create relations by code is to use IMPORT STRUCTURE > > https://doc.4d.com/4Dv17/4D/17.1/IMPORT-STRUCTURE.301-4178236.en.html > > with project mode in 17R4 I suppose you could edit the schema file directly, > but that is kind of different. > > 2019/04/10 5:34、Charles Miller via 4D_Tech > <[email protected]<mailto:[email protected]>>のメール: > > OK I see that but see no way of creating the relations. Can anyone advise > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
