Errors opening forms with IFRAME and GRID

[kknm]

jur_data

[kev1n]

To get rid of the error, try changig this line:

from:

Code: Select all

$s = "SELECT `$f->primary_key` $f->from WHERE (`$R->sob_subform_foreign_key` = '$R->subform_fk') $w $f->order";

to:

Code: Select all

$s = "SELECT `$f->primary_key` $f->from WHERE (IFNULL(`$R->sob_subform_foreign_key`,'-1') = '$R->subform_fk') $w $f->order";

[kknm]

I can't check right now...
So the SELECT field worked?

[kev1n]

I can't check right now...
So the SELECT field worked?

Yes, it is showing values.

[kknm]

I checked - everything works correctly!!!
Thank you!

It’s just not clear why the SELECT field failed again. This is not the first time it has failed me.

[kev1n]

In my experience, if there is an error somewhere in the form, the select fields will not be populated, perhaps its SQL query will not be executed at all. However, I need to investigate why this is happening.