I suppose you think about a DEFINE.DF based on the key structure ! That can be a solution...
Manu > -----Message d'origine----- > De : [email protected] [mailto:u2-users- > [email protected]] De la part de Brian Leach > Envoyé : mercredi 29 juillet 2009 16:35 > À : [email protected] > Objet : Re: [U2] [UV]recurring database, indexing and deadlatch errors > > Hi Manu > > It is a good question... > > What do the record keys look like, and how many records are there? > > Brian > > > -----Original Message----- > > From: [email protected] > > [mailto:[email protected]] On Behalf Of > > Manu Fernandes > > Sent: 29 July 2009 13:54 > > To: U2 Users List > > Subject: [U2] [UV]recurring database, indexing and deadlatch errors > > > > > > Hello U2 group, > > > > Probably a good question. > > > > We define a < recurring > file. > > Attribute<1> refer to a record in the same file (pointer to > > a parent record). > > We have a I-Type SUBR which return the "root" key/item of a > > current item (read the parent until parent = @NULL ) > > > > Then we create a index with this I-type to retrieve easily > > the items childs of a "root-id". > > > > All work fine ... > > except when the root-item is stored on the same FileGroup of > > the child-item. > > (at TCL, *RECORD file root-id* return the same value then *RECORD file > > child-id*) > > > > If this occurs, at the write step (save a child record) into > > the SUBR called by indices processing, we get a "Self > > deadlatch error" and return to TCL. > > This occurs because we are in a "write" which is a internal > > "transaction with isolation level 0" and we try to read a > > record already in the isolation..... > > > > Do you have any idea to solve it ? > > Thanks by advance. > > Manu > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
