>I'm using local views for all my data-entry (eventually it will be client-server). Of course, when I make any changes to the base table, all the rules, etc. in the view disappear. I could either:
>
>- Use GENDBC to put my view code into a .prg, then run the .prg after each base table change to recreate the view. The problem with this is that I'm also trying to use Stonefield Database Tools, and SDT doesn't like changes done outside it's domain.
>
>- Get xCase, but it's expensive, and maybe overkill for the size of my system.
>
>Any thoughts? Are there any other approaches? Has anyone used xCase?
It has been my experience that projects large or small profit from consistent use of tools that dicipline the work. XCase and Stonefield are two that fall into this catagory. Over the last 2+ years they have saved us many times the original investment. Both because they are well executed tools, and because they help us be rigerous even on the quick and dirty stuff.
HTH