This topic is locked

Master Table Info Incomplete When Viewing Detail Records

10/9/2006 3:24:07 AM
PHPRunner General questions
M
MikeB941 author

3.1 Build 151
If your list page on your master table includes fields from other tables (other than the master table itself via an SQL join) when you click on the link down into the detail records and the Master Table Info is displayed at the top, ONLY the fields that came from the original master table itself are filled in - any of the other fields from the Master List page that may have come from other tables (via a join) are left blank.
Thanks for any help.
Take Care... Mike.

Alexey admin 10/9/2006

Mike,
I couldn't reproduce this bug.

Please zip and send to support@xlinesoft.com a full set of generated PHP files along with your database creation script. I'll find what's wrong with your project running it on my test box.

C
carlosll 10/13/2006

3.1 Build 151

If your list page on your master table includes fields from other tables (other than the master table itself via an SQL join) when you click on the link down into the detail records and the Master Table Info is displayed at the top, ONLY the fields that came from the original master table itself are filled in - any of the other fields from the Master List page that may have come from other tables (via a join) are left blank.
Thanks for any help.
Take Care... Mike.


Mike sorry for my poor english.
I think that the solution is to modificate the function GetFullFieldName (include/dbcommon.php). On return you need to change the name of the table.
When you change the sql query generated for PHPrunner adding tables by join when the aplication re-build, the name is table.field NOT tablejoin.field.
I had the same problem and now I can work without problems.