Conditions to procedure be choosed

[Giu]

There is something driving me crazy.

I'm building a Launch Form to use it as a GUEST contact form to embed on a website. I added 3 fields and now I want to add a Run button to call a procedure and create the record in database.

My issue is the procedure don't appears in the list. I compared to other procedure I created yesterday, and is configured the same way, but one appears, and other not.

The 2 procs.

2024-05-17_15-17.png

2024-05-17_15-17_1.png

Now I go to my form. Add a Run object, and when try to choose my procedure.

2024-05-17_15-19.png

I tried seting the form where should be launched in the procedure, permissiosn, set it as global access...nothing, don't appears. Probably is something silly, but I don't see it.

[kev1n]

The procedure picker form uses the view zzzzsys_run_list. Make sure there is a view called "zzzzsys_run_list" and not a table.

Run this SQL on your DB:

Code: Select all

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`  ;

[Giu]

Oh, if it's a view im sure doesn't exists. Import gave me problems with views. Where is hosted seems doesn't support it, but I readed nubuilder detects and create a table instead.

[kev1n]

If you log out and log in again, this table should be updated.

[Giu]

Uhmm, I think I did it, but will try when come back to computer, thanks.

[kev1n]

Or delete that table first.

[Giu]

I think it worked but once I deleted the table. Will investigate if table is not repopulated or what. Thanks