This topic is locked

dependent dropdown broke on first row in table?

12/19/2005 6:06:57 PM
PHPRunner General questions
T
TheSaint author

Hi I tried dependent dropdowns as suggested to solve my need to search on 2 keys.
Seems to work great but on closer inspection the first row in the table when you bring up the form has the wrong lookup, it missed the dependency. In test mode in the designer, its correct. If you click edit on the broken first row, its correct, but returning back to the main page, wrong one again. Add mode looks ok too.
thanks - steve

Sergey Kornilov admin 12/20/2005

Hi,
it seems that you have incorrect data in your table. Please try to Edit and Save this row in PHPRunner-created app.
If this doesn't help please zip and send to support@xlinesoft.com the full set of generated PHP files along with your database creations script and the "broken" row data.

T
TheSaint author 12/20/2005

Thanks, I am looking to see if that is fesable, but this is part of a large group of tables with many thousands of rows, and its not easy to isolate a test case. We double checked the data within mysql and its correct. Here is a more accurate description of the problem, does this help?
On the first row of the table when we run the form, the dependent lookup wizard value is wrong. It missed the dependency, in other words without the dependecncy there are multiple values and it picked the wrong one.
In the designer, "test" is always correct.
If we click "view" its still wrong.
If we click "edit", its correct.
The difference seems to be that on the main view page, there is no drop down for the dependent column, just the value of course, so the dependent value somehow never got added to the query, so the query returned the wrong results.
I will see if its possible to create some simple test data that recreates the problem, but in summary when viewing data the dependency does not always get added to the query, resulting in wrong data being displayed.
Thanks - Steve

Hi,

it seems that you have incorrect data in your table. Please try to Edit and Save this row in PHPRunner-created app.
If this doesn't help please zip and send to support@xlinesoft.com the full set of generated PHP files along with your database creations script and the "broken" row data.

T
TheSaint author 12/20/2005

Hi,
I sent a short and clean test case demonstrating my problem.
Actually it doesn't seem to work in view mode at all.
Unless I completed don't understand how dependent lookups work, they don't seem to function in view mode, only add or edit.
Any suggestions are greatly appreciated.
Thanks - Steve