Vince,

Thanks for introducing me to the cool SQLgang. I was aimlessly looking in DBGetThis() and DBGetThat()

Henry

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of Vince Teachout

Sent: 2007-03-22 3:59 PM

To: profoxtech@leafe.com

Subject: Re: List of tables in an ODBC Access mdb

henry.dagher@hrsdc-rhdcc.gc.ca wrote:

> I am trying to analyze an undocumented Oracle data model. The DB has been dumped into an Access mdb for me.

>

> Using VFP (of course), I'm trying to read in the names of all the tables (100+) in the mdb so I can programmatically create remote views. My ultimate goal is to scan all fields in all tables in search of data values.

>

> I have created a DB and made a connection to the MDB. What I'm missing is a way to populate an array with the names of the tables in the mdb. Then I can cycle and programmatically create my remote views. The actual search is NOT a problem. I am just struggling with getting the list of tables from the mdb.

SQLTables() is your friend.

SQLColumns() will be your friend, after you make friends with SQLTables()

_______________________________________________