> On 5 Dec 2017, at 20:45, Timothy Penner via 4D_Tech <[email protected]> > wrote: > > The docs say: "WARNING: This command does not support array variables. Use > the new BLOB commands instead."
Thanks Tim Didn’t see that. > > Why don't you just use SQL EXPORT SELECTION and SQL EXECUTE SCRIPT? That’s an interesting approach. I will mentally bookmark it for future use At the moment I’m using “Selection to JSON” to dump the data into a text variable and then SAVE VARIABLES to out it to disk. This is an absolutely awsome way to do it I’ve discovered if you’re migrating between heterogeneous table structures because you basically have the table at the other end in an object array where each source record is accessible at field level by name without requiring a temporary table to dump it do. Cheers for the replies ! Peter ********************************************************************** 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] **********************************************************************
