So far, I have never ran into a situation where xCase couldn't handle my view. I would venture to guess that the only views it can't handle, are views that shouldn't exist anyway. Either because of poor database design, or whatever. Also, it's not that I haven't had complex data structures to work with, I'm currently working on a project with over 200 tables.

If and when I do encounter this problem, I would create a program that would generate those views in the database CREATE SQL VIEW...

>What do you do about views that are too complex to design in xcase?
>Maybe there are no such things?, I didn't get far enuff with the xcase designer before resorting to code.
>
>>To be honest, I would design my views in xCase along with everything else in the database, and update my dbc from the xCase model. We have been doing this for quite some time, and have had no problems.
>>
>>I have never had the need of taking an existing database and import the views. It can be done though since the xCase model is defined in Fox tables, but I wouldn't recommend it.
>>
>>>>I was wondering if anyone here had a strategy for using views in xcase. Specifically I am noticing that I cannot import views into an already created xcase model if they exist in the DBC. So though it is easier to define views thru the VFP view tool, I cannot update them into Xcase. What I'm looking for is some way to continue to use Xcase for its strengths, which lie in the area of modeling the DBC, and use VFP and eview for its strengths in creating local views.
>>>Any suggestions would be appreciated.
>>>
>>>
>>>Michael;
>>>
>>>
>>>I raised these and other questions with xCase about two years ago. At that time they had no plans to incorporate such features to support views. You might try e-mailing them and see if they have any suggestions. They responded to my e-mail within a few hours.
>>>
>>>My sister in law lives in North Hollywood - about 1/2 block from Burbank. Whenever we go to visit my wife and her sister have to go to the Galorea in Glendale to go shopping. I hate to shop!!! Well, if it is a computer item, or anything related to guitar that is O.K.
>>>
>>>Tom