I have a small utility to rebuild views from a data dictionary. Because we are handling cascading views, I open each view as it is built(with the alias expected by the next view) and then go on to build the next one.
So the command is:
USE (lc_use) ALIAS (lc_alias) IN 0
This works fine for about seven views.
Then on the 8th it starts failing.
At this point lc_use="\\venus\datastore\int\dd\ddvalprogs\valindata\valindata!lv_main_daily_counts"
lc_alias="v_main_daily_counts"
The full path reference including server to the database is used througout the program. I'll check if removing it will work.
This is on Window 2000 (just got on this machine) In VFP 6.0 with all patches.
Thanks
Gar W. Lipow