Page 1 of 1
run object, form empty
Posted: Fri Oct 11, 2019 11:03 am
by Timo
Hey,
I've created several forms (browse, browseedit,edit type) and want to show one of them in an iframe (run button). Problem: no form appears in the "run form, report or procedure" dialog. What could be the reason?
runempty.PNG
Re: run object, form empty
Posted: Sat Oct 12, 2019 7:58 am
by kev1n
Make sure the zzzzsys_run_list view exists in your db. If it doesn't, create it in PhpMyAdmin:
Code: Select all
CREATE VIEW `zzzzsys_run_list` AS select `zzzzsys_form`.`zzzzsys_form_id` AS `id`,'Form' AS `run`,`zzzzsys_form`.`sfo_code` AS `code`,`zzzzsys_form`.`sfo_description` AS `description` from `zzzzsys_form` union select `zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`zzzzsys_report`.`sre_code` AS `code`,`zzzzsys_report`.`sre_description` AS `description` from `zzzzsys_report` union select `zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where (`zzzzsys_php`.`sph_system` <> 1) order by `code` ;
Re: run object, form empty
Posted: Thu Oct 17, 2019 5:48 pm
by Timo
Indeed, that fixed it!
Re: run object, form empty
Posted: Thu Oct 17, 2019 11:50 pm
by admin
.