>>>Hi,
>>>
>>>I have a field (field_test) in a table (table_test) that has a Default Value of "J". When I append a blank record to table_test, the value of field_test is (as expected) "J". I'm working with views (view_test) and when I append a record to view_test, that is based on table_test, field_test is empty. Is this an expected behaviour or I'm doing something wrong ?
>>>
>>>Regards,
>>
>>Jose,
>>
>>I'm using xCase. One of its beauties is that it carries all the tables default into your views. So I only have to define my defaults, validation rules and validation messages once. You can donwload an evaluation copy from www.xcase.com
>>
>>José
>
>How stupid I'm. I'm using xCase to manage my tables, but I didn't know (I know that is the manual, but...) that I could generate the views too.
>Is there any way of importing the views that I created in VFP to xCase ?
>
>TIA
Jose,

No, there is no way to import your VFP views into xCase. Elie Muyal, the maker of xCase, claims that VFP does not hold enough informations about its views for them to be imported. So you'll either have to redesign them in xCase, or simply make the new ones in xCase. My advise would be not to change everything in one shot. Take your time to understand how it works and check the proposed SQL Statement often. Be espacially careful about xCase "path" notion. That is, the way for one table to reach another. The default is "no path", so two tables don't get connected and you might retrieve hundred thousands of records easily... If you press the 'more' button, you'll see all the available "paths". Be sure to select the one that makes sense for your particular case. Also some features are well hidden. For example, to tell xCase how to update your view you have to click the "Header" button, then another button (second on the toolbar if I remember well) and from there make your changes...

Jose