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
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]