>>>I have this problem:
>>>I have VFP database connect with ODBC.
>>>I need detecting ALL TABLES AND VIEW in VFP dbc.
>>>What can I do it ?
>>>
>>>Jaro.
>>
>>Since this is ODBC, the only way I can think of is to have a meta-data table on the database side [in the DBC] that has a record for each table or view name to select from.
>
>Thanks, I know this method.
>but I need working with other database as Oracle, SQL, Informix, Access.
>
>Some idea ?
From Oracle:
SQLExec(nConnectHandle, 'select table_name from user_tables', 'crsOraTables')
SQLExec(nConnectHandle, 'select view_name from user_views', 'crsOraViews')
SQLExec(nConnectHandle, "select object_name, object_type from user_objects where object_type in ('VIEW', 'TABLE')", 'crsOraBoth')
From Access, you would probably have to do the same is in VFP -- create a table of meta-data.
SQL, I do not know. My guess is SQL has a table similar to Oracle.
Mark McCasland
Midlothian, TX USA