BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Deleting a modified detail record will hide detail records u

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Multi-Tier)
View previous topic :: View next topic  
Author Message
Mehrdad
Guest





PostPosted: Sun Mar 25, 2007 4:52 pm    Post subject: Deleting a modified detail record will hide detail records u Reply with quote



D7.01 (also in D6.02) - QC 43194

In a master/detail standard datasnap application, deleting a modified detail
record and applying updates, may hide the detail records from top of the
detail cds till the deleted row. This happens when an ErrorPacket is
produced by the provider (when deleting the detail record produces error and
needs to be reconciled in client).
The hidden detail records, will not be shown even by cancel updates or
open/close of detail cds (one should reopen the master cds to get his/her
detail records shown again).

Steps to Reproduce:
1. Construct a standard master-detail datasnap application (even can use
local connection for simplicity).
2. Have you RDBMS raise error when deleting detail record - e.g. by a delete
trigger. This simulates getting error upon deleting a detail record.
3. Have one master record and some detail records and apply updates.
4. Reopen the same CDSes, modify last detail record.
5. Delete the same detail record.
6. ApplyUpdates.
7. Booom!
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi Databases (Multi-Tier) All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.