My use of SQL is very limited... I have been asked to try to gather data from 4 separate commercial databases (assumed to be running some SQL compliant system of unknown origin - i.e. mysql, ms sql server etc) and try to coordinate the data and produce a report summarizing the combined data.
so.. I have a few questions... Given: - any version of 4D from v13 -> v17 - an unknown SQL compliant database - a valid username/password is it possible/reasonable to be able to: - get the table/field 'structure' (schema?) of the SQL system - use the table/field info to automagically create a matching 4D structure? - extract data (to text, or into a 4D system) from the SQL system Thanks Chip ------------ Hell is other people Jean-Paul Sartre ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************