Farouk-
>We have almost done on this project when the client ask for last minute addtion. We have a lot of transactions screen which use view compound from the transaction table to the master table. Example : Employee Master and Leave. The compound view use the a parameter field in employee master to filter off the records. Now the client request to get another field from a 3rd table, service history. What is the quickest way to do this? To do the conventional way, I will need to look at all the screens and the views and change the views to include this new parameter. Is there any faster way?
Is it literally a view? Is it defined in a DBC? If so, then you should only need to change the view. If you've copied a SQL statement into multiple forms, then, you'll have to search. If you're using VFP 8.0 you might be able to do a search and replace across the project (Tools | Code References). If this is the case, I'd urge you to consider changing your approach and start using a view if you're not already. They don't have to be updateable. Also, I've found Stonefield Data Toolkit (
www.stonefield.com) to be a worthwhile investment, if that's a possibility for you.