New procedures not added to zzzzsys_run_list

[Henk_2a]

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`

[kev1n]

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...

[Henk_2a]

I restarted all over with a new version, problem solved

[admin]

.