Welcome! Log In Create A New Profile

Advanced

(WB 12 Eng) How is it possible (HF C/S)?

Posted by Jaime Fernandez 
Jaime Fernandez
(WB 12 Eng) How is it possible (HF C/S)?
January 24, 2009 01:02AM
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?:
MasterA /MasterB /RelationAB
C1........./B1.........../C1
COD1.../................/B1
............................../COD1
............................../B1,C1
............................../B1,COD1

B1,COD1 It's a duplicated Unique Key!!!

Regards
Jaime Fernandez
Re: (WB 12 Eng) How is it possible (HF C/S)?
January 25, 2009 01:57PM
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
Jaime Fernandez
Re: (WB 12 Eng) How is it possible (HF C/S)?
January 29, 2009 10:37AM
Hi again,
Thread Close.
I think was an error or bug related with generation of the analisys that made possible to add a duplicated value for a unique key.
Now it is working OK.
Regards
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: