Change Log

2.5
12.01.09
11.12.29
11.12.20
11.11.03
11.09.28
11.09.19
11.03.21
11.02.18
10.12.03
10.09.03
10.07.12
18-Feb-2010 (r93)
15-Feb-2010 (r88)

Current Changes

Build Number 2.5

Code Base Changes

Single window navigation is now possible.

In this and future releases Single Window Navigation will be the default.
For nuBuilder applications currently in production to change to Single Window Navigation,
"Single Window Navigation" must be set to Yes in System Setup
(And you will need to log right out and back in again to get it working properly.)

The javascript function nuSubformRowArray() can take a second parameter "pJustUnticked" handy for dealing with only subform rows that will be saved.

nuSubformRowArray() is now also a php function that can be used in the same way to navigate a subform's $_POST variables in places like "After Save" on Forms.

Form Objects can now be moved and reordered via the "Reorder Form Objects" tab of a Form's Properties

Schema Changes

update zzsys_object set sys_setup = '1' WHERE zzsys_object_id IN ('14d829a1e5dfd0','14d82bcb3b3f36');

update zzsys_object set sys_setup = '1' WHERE sob_all_tab_title = 'Browse' AND sob_zzsys_form_id = 'form';

update zzsys_form set sys_setup = '1' WHERE zzsys_form_id IN ("14cad243c2d9ef","14c8dc4aec9b4f");

update zzsys_object set sys_setup = '1' WHERE sob_zzsys_form_id IN ("14cad243c2d9ef","14c8dc4aec9b4f");

REPLACE INTO `zzsys_browse` (`zzsys_browse_id`, `sbr_zzsys_form_id`, `sbr_title`, `sbr_display`, `sbr_align`, `sbr_format`, `sbr_searchable`, `sbr_sort`, `sbr_sortable`, `sbr_visible`, `sbr_order`, `sbr_width`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES
('145add9f11bdc8', 'object', 'S', 'CONCAT('''')', 'l', '', '0', 'sys_changed', '1', '1', 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '');

INSERT INTO `zzsys_object` (`zzsys_object_id`, `sob_zzsys_form_id`, `sob_all_access_key`, `sob_all_admin_only`, `sob_all_class`, `sob_all_clone`, `sob_all_column_number`, `sob_all_display_condition`, `sob_all_name`, `sob_all_sql_run_before_display`, `sob_all_start_cursor`, `sob_all_on_blur`, `sob_all_on_change`, `sob_all_on_double_click`, `sob_all_on_focus`, `sob_all_on_key_press`, `sob_all_tool_tip`, `sob_all_order_number`, `sob_all_tab_number`, `sob_all_tab_title`, `sob_all_title`, `sob_all_type`, `sob_all_comment`, `sob_button_admin_only`, `sob_button_display_condition`, `sob_button_left`, `sob_button_length`, `sob_button_top`, `sob_button_skip_browse_record_id`, `sob_button_zzsys_form_id`, `sob_button_image_on_mouse_up`, `sob_button_image_on_mouse_down`, `sob_display_align`, `sob_button_browse_filter`, `sob_display_format`, `sob_display_length`, `sob_display_sql`, `sob_dropdown_default_value_sql`, `sob_dropdown_length`, `sob_dropdown_no_blanks`, `sob_dropdown_no_duplicates`, `sob_dropdown_read_only`, `sob_dropdown_sql`, `sob_graph_sql`, `sob_graph_zzsys_graph_id`, `sob_graph_query_string`, `sob_graph_code`, `sob_hidden_default_value`, `sob_html_code`, `sob_inarray_default_value_sql`, `sob_inarray_length`, `sob_inarray_no_blanks`, `sob_inarray_no_duplicates`, `sob_inarray_read_only`, `sob_inarray_sql`, `sob_listbox_height`, `sob_listbox_length`, `sob_listbox_button_style`, `sob_listbox_sql`, `sob_lookup_button_length`, `sob_lookup_code_class`, `sob_lookup_code_field`, `sob_lookup_code_length`, `sob_lookup_default_value_sql`, `sob_lookup_description_class`, `sob_lookup_description_field`, `sob_lookup_description_length`, `sob_lookup_sql`, `sob_lookup_load_zzsysform_id`, `sob_lookup_zzsysform_id`, `sob_lookup_id_field`, `sob_lookup_javascript`, `sob_lookup_no_blanks`, `sob_lookup_no_description`, `sob_lookup_no_duplicates`, `sob_lookup_read_only`, `sob_lookup_autocomplete`, `sob_password_length`, `sob_password_no_blanks`, `sob_subform_blank_rows`, `sob_subform_delete_box`, `sob_subform_foreign_key`, `sob_subform_height`, `sob_subform_left`, `sob_subform_primary_key`, `sob_subform_read_only`, `sob_subform_selected_row_color`, `sob_subform_sql`, `sob_subform_table`, `sob_subform_title_height`, `sob_subform_top`, `sob_subform_width`, `sob_subform_odd_background_color`, `sob_subform_even_background_color`, `sob_text_align`, `sob_text_date_button_length`, `sob_text_default_value_sql`, `sob_text_format`, `sob_text_length`, `sob_text_mask`, `sob_text_no_blanks`, `sob_text_no_duplicates`, `sob_text_password`, `sob_text_read_only`, `sob_text_total`, `sob_textarea_height`, `sob_textarea_default_value_sql`, `sob_textarea_length`, `sob_textarea_no_blanks`, `sob_textarea_read_only`, `sob_words_length`, `sys_setup`, `sys_added`, `sys_changed`, `sys_user_id`) VALUES
('14f3852d29db17', 'form', NULL, NULL, NULL, '0', 10, NULL, 'object_subform', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 10, 200, 'Reorder Form Objects', 'Objects', 'subform', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '1', 'sob_zzsys_form_id', 30, 50, 'zzsys_object_id', NULL, NULL, 'SELECT * FROM zzsys_object WHERE sob_zzsys_form_id = ''#id#'' \r\nORDER BY \r\nsob_all_tab_number, \r\nsob_all_column_number, \r\nsob_all_order_number', 'zzsys_object', 2, 50, 1000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '0000-00-00 00:00:00', '2012-02-14 09:07:19', 'globeadmin'),
('14f3852d29e774', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_title', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 35, 20, 'Subform', 'Title', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'l', NULL, '', NULL, 15.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:42:36', 'globeadmin'),
('14f3852d29e0d9', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_name', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 30, 20, 'Subform', 'Name', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'l', NULL, NULL, NULL, 15.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:42:19', 'globeadmin'),
('14f3852d29df28', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_column_number', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 80, 20, 'Subform', 'Col', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'r', NULL, NULL, '0', 3.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:41:50', 'globeadmin'),
('14f3852d29e41e', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_tab_number', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 70, 20, 'Subform', 'Tab', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'r', NULL, NULL, '0', 3.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:41:06', 'globeadmin'),
('14f3852d29e282', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_order_number', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 90, 20, 'Subform', 'Ord', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'r', NULL, NULL, '0', 3.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:40:44', 'globeadmin'),
('14f3852d29e5b9', '14f3852d29db17', NULL, NULL, NULL, '1', 10, NULL, 'sob_all_tab_title', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 60, 20, 'Subform', 'Tab Title', 'text', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'l', NULL, NULL, NULL, 10.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, '2012-02-13 10:36:05', 'globeadmin');

ALTER TABLE `zzsys_setup` ADD `set_single_window` VARCHAR( 1) NOT NULL ;

INSERT INTO `zzsys_style` (`zzsys_style_id`, `sst_class`, `sst_description`, `sst_custom`) VALUES
('14f14e1a6560df', '.nuBreadCrumb', 'Breadcrumb navigation properties', '1');

INSERT INTO `zzsys_style_property` (`zzsys_style_property_id`, `ssp_property_name`, `ssp_property_value`, `ssp_zzsys_style_id`) VALUES
('14f14e1a659e7a', 'top', '54px', '14f14e1a6560df'),
('14f14e1a65b952', 'left', '11px', '14f14e1a6560df'),
('14f14e2addb210', 'color', 'grey', '14f14e1a6560df'),
('14f14e2ed995e6', 'font-size', '12px', '14f14e1a6560df');