Pat, There is a bug with dates when importing using SQL in v12. I don’t know if it has been addressed in v16 but check that you don’t have years that have 5 digits.
> On Aug 20, 2018, at 5:22 PM, Pat Bensky via 4D_Tech <[email protected]> > wrote: > > I'm exporting data from a v12 database using EXPORT SQL and importing it > into a v16 database. > For the most part this works OK, but in some tables, records are missing. > I can't see anything consistently different or wrong within the missing > records. > > All text fields are stored within the records. > > Anybody have any ideas about this? > Later, Guy -- Guy Algot, Solutions Specialist Edmonton, Alberta (780) 974-8538 hardware, installation, training, support, programming, internet specializing in 4th Dimension =-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= "Microsoft is a cross between the Borg and the Ferengi. Unfortunately, they use Borg to do their marketing and Ferengi to do their programming." -- Simon Slavin ********************************************************************** 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] **********************************************************************
