>>>>But you can't open table in DE without opening appropriate DBC. Or I >miss >>>>something obvious? >>>> >>>Yes and I meant this. It looks like problem of chickens and eggs. >> >>Maybe I am not following both of you, but I have been able to add a table >(that is part of a DBC) to a DE without opening the database first. I >think I just clicked on the "Other" buttong and selected the table. Could >you not then go to the cursor's properties to see the DBC name? >> >>Or, with the way things have (not) been going lately, maybe I just dreamed >all of this :) > >I tried this on my machine and you know what: Database property was filled >by dbc name even if I added using 'Other'. May be Fox is smarter than all >of us? If you open a table without explicitly opening the dbc, it still gets read (and maybe it remains open, maybe not - not quite sure, it appears closed), so you do have long names, PK and other dbc-related stuff. You can get the database name using Dbgetprop(table_alias, "table","database"), regardless of database being open or not. As for the opposite problem - finding what tables are in the database - one would have to make a SQL select from the .dbc, like Select * from the_dbc.dbc where ObjectType="Table" and get the names in the third or fourth column (this is the trouble with OOP - you write it once for good, and when you get it up and running, you go forgetting how you did it :).