At some point, v18(?), 4D will completely drop support for subtables. as I understand: a simple conversion to the current version will allow all the functions of existing subtables to continue working -- without -- any change to code. As noted by Tim Penner, but typo-ed :), this applies to a SINGLE level of sub-tables.
table OK sub-table OK sub-sub-table ... sub-<subn>-table FAIL There are changes to the structure during this conversion. The subtable becomes a normal 4D table, with a new "relation" created between the previous subtable and it parent. This "special Relation" allows the sub-table commands to continue working. If you delete/change this special relation all subtable functionality for that relationship is gone and can not be recovered (without reconverting the database). On Wed, 17 Oct 2018 14:45:52 -0500, Robert ListMail via 4D_Tech wrote: > I have an old v11 database running on Windows that’s not particularly > well-designed and where there are more than a few subtables to deal > with. Assuming that there is no additional budget for writing a new > clean app, would you likely upgrade or re-write in v17 with the old > v11 structure as guide? I’m concerned that the upgrade path will be > difficult because of the subtables and that by the time you deal with > all of the legacy junk not this database from the early 90s you could > have created something fresh and new. How might you approach this? > > Also, the client originally said the new database would not have to > migrate data forward from the old system and now they are wanting to > have the data too. > > Thanks, > > Robert > > ********************************************************************** > 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 > ********************************************************************** --------------- Gas is for washing parts Alcohol is for drinkin' Nitromethane is for racing ********************************************************************** 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 **********************************************************************