Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing updatable tables in a View
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00122758
Message ID:
00123177
Views:
18
>>Thanks Bob, but I´m using a kbizobjmaintenaceform and I need to show fields from the 3 tables in the grid.
>
>I still don't see the problem. Either create a 4th view, which joins the three views, or just relate the views of each bizobj and set up the grid... you can use fields in more than one view for a grid. (You can in a browse)
>
>BOb

Bob,

I created one View with all the 3 tables joined, but only "Address" is updatable. I created a "Client" BizObj and a "Name" BizObj. So when I need to add a new "Address" everything works fine now (thanks).
But (there's always a but) when I need to create a new "Client" I have to insert the new record in the 3 tables. So, in the OnNew method of the main BizObj I called the .New() method of both "Client" and "Name" BizObjs. When I try to save the new record in the Main BizObj, I receive an error, because the insert trigger is triggered and there is no matching record in the "Client" table and in the "Name" table (not yet, they're going to exist when "Client" BizObj and "Name"BizObj are updated). Did you get the problem ?

Regards,
José Augusto Cavalcanti
Global Connection
jose.cavalcanti@globalconnection.com.br
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform