>Hi,
>
>I used to use VFP View in my VFP application. And I still have them in the database. When I open SDT I see in the View tree a bunch of views. Some time ago I switched my application to using CursorAdapter. So I don't think these views are used at all. But one never knows.
>I have used the same names as names for the CA. For example, I see a view V_Customers but I also use this name as name for a CA cursor. So using GoFish to search for the name brings a lot of results. I seem to remember that to use a VFP Views they have to be opened as a table; with USE command.
>Therefore, would it make sense to GoFish for "use v_customers" to find if the view is still used somewhere? (before removing it)
Yes but you can't be sure it will be complete. Depending on the coding style, there may be a function used to open aliases which would have the view name as parameter - in that case, you'd have to search for calls to that function as well. Also, the view name may be enclosed in quotes (and we have three kinds of those).
It may be simpler to just make sure the dbc with the views is invisible (move it to a different folder) and check that everything still works without it. I know it's dangerously close to the dreaded practice called testing, but how else can you be sure?