Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Form builder & SQL 2005?????
Message
From
13/01/2008 20:19:17
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
13/01/2008 20:11:15
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01281511
Message ID:
01281512
Views:
8
>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)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform