PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WEBDEV 2024 → (WB 12 Eng) How is it possible (HF C/S)?
(WB 12 Eng) How is it possible (HF C/S)?
Iniciado por Friedman, jan., 28 2009 11:48 AM - Sem resposta
Publicado em janeiro, 28 2009 - 11:48 AM
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