>>>>>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.
>-------------------------------
>
>You bet! I wish I'd had something like that back at the beginning of this project!
>
>Have you heard of anything that would help me with the following:
> I have a couple of Tables, upon which are based almost a dozen Views and 5 or 6 Forms. I recently had to change the structure of the Tables. As a result, I had to rebuild from scratch, each View. But that was just the obvious ripple. The change to the Tables involved adding a couple of fields. These fields were for behind the scences stuff and did not need to be on any of the Forms. Nothing that gets displayed or used by the Forms was altered. Even though I had removed the Views from the Database, and reCreated them (via the wizard), and I removed them from the Forms and reAdded them.... Running the Forms would result in an illegal operation!
>
> I had to go into each field that had a record/control source referring to one of these views, and RESET TO DEFAULT and then reconnect each field.
>
>Have you heard of anything that would help me with something like that?
>

That's the price you pay for using bound interface. Unbound interface relieves all these problems tremendously.