Chip, What you are trying to do is all possible and I have done it with many different SQL databases over the years with various SQL backends such as DEC RDB, Sharebase, Terradata, Oracle, MS SQL, Firebird, MySQL, SQLite and PostgreSQL.
Some of these do not exist anymore the main ones I would expect you would hit are: Oracle, MS SQL, MySQL, PostgreSQL For each there are either general tools or specialist tools which can be used from 4D. My favourite tools are Pluggers options for MySQL, SQLite and PostgreSQL For other databases the base option is to use 4D ODBC Pro apart from Oracle where you could use 4D for OCI I have always liked SQL although each system has it's own variations from the standard. You said you were in the 'can this be done?' phase. I would say it can be done the extent to which it is reasonable depends on your budget and time to learn. Sometimes simpler solutions are better. For instance there are a number of tools that will allow you to run a select script which could be written to a file and then imported. That would allow you to separate the SQL scripting from the report storage and data processing. Regards, Dougie ________________________________________________________ telekinetix Limited- J. Douglas Cryer Phone : 01234 761759 Mobile : 07973 675 218 2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE Email : [email protected] Web : http://www.telekinetix.com <http://www.telekinetix.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] **********************************************************************
