Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating view from left outer join tables
Message
De
17/02/1999 09:09:37
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Titre:
Updating view from left outer join tables
Divers
Thread ID:
00188347
Message ID:
00188347
Vues:
98
I have a form based on the CBizObjMaintenanceForm.
On this a BizObj with a view that is a SQL join between my employee and zipcodes table.
In the employee table the foreign key to the zipcodes table is stored.
Because I want to show the zipcode as well as the city for the employee in the CGrisList, I have the view created like this.
This as well leaves the possibility of ordering on the zipcode or city and I don't have to care about setting relations.
Which leaves it all less fox related.

But now when changes are made for the employee's localization.
Change either the zipcode or city the foreign key of the zipcode table is changed in my employee table.
But when I return to the grid, these changes (new zipcode/city) aren't reflected in the view because it is not requeried.

I already tried putting it in the page1.Activate() but this is really overkill and from time to time not working properly.
Then I tried to do the EmployeeBizObj::Requery() from within its PostSaveHook() but no luck there because the save is included within a transaction.

Any suggestions.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform