|
| (WB 12 Eng) How is it possible (HF C/S)? |
| Iniciado por maildos, 28,ene. 2009 11:48 - No hay respuesta |
| |
| | | |
|
| |
| Publicado el 28,enero 2009 - 11:48 |
copy of post: http://forum.mysnip.de/read.php…
Hi,
I need your help!
I have three files, 2 Master and 1 with the relationship between them.
MasterA(0,n)->(1,1)/RelationAB(1,1)<-------------(0,n)/MasterB
(UK,AID)MA.Key..../(KD)MA.KEY............................/(UK,AID)MB.KEY
(KD)MA.Code......../(KD)MB.KEY
........................../(KD. add manually)MA.Code
........................../(UK,CK)MB.KEY,MA.KEY
........................../(UK,CK.add manually)MB.KEY,MA.Code
(UK) Unique Key
(AID) AutomaticID
(KD) Key with duplicates
(CK) Composite Key
Then I fill the values via application:
MasterA /MasterB /RelationAB
A1.........../B1........../A1
COD1......./............./B1
............................./COD1
............................/B1,A1
............................/B1,COD1
I have added manually MA.Code & CK MB.KEY,MA.Code because I can't permit the same relation of MasterB.Key with MasterA.Code value.
The question is Why is HF C/S taking as ok?:(when I add this record)
MasterA /MasterB /RelationAB
C1........./B1.........../C1
COD1..../................/B1
.........................../COD1
.........................../B1,C1
.........................../B1,COD1
B1,COD1 It's a duplicated Unique Key!!!
Regards
More data:
In all add operations I use HAdd, the process start with HTransactionStart and ends with HTransactionEnd.
Come on! Someone must know why this is happening and I think this a very important issue for newies like me, Don't you?
Regards |
| |
| |
| | | |
|
| | | | |
| | |
|