>Suppose you have database foo.dbc in c:\foo\data\, and another database foo.dbc (same name) in c:\foo\lastmonth\data\, and you'd like to work with both of them, so you open up both. Is there a way to reliably discern what will happen if you then call a program that executes "SET DATABASE TO foo"? It seems awfully ambiguous to me.

Bill,

You can specify full database name in SET DATABASE TO command to avoid ambiguity.

SET DATABASE TO c:\foo\lastmonth\data\foo.dbc