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 woul
Back in 4Dv11 days, I was asked to connect to a SQL database with 4D. With 4D,
I was able to connect to a test copy of the SQL system. I found and extracted
the list of the SQL tables. And, for each table, I extracted the field map. I
then wrote 4D code to do sample data extracts for each table
Thanks Tom!
the end goal is a single report (this would be done in 4D), summarizing
information across all 4 commercial applications.
What I know about the internal workings of any of the 4 sql programs = 0
From the description - there is no official outline of the report yet
- each program cont
Hi Chip,
The answer is yes to your three questions, but access to the table/fields
schema will need to be granted to the user. Also, “automagically’ creating a
matching 4D structure will require you write code, so it’s not very ‘magic’. ;)
Extracting data should be straightforward. It’s just a
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
5 matches
Mail list logo
