2. PHPRunner General questions
  3. All records altered when editing single inline field
This topic is locked

All records altered when editing single inline field

 		3/20/2009 1:18:27 AM
PHPRunner General questions
R
 Rodj_aus author

Hi,

PHP Runner 5.0

I have a Master-Detail layout. On the master and detail forms I have an inline edit for one field and no Edit page.

The Master page works fine but when I edit the single inline field (an integer) on the detail form in any record and then refresh the page I find that all records now have that field set to that value. I have rebuilt the page and it is still the same.

I downloaded and tried 5.1 and still the same (although it did trash my layouts and I had to redesign in the Visual Editor from scratch even though I hadn't saved).
I removed all events I had inserted but still the same.
Has anyone else had this problem?
Thanks

Rod
J
 		Jane 3/20/2009

Rod,
this error usually happens if you've selected not unique field as primary key on the Choose pages tab.

Check your primary keys more carefully.
If it doesn't help publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.
R
 		Rodj_aus author 3/22/2009

Rod,

this error usually happens if you've selected not unique field as primary key on the Choose pages tab.

Check your primary keys more carefully.
If it doesn't help publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with instructions on reproducing this error.



Thanks Jane,

I removed the Master/Detail link and rebuilt the project then reinserted the link and now all seems to work OK. I am not sure why the problem occurred but maybe some errant SQL somewhere.
I am using an auto increment integer field as the key field in both the master and detail tables so it shouldn't happen.
regards

Rod