Mike Sue-Ping
Cambridge, Ontario, Canada
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Updating a view problem
I have a VFP8 form with a local view in its dataenvironment. On the form, I put two spinners, one for a length value and another for a width value. A textbox is also on the form that show the product of the former (ie. area).
My VFP database container has a field update trigger that calls a stored procedure to do the area calculation when the length and width fields change. I've verified that this all works fine when I browse the table and edit the length and/or width fields and the area fields change accordingly.
My problem is that when I use the view based on this table, and make changes to the length or width values, the area value never refreshes to show the correct calculated value. I issued a TABLEUPDATE on the view and expected it to update the area. It doesnt. The underlying table does in fact get updated with the correct values, however, the view does not.
I checked the methods and properties of the dataenvironment and could find anything that could help.
My question is, how do I get the view to update the calculated values (the stuff done in the stored procedure) so that it appears correctly on my form?
Any suggestions and/or comments are greatly appreciated.
TIA
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only