Page 2 of 2
Re: Errors opening forms with IFRAME and GRID
Posted: Sat May 25, 2024 5:08 pm
by kknm
jur_data
Re: Errors opening forms with IFRAME and GRID
Posted: Sat May 25, 2024 5:39 pm
by 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";
Re: Errors opening forms with IFRAME and GRID
Posted: Sat May 25, 2024 6:55 pm
by kknm
I can't check right now...
So the SELECT field worked?
Re: Errors opening forms with IFRAME and GRID
Posted: Sun May 26, 2024 8:35 am
by kev1n
kknm wrote: ↑Sat May 25, 2024 6:55 pm
I can't check right now...
So the SELECT field worked?
Yes, it is showing values.
Re: Errors opening forms with IFRAME and GRID
Posted: Mon May 27, 2024 7:57 am
by 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.
Re: Errors opening forms with IFRAME and GRID
Posted: Mon May 27, 2024 8:18 am
by 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.