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:[email protected]
**********************************************************************
