>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,
Hi Alex -

I agree with Agnes - you can create a test database, add a test table, then create a test view in the View Designer.
Then you can run gendbc.prg, shipped in the Home() folder, to get the Create View statement, and all required DbSetProp() lines.
(FWIW, most of the latter just confirm default values and thus may be superfluous).


hth
-Stefan