>You can try a combination of the following commands:-
>
>? used("tablename")
>
>Returns .T. or .F. if the table is in use.
>
>? cursorgetprop("database", "tablename")
>
>Extracts the database name if part of a container.
I failed to mention that both tables were views...
If I check used(), it will return .t. no matter which database its part of, right? And if both databases are open, then how do I know which database has that view open? It might well be that I'll need the view open in both databases at the same time, which will result in an alias. Maybe I should just make up an alias when I open the table that indicates the database as well?
--Todd Sherman
-Wake Up! Smell the Coffee!