Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
View From 4 tables
Message
From
13/07/1998 12:02:59
 
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00116772
Message ID:
00116802
Views:
12
>Hi boys!
>
>I am again :-)
>
>Trying create a view in view designer. I have four tables. GrandFather, Father and Two Childs, but I can not terminate my view because appears a message 'Column not found'. IF I create this view by select instruction, how specify type paremeters, fields to update and primary key?
>
>Thanks A lot!

You already received advices how to manage bulky view programmatically. However, there is one more idea to look at this from another angle: realistically, you probably are not going to update all 4 tables at a time. If it's so, then you just need in simpler view which will cover just updatable part of query (1 or 2 tables) and view designer will be sufficient here. Any non-directly-updatable parts can be pick up by interface means.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform