Hi all
I have Remote Views (FireBird) like following
- Parent View, Optimistic Record Buffered (One...)
- Child View, Parametrized (on Parent) Optimistic Table Buffered (...to many relation) [One...]
- Grand-Child View, Parametrized (on Child) Optimistic Table Buffered [... to one relation]
Now the problem is I cannot allow a save to the Grand-Child view until the whole set is saved. If I don't save and I Requery() the grand-child view to parametrized-scope of the child view I get an error that there are uncommitted changes to the grand-child view.
How can I get best of both the worlds keep unsaved changes until the final save. I have tried to make the grand-child view Opt. Record Buffered, then it would forcefully save the record before the requery and that is something I am trying to avoid. Because of this I cannot build in a constraint in the grand-child table else it will fail because the child table does not have records which the grand-child is pointing to.
I hope I have been able to explain the problem, please feel free to ask me of the details if required.
Please advise, thanks.