>>>There is another nice thing about using (parameterized) views, according to my VFP teacher - Jim Duffy.
>>> If you use PV's extensively,
>>> it is much easier to migrate your app to a C-S app.
>>
>>If you write an app to only use views, Changing to client server takes _no_ code changes whatsoever, except reset data path. Even on apps that I am fairly sure will never go C/S I write only with views now. Once you're in the habit, it is just as easy, especially if you have view management utilities.
>-----------------
>
>hmmm. View management utilities, huh. What kinds of things are you refering to? I'm still new enough at this to only know about the view designer....which I only consider "so-so". I'd love to start using a robust tool for working with views (and queries). I keep running into flaws in the query designer and suspect the same flaws exist in the view designer as well.
I have a few program that I work with when managing views, one of which is available here in the files section called 'genview' (the file might be called gentable, I forget). Another is a utility for use on one table views, that takes all the extended properties for the table and adds them to the grid. For example, when you create a table and specify comments, inputmasks, formats, validation rules and create a view based on that table, none of those properties get carried over to the view definition. My utility takes a view created from a table and sets all the view properties to the same as those of the table. Let me know if you are interested and I'll post it.
Erik Moore
Clientelligence