...so an attempt to free memory will only occur if the allocation was successful
If you think there could be corruption/hidden chars in the XML file, make a copy of the file (backup) and then load it into a text editor (like UltraEdit or NotePad++). With the file now displayed as text rather than XML, it should be easy to spot a fault.
What would I ever do without you blokes and your help??? NO!! Don't answer that!
:)
I went through the XML with NotePad and didn't see anything wrong but then NotePad doesn't have a 'show hidden characters setting and I should have used PSPad which I do have here. DUH moment.
In the meantime, InfraTec kindly delivered changes to both import and export routines to try and they almost worked except for a minor issue.
I exported the database with his changed export code, then deleted the database and imported the export file.
It imported 28 out of 32 records without crashing!! Whoohoo!!
I then copied my *original* full database to a temporary file and opened that, comparing each record and deleting records in the copy until I was left with the four records that didn't import. I was using SQLite Expert Personal by the way.
Verified the record data and blobs in the four records left so I think the import code is missing something or the export file still has an issue. I will ask him when he has time as to what he things.
InfraTec has been an unbelievable amount of help.
P.S. I really think I need a 32 inch monitor as my eyesight has issues reading dots and commas on the 27. What are my chances that my wife will let me? I will just have to give up having NAS drives:)