Hi Chuck, Thanks! I totally agree with you and was anticipating these changes. I have just one really dumb question… In all my years using 4D, I have NEVER used a sub-table. Just how would I recognize if this structure includes and sub-tables?
Regards, Ken > On Apr 24, 2020, at 4:12 PM, Chuck Miller via 4D_Tech <[email protected]> > wrote: > > First, I would not use windows 7 at all. I would move to windows 10 > > Second here are some potential ares of concern that you will need to deal with > > 1. Are there any sub-tables. If so I would recommend creating new tables and > moving data in v 15 > > 2. There are probably obsolete pictures in the db. You can use JPRs component > in 16 (32 bit mode) > > 3. I would also not use the built in primary key stuff, but would add a UUID > to each table and table that the primary key. I have previously posted code > I have used to create these. You need to create these with an empty data > file. When you open an existing data file, all of these keys should be > populated automatically. If not I have code that will check and make sure > that all records have UUIDs. > > 4. I would also run tools on structure air each in 12 and then at each step > up to a newer version > > > > Others may tell you that you can use an existing unique key in a table for > this. I would not, as these are used only for journaling. I would not want to > make a UUID key on a one table that was used in a many table as the link. I > would keep all my other long ints for that. > > Regards > > Chuck > ------------------------------------------------------------------------------------------------ > Chuck Miller Voice: (617) 739-0306 > Informed Solutions, Inc. Fax: (617) 232-1064 > mailto:cjmiller<AT SIGN>informed-solutions.com > <http://informed-solutions.com/> > Brookline, MA 02446 USA Registered 4D Developer > Providers of 4D and Sybase connectivity > http://www.informed-solutions.com > <http://www.informed-solutions.com/> > ------------------------------------------------------------------------------------------------ > This message and any attached documents contain information which may be > confidential, subject to privilege or exempt from disclosure under applicable > law. These materials are intended only for the use of the intended > recipient. If you are not the intended recipient of this transmission, you > are hereby notified that any distribution, disclosure, printing, copying, > storage, modification or the taking of any action in reliance upon this > transmission is strictly prohibited. Delivery of this message to any person > other than the intended recipient shall not compromise or waive such > confidentiality, privilege or exemption from disclosure as to this > communication. > >> On Apr 24, 2020, at 5:16 PM, Kenneth Geiger via 4D_Tech >> <[email protected]> wrote: >> >> Hi all, >> >> I’m solicitating your opinions. >> >> I’ve picked-up a new 4D client. They have an existing 4D system (v12 running >> on Win7) that has been stagnant for quite e few years. I believe it was >> originally written under 2004 or maybe even 6.8.5. They’re looking to >> replace their computers with Win10 machines and and upgrade 4D. I’m a Mac >> guy and I do my Win development in a VMWare environment. I’ve got several >> configurations available. I’ve got a Win7 environment that has a 4D v14 >> installation and a Win10 environment with 4D v15, v16, and v17 >> installations. My thought is to skip v14 and open the v12 system under v15, >> take care of what needs to be updated, and then move it to v17. Your >> thoughts would be most appreciated. >> >> Stay safe and healthy, > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > <http://lists.4d.com/archives.html> > Options: https://lists.4d.com/mailman/options/4d_tech > <https://lists.4d.com/mailman/options/4d_tech> > Unsub: mailto:[email protected] > <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] **********************************************************************
