Pat Ah Relationships!!!!-well you never mentioned them I was thinking of an Autistic System:)
…i guess there is no way other than external database file with 500 or so tables(that should be enough:)) as mentioned by Tim Nevels (You can easily automate the creation of the tables of course through your uncompiled structure. (i would still put this in an external datafile if it where me! data can live there and not in the main database and therefore remain intact on upgrade).. Nigel > On 8 Mar 2017, at 14:34, Pat Bensky via 4D_Tech <[email protected]> wrote: > > 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 <[email protected]> > 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 <[email protected]> >> 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 < >> [email protected]> >>> 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 <[email protected]> >>>> 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 < >>>>> [email protected]> wrote: >>>>> >>>>>> >>>>>>> Le 8 mars 2017 à 10:19, Pat Bensky via 4D_Tech <[email protected] >>> >>>> 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:[email protected] >>>>>> ************************************************************ >> ********** >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> ************************************************* >>>>> 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:[email protected] >>>>> ********************************************************************** >>>> >>>> ********************************************************************** >>>> 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:[email protected] >>>> ********************************************************************** >>>> >>> >>> >>> >>> -- >>> ************************************************* >>> 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:[email protected] >>> ********************************************************************** >> >> ********************************************************************** >> 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:[email protected] >> ********************************************************************** >> > > > > -- > ************************************************* > 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:[email protected] > ********************************************************************** ********************************************************************** 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:[email protected] **********************************************************************
