>I used the standard VFP9 Form wizard to build a simple add/edit screen for a simple relational file.
>
>It was SQL 2005 tables called Report_name and the Report_tags. They are defined in a DBC as remote views V_Report_name, and V_Report_tags.
>
>It builds a decent form, but when I hit ADD, error says cannot find object v_report_tags in the database.
>
>Can the standard VFP9 form builder work with SQL 2005???
Perhaps they can't work with views, at all, be it local or remote, but only with tables?
In my experience, 'tis better to keep your fingers away from the standard form builder. It may have improved in more recent versions, I don't know - but the framework (or class libraries) on which the older forms are built were so primitive, that they serve only as a demo or instructional tool, not as a "real" framework.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)