[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

Mark as Solved Mark as not solved

4 replies


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.

4 replies

Mark as Solved Reply