SQL EXPORT SELECTION will certainly be faster ... and simpler to write ... Pat
On 22 October 2017 at 11:10, Arnaud de Montard via 4D_Tech < [email protected]> wrote: > Unbelievable but a customer of mine has always thought that any backup > solution was really too expensive. Predictable has occurred, crash, no > backup, only a damaged data. I think I'll never understand how people can > have such a disregard for their own work (10 years of input, 4 users C/S). > Hopefully the cost of repair will make him change his mind… > > The damaged data can be opened, but MSC says it must be repaired. After > repairing "standard" and verification, MSC says "it's OK" but it's not, > very strange things happen. > > The solution to get a workable 4dd is to export all/import all, I think, > but my experience of such a situation is near to zero. > > I tried SQL EXPORT SELECTON to detect what tables have unreadable records > in the damaged data, 2 tables (the biggest, of course). > > • 1st question, where do I export from? The damaged data, or the repaired > by MSC one? > > • 2nd question, how to export? A loop through table with SEND RECORD, or > SQL EXPORT SELECTION? > (given that I think I'm able to detect damaged records and ignore them in > the exported selections) > > TIA, > > -- > Arnaud de Montard > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- ************************************************* 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) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
