Page 1 of 2
New procedures not added to zzzzsys_run_list
Posted: Sun Feb 23, 2020 9:58 pm
by Henk_2a
Hello all,
I have several applications with nubuilder, and a few weeks ago I started a new one.
This time my procedures do not appear in the run_list and when I look in the database it shows that new procedures are not added to the view zzzzsys_run_list.
This is new to me, I can't find any suggestions in this forum, any idea how to solve this?
Thanks for your help
Re: New procedures not added to zzzzsys_run_list
Posted: Sun Feb 23, 2020 11:19 pm
by kev1n
Do you get an error message when you add a new procedure? Also check the output in the developer console (F12)
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 2:44 pm
by Henk_2a
No errors, I can run the new procedure by the button "Run Procedure" in the main form without problems.
But I cannot run the procedure by an selfmade button since the name of the procedure does not appear in the listbox.
run proc.jpg
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 3:18 pm
by kev1n
Could you run a select on the database and post the output?
Code: Select all
SELECT * FROM `zzzzsys_php` WHERE `sph_code` = 'nuuser_BS' --- replace with your procedure code
It should look like this:
2020-02-24_151505.png
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 3:27 pm
by Henk_2a
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 3:38 pm
by kev1n
And please also an output of this query:
Code: Select all
SELECT * FROM zzzzsys_run_list WHERE code = 'trefwoord_rpt'
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 3:56 pm
by Henk_2a
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 4:09 pm
by kev1n
Can you paste the SQL of the view zzzzsys_run_list ?
edit_view.png
Mine looks like this:
Code: Select all
select `nubuilder4`.`zzzzsys_form`.`zzzzsys_form_id` AS `id`,'Form' AS `run`,`nubuilder4`.`zzzzsys_form`.`sfo_code` AS `code`,`nubuilder4`.`zzzzsys_form`.`sfo_description` AS `description` from `nubuilder4`.`zzzzsys_form` union select `nubuilder4`.`zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`nubuilder4`.`zzzzsys_report`.`sre_code` AS `code`,`nubuilder4`.`zzzzsys_report`.`sre_description` AS `description` from `nubuilder4`.`zzzzsys_report` union select `nubuilder4`.`zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`nubuilder4`.`zzzzsys_php`.`sph_code` AS `code`,`nubuilder4`.`zzzzsys_php`.`sph_description` AS `description` from `nubuilder4`.`zzzzsys_php` where `nubuilder4`.`zzzzsys_php`.`sph_system` <> 1 order by `code`
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 4:23 pm
by Henk_2a
Mine looks very much the same
=
run proc.jpg
Re: New procedures not added to zzzzsys_run_list
Posted: Mon Feb 24, 2020 5:11 pm
by kev1n
Anyway, can you paste it as text? It's easier to compare.