Hi Nigel, A cunning plan, but wouldn't work because a) only one database can be active at a time, so only one table would be accessible. b) We allow the customer to define their own relations between their tables, and that wouldn't be possible.
But I like your outside-the-box thinking :) Pat On 8 March 2017 at 12:43, Nigel Greenlee via 4D_Tech <4d_tech@lists.4d.com> wrote: > Pat > > OK.. > > > Let me suggest something crazy then... > > 1) You create an external data(file) with a single table(with a trigger).. > Lets call this the template.-we never use the template > > 2) When a user wants to create a custom table you duplicate the > template(Using LEP)..rename the ‘copy’ to reflect the custom table name. > The copy has a single table with a trigger(a generic trigger i > assume)..and a single field(UUID auto generate).. > > 3) You use alter to alter the name of the table in the copy and add the > custom fields > > So you end up with N external data-files one for each custom table. > > …maybe someone has a better way > > Nigel > > > > > On 8 Mar 2017, at 12:32, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > > Hi Nigel, > > Yeah I did look into that option as well, but it doesn't solve the > trigger > > problem. Triggers are essential to us! > > Pat > > > > On 8 March 2017 at 12:19, Nigel Greenlee via 4D_Tech < > 4d_tech@lists.4d.com> > > wrote: > > > >> Pat > >> > >> A sideways question for your concept. > >> > >> 1) Are you creating the tables in the main structure or using the > external > >> datafile( CREATE DATABASE IF NOT EXISTS DATAFILE > >> <<$_t_CustomTablesPath>>;) .(I use an external datafile structure for > some > >> things-very useful..it could be useful in your scenario as the created > >> tables and data could remain intact with new builds. > >> > >> > >> I have not tested to see if you can set the trigger code on a table in > an > >> external data file and if you can do it compiled..the external datafile > is > >> not compiled..but i suspect the answer is no! > >> > >> I guess the other option is to go back to the days before we had > triggers > >> and set a process to look for modified records in the created tables… > >> > >> Nigel Greenlee > >> > >> > >> > >> > >> > >> > >>> On 8 Mar 2017, at 10:10, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> > >> wrote: > >>> > >>> Hi Arnaud, > >>> Yes, but the thing is that the TABLES will not be missing, only the > >> custom > >>> fields that the client created. Now if there was a REGENERATE MISSING > >>> FIELDS function ... > >>> > >>> On 8 March 2017 at 09:59, Arnaud de Montard via 4D_Tech < > >>> 4d_tech@lists.4d.com> wrote: > >>> > >>>> > >>>>> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com > > > >> a > >>>> écrit : > >>>>> > >>>>> [...] Also I've realised that there is another fundamental problem > with > >>>> the idea > >>>>> of allowing customers to create new fields: when we issue a program > >>>> update, > >>>>> those custom fields - and their data - will be lost! > >>>> > >>>> See GET MISSING TABLE NAMES and REGENERATE MISSING TABLE: > >>>> <http://doc.4d.com/4Dv16/4D/16/GET-MISSING-TABLE-NAMES. > >> 301-3036706.en.html > >>>>> > >>>> > >>>> -- > >>>> Arnaud de Montard > >>>> > >>>> > >>>> > >>>> > >>>> ************************************************************ > ********** > >>>> 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:4d_tech-unsubscr...@lists.4d.com > >>>> ************************************************************ > ********** > >>>> > >>> > >>> > >>> > >>> -- > >>> ************************************************* > >>> CatBase - The Database Publishing Solution > >>> 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:4d_tech-unsubscr...@lists.4d.com > >>> ********************************************************************** > >> > >> ********************************************************************** > >> 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:4d_tech-unsubscr...@lists.4d.com > >> ********************************************************************** > >> > > > > > > > > -- > > ************************************************* > > CatBase - The Database Publishing Solution > > 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:4d_tech-unsubscr...@lists.4d.com > > ********************************************************************** > > ********************************************************************** > 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:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** > -- ************************************************* CatBase - The Database Publishing Solution 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************