Thank you. I looked for ADD VIEW in help. How embarrassing...
Alex
>Alex,
>
>the syntax is
>
>CREATE SQL VIEW name AS SELECT ...
>
>
>the "properties" of the view might be created via DBSETPROP
>
>A start might be to create a view via designer with all props set and open the SQL View of the designer (I'm not shure, but right cklick the designer).
>There is the programmatical declaration of the view.
>
>Note that it might be a good idea to declare fields in the form DBC!Alias.Fieldname if you work with more then one DBC. (Simple allways mention the DBC, in FROM; JOIN as well as in the properties)
>
>Agnes
>>Hi,
>>
>>A VFP database has remote views into a btrieve database. Some views pull all data from one table and some filter and join data from more than one table.
>>
>>I want to create a snapshot of the data in a new DBC. Views that pull all data become VFP tables and parameterized remote views become parameterized local views. The first are easy (thank you Dragan), but how do I create local views programmatically?
>>
>>TIA,
>>
>>Alex