Format Field as Currency

Questions related to using nuBuilder Forte.

Re: Format Field as Currency

Unread postby mrlizard » Fri Apr 16, 2021 4:56 am

I apologize but i'm still rather new to mysql and nubuilder, could to tell me how to do that?
mrlizard
 
Posts: 16
Joined: Fri Apr 16, 2021 12:57 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby kev1n » Fri Apr 16, 2021 4:59 am

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
kev1n
nuBuilder Team
 
Posts: 1697
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby mrlizard » Fri Apr 16, 2021 5:39 am

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.
Attachments
select_output.JPG
select_output.JPG (76.36 KiB) Viewed 61 times
mrlizard
 
Posts: 16
Joined: Fri Apr 16, 2021 12:57 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby kev1n » Fri Apr 16, 2021 5:49 am

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

kev1n
nuBuilder Team
 
Posts: 1697
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby mrlizard » Fri Apr 16, 2021 6:12 am

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?
Attachments
ss_browse.JPG
ss_browse.JPG (96.17 KiB) Viewed 58 times
mrlizard
 
Posts: 16
Joined: Fri Apr 16, 2021 12:57 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby kev1n » Fri Apr 16, 2021 6:18 am

A Browse Form uses separate settings. Open the form settings (CTRL+SHIFT-F) to change them.
kev1n
nuBuilder Team
 
Posts: 1697
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Format Field as Currency

Unread postby mrlizard » Fri Apr 16, 2021 6:26 am

Awesome, I found it. Thank you very much for your assistance.
mrlizard
 
Posts: 16
Joined: Fri Apr 16, 2021 12:57 am
nuBuilder Version: 4.5

Previous

Return to General

Who is online

Users browsing this forum: No registered users and 18 guests