>>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

Hi Stefan,

You don't need GenDBC. Just rightclick the the View designer, choose "View SQL"

Agnes