>In the view designer I know I can open free tables and base the view on those free tables. However, is it possible to create aliases for those tables and base the view to run from the aliases instead?
>
>I'm trying to convert a program over to using a view. However, some of the tables the view would need are opened in a number of other programs called by the one using the views.
>
>If I don't have to, I don't want to have to change all the programs called by this one.
>
>Thanks for whatever help you can offer.
It ain't necessary. Visual FoxPro checks for the existence of an open table. If it is open, it does the equivalent of USE...AGAIN. The alias is irrelevant.
The only common problem is that the table remains open. If you want it to be open with a specific alias, just open it with that alias before you use the view.
Or, in the other program, open your table with USE...AGAIN, to be sure you get no error message if the table was already open.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
