Use GENDBC, which ships as a tool with VFP. It outputs a .PRG which lists every single property.
>Hi,
>
>I would like to know if there is a way that you can output the sql and the properties of a view created with the view designer to a file.
>
>Let me know if you have any ideas.
>
>Thanks,
>
>-Nathaniel
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05