Hi All,

I've come across an annoying behaviour which seems strange. With two identical databases (content, names etc) in different paths:

OPEN DATABASE myPathA\myDBC
OPEN DATABASE myPathB\myDBC
SET DATABASE TO myPathA\myDBC
USE myView   && View defined in myPathA\DBC "Select * from myDBC!myTable"
SELECT myTable    && Underlying table opened by View
? DBF()    && = myPathB\myDBC

So VFP has selected from the table in the last opened database rather than the current database ! I know that hardcoding the path into the view definition would avoid the problem but it's not an option in my current situation and I've yet to find an alternative solution.

Any suggestions (except an ER)?

Regards,
Viv