Thanks y'all. I updated the database to v17 to both export and import the data - this was even worse! So ... Chip ... yes please!
Thanks Pat On Tue, 21 Aug 2018 at 06:44, Nils Kollandsrud via 4D_Tech < 4d_tech@lists.4d.com> wrote: > Hi Pat, > > I started using Export/import sql to compact/move data between versions > since v12, and I remember having issues > with certain versions of v12 when the exported fields contained > single-quotes in that they were not escaped correctly. > If I remember correctly, it was fixed in late v12 versions (v12.6?). Also, > I had to make sure I hadn't renamed any tables/fields. > > > > On Mon, Aug 20, 2018 at 11:22 PM Pat Bensky via 4D_Tech < > 4d_tech@lists.4d.com> 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? > > > > -- > > ************************************************* > > CatBase - Top Dog in Data Publishing > > tel: +44 (0) 207 118 7889 > > w: http://www.catbase.com > > skype: pat.bensky > > ************************************************* > > ********************************************************************** > > 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 > > ********************************************************************** > > > > -- > Nils Kollandsrud > Ixmal Intelesis AS, Pilestredet 75 C, Postboks 5130 Majorstuen, 0302 Oslo, > Norway > Tel: +47 22121212 Mob: +47 920 15550 > ********************************************************************** > 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 > ********************************************************************** -- ************************************************* CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky ************************************************* ********************************************************************** 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 **********************************************************************