>Hi All,
>
>How can I get an array of all the tables in a database through the VFP ODBC connection?
>
>TIA
>MIKE

Just to make sure of myself: this is the odbc connection *into* vfp, right?

VFP won't return an array. You'll have to query the DBC for this.

The sql would be:

select objectname from DBC() where objecttype = "Table"

I'm assuming you're calling this *from* VFP as well. if you need an array, you'd have to then select..into array from the result cursor.

The odbc connection should be set up as not exclusive as well.