why not: - Add UUID as needed. - populate
Using Send/receive record during synchronization repeat for each record to import - read the record to import - verify the UUID of the imported record - if it exists -- do whatever record merging you need - if it does not exist, assign a NEW longint ID (relational field(s)), this gives each record unique relational ID(s) in each database in which that data resides. -- assign these new relational ID(s) to the relational field(s) of other imported records no need to redraw, no need to convert, no need to change existing working code. On Wed, 24 Oct 2018 09:37:08 -0700, Kirk Brooks via 4D_Tech wrote: > > a) go through every table affected and add the UUID field > b) at the same time remove the old relations & draw in the new ones > c) write a conversion method(s) to loop through all affected records > i) lookup the linked records based on the old longint field > ii) set the new UUID foreign key > d) update all the queries that relied on the old key fields --------------- 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:[email protected] **********************************************************************
