Tony, You can perform ad hoc sql queries directly from another copy of 4D. There’s probably an old tech note that has an example database. I know I modified an old db recently to just this thing.
I think I started here “4D v11 SQL Assimilator" https://kb.4d.com/assetid=75182 or if you have MS Office. You can use MS Query and an ODBC connection to test queries and send results to Excel. ---------------------------------------------------------------------- Edgar Hammond [email protected] Quest Information Systems http://www.questinformation.com ---------------------------------------------------------------------- ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
