I would like to inform you that my point of view, could be considered a bug in PHPRunner 6.0 (Buid 9334).
Connecting two tables (Table link properties). Indicating any number of "Link Fields".
For example:
Table1
cod integer - primary key
nom varchar
Table2
Indice Serial - primary key
name varchar
cod integer - foreign key reference to table 1
Multiple files are created:
tabla1_list.php
tabla2_list.php
tabla2_add.php
...
and others, but in this case just described interest me.
When loading tabla1_list.php, no problem. Displays the page and in each of the rows, displays icons, the link to the detail table (Table 2).
If in Table 1, there is a record whose code is 0 (zero), by clicking on the link on the detail page, this is that this variable is empty.
The value taken by the variable $ strSQL before loading the list is:
select index, name, code from Table 2 where index = x and name = 'ANY' and 1 = 0;
For clarity, see the file: listpage.php located at:
.... / programfiles / PHPRunner / source / classes
Search:
...
if (!empty ($ mvalue))
$ where. = GetFullFieldName ($ this-> detailKeysByM [$ i]). "=". $ mvalue;
else
$ where. = "1 = 0";
...
In this case, if $mvalue = 0, this class (ListPage) takes it as empty and generates with this unconscious "where".
Thanks
Mauricio Zea
