While experimenting to find the best way to format text coming from a Panorama 6 database, I unexpectedly ruined my Panorama X database. My Pan 6 file has paragraph breaks in many of the fields so I was trying to disable them and used replace(exportline(),¶,"¶").
When I attempted to import the file it came through as one record. Panorama X added hundreds of new fields to accommodate it without warning.
Deleting the extra fields was far too tedious a task so I reverted to a backup from hours earlier. I lost some work but had no serious harm.
In a new database from the text, fine. But in an established database it would be good to have a warning about adding fields, or as in Pan 6 a message that extra fields in teh data were ignored.