Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating view from left outer join tables
Message
From
17/02/1999 09:09:37
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Updating view from left outer join tables
Miscellaneous
Thread ID:
00188347
Message ID:
00188347
Views:
99
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.
Next
Reply
Map
View

Click here to load this message in the networking platform