>>>>Hi guys, I have a 1-to-many form, my child table is a local view that is created with fields from two differents tables, when I insert new values into the
>>>>tables that populates the view and then issued
>>>>=requery('my_view') the view is not updated. I am using
>>>>optimistic table buffering, what I am missing ?
>>>>Thanks in advance.
>>>
>>>Had the same problem, Luis, and simply issued a TableUpdate(.t.) before the requery(). That forced the update and prevented some awful error messages about buffers.
>>>
>>>HTH
>>>Barbara
>>
>>Thanks Barbara,
>>But in my case I need to do "TableRevert" if the user
>>want to, and if I force a TableUpdate I'm not going to be able
>>to revert the changes easily.
>
>After the user decides, do either TableUpdate or TableRevert before the requery.
>
>Barbara
Thanks again Barbara, I ended up with a complicated code that
takes care of everything manually, the problem was this:
Assume that you have one Form, with a grid that is populated
from two tables, then you let the user to add and remove records
from your view, after the user is done he can either
save the changes or cancel it, but the view doesn't reflect
the changes!! still, and the user needed to see the changes in
the view "before" he decides to save or cancel, that was the
problem, do you understand?, I could not TableUpdate because
I was going to loose the posibility of TableRevert, in other
words, I needed to show the changes before the users decide to
save or cancel.
Thanks again for trying to help.