nuBuilder Forum

Posted: **Mon Feb 24, 2020 5:21 pm**

select `henkanl-5`.`zzzzsys_form`.`zzzzsys_form_id` AS `id`,'Form' AS `run`,`henkanl-5`.`zzzzsys_form`.`sfo_code` AS `code`,`henkanl-5`.`zzzzsys_form`.`sfo_description` AS `description` from `henkanl-5`.`zzzzsys_form` union select `henkanl-5`.`zzzzsys_report`.`zzzzsys_report_id` AS `id`,'Report' AS `run`,`henkanl-5`.`zzzzsys_report`.`sre_code` AS `code`,`henkanl-5`.`zzzzsys_report`.`sre_description` AS `description` from `henkanl-5`.`zzzzsys_report` union select `henkanl-5`.`zzzzsys_php`.`zzzzsys_php_id` AS `id`,'Procedure' AS `run`,`henkanl-5`.`zzzzsys_php`.`sph_code` AS `code`,`henkanl-5`.`zzzzsys_php`.`sph_description` AS `description` from `henkanl-5`.`zzzzsys_php` where (`henkanl-5`.`zzzzsys_php`.`sph_system` <> 1) order by `code`

Posted: **Mon Feb 24, 2020 5:36 pm**

The only difference is this:

diff.PNG

But this shouldn't make any difference.

I don't understand why

Code: Select all

SELECT * FROM zzzzsys_run_list WHERE code = 'trefwoord_rpt'

returns an empty result set...

Posted: **Mon Mar 02, 2020 9:15 pm**

I restarted all over with a new version, problem solved

Posted: **Mon Mar 02, 2020 11:51 pm**

nuBuilder Forum

New procedures not added to zzzzsys_run_list

Re: New procedures not added to zzzzsys_run_list

Re: New procedures not added to zzzzsys_run_list

Re: New procedures not added to zzzzsys_run_list

Re: New procedures not added to zzzzsys_run_list