G’day guys, I stopped counting how often I spit the dummy over the last days - it is just inhuman.
The initial situation: A SQL-database with 70 tables (most of them empty) with sequentiell “relations” only used/written on Windows, wehre columns/fields contain all sorts of alien gremlins one only could imagine when heavily stoned. How do you export data from such a fu**BEEP** mess to be able to import it clean into a 4D-construct? If you have the chance: First, punish the original developer very hard! At this point a high praise to “RazorSQL" and “dbScheme" as the tools of choice to analyse/test/try/investigate…. If someone comes across such a challenge in the future get yourself at least the “Razor…” - great tool to look into and export data in different “tastes”. RazorSQL allows you to export the structure into a "SQL - CREATE TABLE IF NOT EXIST - file" which is easy enough copied into a 4D-method between "Begin SQL” and “End SQL”. One has to watch for type compatibilities of course!!! WARNING: Even the 64-bit version of 4Dv16 doesn’t allow methods larger than 32k! - 4D, what about explaining this on the world tour… After wasting a lot of life time finding a way to export/import the data, I ended up using the RazorSQL-Function “Generate SQL Insert Statement”. Due to the 32k-restriction it’ll take a while to get the still dirty data finally into 4D. I got 154,646 INSERT INTO-lines in a 62.8MB file. Bottom Line: Forget EOL if the char/string exist in the line itself! Cheers - Good night and good luck Jörg ********************************************************************** 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:4d_tech-unsubscr...@lists.4d.com **********************************************************************
