2. PHPRunner General questions
  3. [SOLVED]   WHEN I ADD 1 REGISTER PHPRunner STORE 4 TIMES THE SAME
This topic is locked
[SOLVED]

  WHEN I ADD 1 REGISTER PHPRunner STORE 4 TIMES THE SAME

 		7/14/2008 20:06:26
PHPRunner General questions
A
 Aleix author

Hello and thanks in advance.
I have PHPRunner 4.2 Build 379
I have the Tables:
Table1 Fac Table2 Cia Table3 Sede

Master Slave1 Slave2
I choose the data with Loo up wizard - Look table
From Table2 Cia I choose the CiaName in this way

[indent][/indent]Table: Table 2 Cia

[indent][/indent]Link field: IdCia

[indent][/indent]Dispy field:

[indent][/indent]where:

The Test it Boton work fine!
From Table3 I choose the CiaSede

[indent][/indent]Table: Table 3 Sede

[indent][/indent]Link field: IdCiaSede

[indent][/indent]Dispy field: concat(ViaNombre," - ",ViaNum," ",CP," - ", Poblacion) 4Field´s ! (If change a 3 field´s, It is stored 4 times too!)

[indent][/indent]where: "((IdRSedeTipo ='1') or (IdRSedeTipo ='3'))"
[indent][/indent]CategoryControl: IdRCia From table1 Fac - Master

[indent][/indent]CategoryField: IdRCia From table3 Sede- Slave2

The Test it Boton work fine!
Then all works ok, I can see the ok information, I can choose and store the field´s of the ONE register. But when you came back to the list, I have the same register stored 4 times!
Some one Know why is it? Wich is my mistake? I am lost!
Many Thanks
S
 		swanside 7/15/2008

Hello and thanks in advance.

I have PHPRunner 4.2 Build 379
I have the Tables:
Table1 Fac Table2 Cia Table3 Sede

Master Slave1 Slave2
I choose the data with Loo up wizard - Look table
From Table2 Cia I choose the CiaName in this way

[indent][/indent]Table: Table 2 Cia

[indent][/indent]Link field: IdCia

[indent][/indent]Dispy field:

[indent][/indent]where:

The Test it Boton work fine!
From Table3 I choose the CiaSede

[indent][/indent]Table: Table 3 Sede

[indent][/indent]Link field: IdCiaSede

[indent][/indent]Dispy field: concat(ViaNombre," - ",ViaNum," ",CP," - ", Poblacion) 4Field´s ! (If change a 3 field´s, It is stored 4 times too!)

[indent][/indent]where: "((IdRSedeTipo ='1') or (IdRSedeTipo ='3'))"
[indent][/indent]CategoryControl: IdRCia From table1 Fac - Master

[indent][/indent]CategoryField: IdRCia From table3 Sede- Slave2

The Test it Boton work fine!
Then all works ok, I can see the ok information, I can choose and store the field´s of the ONE register. But when you came back to the list, I have the same register stored 4 times!
Some one Know why is it? Wich is my mistake? I am lost!
Many Thanks


Try to alter your KEY_ID field.

On the choose pages in PHPRunner I think its about the third page in you will see a selected Key colums. Set this to a unique field in the colume.
If I had a table with 3 fields in it like name, age, present year and had the following info in it
name = joe smith, joe brown joe grey

age = 23, 34, 32

present year is 2008, 2008, 2008
If I set me key coloum to present year, it will alter the data for the three names where if I set my key colum to the name it will only alter the data for that one field.
Otherwise, post your sql code so we can have a look at it.
J
 		Jane 7/15/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
A
 		Aleix author 7/15/2008

Many Thanks Swanside and Jane;
With your orientation Swanside I solved. The mistake are:
1 .- double KEY_ID field

2.- QUERY with a bad relation.
I don´t understand why store four times the same register, but I change the KEY_ID and the QUERY and now it is working ok.
Thanks Jane and Swanside
Best Regards
Fixed
S
 		swanside 7/16/2008

Many Thanks Swanside and Jane;

With your orientation Swanside I solved. The mistake are:
1 .- double KEY_ID field

2.- QUERY with a bad relation.
I don´t understand why store four times the same register, but I change the KEY_ID and the QUERY and now it is working ok.
Thanks Jane and Swanside
Best Regards
Fixed


Good one. Its good to just play around to see what effects different things have.