Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Changing updatable tables in a View
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00122758
Message ID:
00123177
Vues:
17
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform