Format Field as Currency

[mrlizard]

I apologize but i'm still rather new to mysql and nubuilder, could to tell me how to do that?

[kev1n]

Sure, use phpMyAdmin to export your DB into an sql-file. Zip it and upload it here or send it via private message.

https://help.dreamhost.com/hc/en-us/art ... e-or-table

[mrlizard]

Unfortunately the forum website will not let me upload the zip file.

On another note I decided to run the query that its supposed to be running on the server using mysql and the user that I nuBuilder is using to authenticate. This is the output.

[kev1n]

For some reason, the views have not been created in your database.

Run these 3 queries (e.g. in phpMyAdmin). This should fix it

Code: Select all

CREATE 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() ;

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

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

[mrlizard]

Great thank you! That got it to show the options. But when i put in a value, it still shows as "123.4500" on the Browse screen. Is that normal?

[kev1n]

A Browse Form uses separate settings. Open the form settings (CTRL+SHIFT-F) to change them.

[mrlizard]

Awesome, I found it. Thank you very much for your assistance.