Base64 decoding and blobs issue

[sancho2]

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.

And/or make a known special character free xml file and run it through your code.

[Fangbeast]

...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:)