Hello everyone. I'm new to PHPRunner and I use version 5.3 build 7474.
I use a mysql database and I created (with mysql) a view that put together a lot of fields from many tables, especially to show them in the list page.
When I develop the add page, I use the "Before record added" event to call a custom stored procedure and all works fine if I do not fill some fields.
I have 3 fields as lookup tables (in "list page with search" mode) and if I set a value even for one of them, when I press the form "save" button, I can see (with firebugs) the window.dpObj is undefined error.
var ids=window.dpObj.dpParFromM['ids']...s=true;for(var i=0;i<ids.length;i++) - RunnerPages.js (row 94)
The structure of database about these fields is:
TABLE A {
id BIGINT(20),
other fields..
}
TABLE B {
id1 BIGINT(20), references table A (id)
separator VARCHAR(15),
id2 BIGINT(20), references table A (id)
}
My view takes the table A and apply 3 LEFT OUTHER JOIN (everyone to table <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=18034&image=1&table=forumtopics' class='bbc_emoticon' alt='B)' /> with differen alias (AS clause) to have the value of B.id2 for 3 different values of separator (and it works perfectly in list page).
The problem is only in the Add page when I try to fill these fields with the lookup in list page with search (the value of the hidden field is correct.
Now, I don't know how to have this fixed.
I don't know what the object window.dpObj does and why it is undefined only when 1 of these fields is filled.
Any idea about that?
Thanks in advance.
