>>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?

You are right. My style of coding has changed many times, over the course of many years. As far as testing, as much as I hate to admit it, I have been doing more testing of my app than ever before. But the app is so huge (as you can imaging the vertical market applications grow over many years) that testing is very time consuming. Or I can simply leave these views in the DB; I don't think they take any "space" or "memory.". I am just trying to clean up the code. Just in case, someone else (very doubtful) will take over supporting this app.
Thank you.