Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am connecting to a SalesForce DB. Done.
Now, I want to load all fields from all tables:
What is the script that I need to use ?
After that, I want to create two list boxes showing the Tables (1) and the Fields (2) so I can expose which field is associated to which Table.
Who can help me doing that ?
Thanks in advance !
jeffrobertz wrote:I would find it logical, when you create a new application, by starting to load the 'tables titles' and related 'fields tables' to get familiar with the DB, without looking at the value !
Jeff, this sounds very logical, and there are some tools for that:
1. "Select" wizard provides that functionality and is working well for small databases.
2. Most databases and their ODBC drivers support standard sql commands:
SQLTABLES;
SQLCOLUMNS;
However, I must say - in real life we are often connecting to huge ERP systems like SAP and JDE - they have so many tables and fields that it is not practical to learn their structures by browsing their tables... You need to know or ask someone who knows, to identify the dozen or so tables that you actually need.
I hope it makes sense...
Oleg