Vince, Thanks for introducing me to the cool SQLgang. I was aimlessly looking in DBGetThis() and DBGetThat()
Henry -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Vince Teachout Sent: 2007-03-22 3:59 PM To: [EMAIL PROTECTED] Subject: Re: List of tables in an ODBC Access mdb [EMAIL PROTECTED] 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() _______________________________________________ _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
