It's not that I need to know what tables exist, but rather what table in my DBC have a certain field.


>First, why are you USEing the DBC?
>There is probably a safer way to get what you want.
>Is it discover if the table exists? If so, use INDBC() instead.
>Is it to get at whatever tables are in the DBC? If so, use ADBOBJECTS() instead.
>
>If you really need to get into the DBC as a table, are you opening the table once you've found it in the same workarea as the DBC's cursor?
>Either use the table IN 0, or SELECT 0 first.
>
>
>>Here is my problem : I want to open a database as if it were a table (I know how to do that thing) I locate a specific record in my "database table" and get the value. That value is the name of a table in my database. I open that table, select it, do what I needed to do, and then try to reselect my databse to continue with my process, because I have plenty of table like that to change. My problem is that when try to select my "database table" again , it doesn't work. it's saying that it cannot find the ALIAS CAS(my database)
>>
>>I tried :
>>

>>      SELECT CAS
>>      SELECT 'CAS'
>>      SELECT &CAS
>>      SELECT (CAS)
>>      SELECT ('CAS')
>>      SELECT (&CAS)
>>        lcAlias = ALIAS()
>>        ...
>>        SELECT &lcAlias
>>
>>

>>
>>any idea on how to make it work???????