I've some questions:
1) On the case of the conh.dbf file I do an INSERT, so I don't need to lock anything, right? Don't should Hxtt take care of this and avoid any concurrency problem? If not, what I need to do?
2) Our logic is the following:
a) My HXTT system and Clipper's system get a number 'X' and search in CONH.DBF file to see if this number exists there, before insert it.
b) If the number is not in CONH.DBF it insert a new record into CONH.DBF. If it finds the number there, then it get another number 'X + 1' and try again.
What I think is happening is that my HXTT system inserts into CONH.DBF (and commit) and before all indexes get updated, the Clipper's process search for the number 'X' at CONH.DBF and (has the index is not updated yet) he can't find it. So, at the end, both processes inserts the same number 'X' into CONH.DBF...
Can it be really happening? What do you think that is the problem?
Thanks in advance
|