Run Object

Questions related to using nuBuilder Forte.

Run Object

Unread postby BDemeuse » Thu Jul 22, 2021 11:31 pm

Hi,

I have 2 environments: one for development (Mac) and a second one for the end-users (OVH internet server).
On both sides, I have a launch form with run objects (button) to start the browse&edit forms.
However, on the dev environment (Mac), it works fine but not on the "production" one.
I had imported the Env Dev -> Prod Dev and at this time, I had problems with the import of views that are solved now.
I though it was the reasons but not :-(
Any idea ?
I have deleted and tried to re-create on the prod environment bu I cannot select the form to execute, linked to the run object.
Below, the screenshots of both environments

Thanks,

Regards,

Bri
Attachments
Capture d’écran 2021-07-22 à 15.39.59.png
Capture d’écran 2021-07-22 à 15.39.59.png (261.21 KiB) Viewed 98 times
Capture d’écran 2021-07-22 à 15.38.52.png
Capture d’écran 2021-07-22 à 15.38.52.png (308.2 KiB) Viewed 98 times
BDemeuse
 
Posts: 20
Joined: Mon Apr 12, 2021 10:39 pm
nuBuilder Version: 4.5

Re: Run Object

Unread postby kev1n » Thu Jul 22, 2021 11:37 pm

Run these queries, log in again into nuBuilder and try again.

Code: Select all
-- --------------------------------------------------------

--
-- Structure for view `zzzzsys_object_list`
--
DROP TABLE IF EXISTS `zzzzsys_object_list`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_object_list`  AS   select `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` from `information_schema`.`tables` where `information_schema`.`tables`.`TABLE_SCHEMA` = database()  ;

-- --------------------------------------------------------

--
-- Structure for view `zzzzsys_report_data`
--
DROP TABLE IF EXISTS `zzzzsys_report_data`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `zzzzsys_report_data`  AS   select concat('PROCEDURE:',`zzzzsys_php`.`zzzzsys_php_id`) AS `id`,`zzzzsys_php`.`sph_code` AS `code`,`zzzzsys_php`.`sph_description` AS `description` from `zzzzsys_php` where `zzzzsys_php`.`sph_system` <> '1' and locate('#TABLE_ID#',`zzzzsys_php`.`sph_php`) > '0' union select concat('SQL:',`zzzzsys_select`.`zzzzsys_select_id`) AS `id`,'nuSQL' AS `code`,`zzzzsys_select`.`sse_description` AS `description` from `zzzzsys_select` where `zzzzsys_select`.`sse_system` is null or `zzzzsys_select`.`sse_system` = '' union select concat('TABLE:',`zzzzsys_object_list`.`zzzzsys_object_list_id`) AS `id`,'nuTABLE' AS `code`,`zzzzsys_object_list`.`zzzzsys_object_list_id` AS `description` from `zzzzsys_object_list`  ;

-- --------------------------------------------------------

--
-- Structure for view `zzzzsys_run_list`
--
DROP TABLE IF EXISTS `zzzzsys_run_list`;

CREATE ALGORITHM=UNDEFINED SQL SECURITY DEFINER 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`  ;
kev1n
nuBuilder Team
 
Posts: 2012
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Run Object

Unread postby BDemeuse » Fri Jul 23, 2021 12:18 am

Thanks. It works :D
BDemeuse
 
Posts: 20
Joined: Mon Apr 12, 2021 10:39 pm
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: No registered users and 16 guests

cron