Removing path refs did nothing. I should add that the problem is that instead of open the view it treats it as a simple select statement with no into -- creates cursor query with the views result set.
If I open the view manually with the appropriate alias and resume I have the same problem with all subsequent views -- until I get the Window infamous c0005 error
>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