Subject | Cached Updates and master-detail-subdetail |
---|---|
Author | Carlos H. Cantu |
Post date | 2008-10-21T18:29:33Z |
Does anybody here is using CachedUpdates with a
Master -> Detail -> Subdetail model?
My problem with this is when someone (in a single ApplyUpdates
operation) deletes records in the detail+subdetail, and also insert
new records in detail+subdetail. In this case, to make the delete to work
properly, the order of the "ApplyUpdates" needs to be
subdetail -> detail -> master, but this makes the insert fail, since
the subdetail would be inserted before the detail (and we cant have
child without master).
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br
Master -> Detail -> Subdetail model?
My problem with this is when someone (in a single ApplyUpdates
operation) deletes records in the detail+subdetail, and also insert
new records in detail+subdetail. In this case, to make the delete to work
properly, the order of the "ApplyUpdates" needs to be
subdetail -> detail -> master, but this makes the insert fail, since
the subdetail would be inserted before the detail (and we cant have
child without master).
[]s
Carlos
http://www.firebirdnews.org
FireBase - http://www.FireBase.com.br