Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Question about cloning forms

Questions related to customising nuBuilder Forte with JavaScript or PHP.
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

If you just use a cloner to clone the form.
The original form is -fro.
The cloner shows that it created the form fro_clone_1
All sections are present, but the fro_clone_1 form does not appear in the forms.
*************************************************
-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 01:44:11 PM
-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit
-- zzzzsys_form: fro_clone_1
*************************************
sections:
-- zzzzsys_tab
-- zzzzsys_select
-- zzzzsys_select_clause
-- zzzzsys_browse
-- zzzzsys_php
-- zzzzsys_object
*********************************************
All sections are filled - INSERT INTO ...
I can't take a screenshot because... it's bigger than the screen.
kev1n
nuBuilder Team
Posts: 4428
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 475 times
Contact:

Re: Question about cloning forms

Unread post by kev1n »

kev1n wrote: Fri Mar 15, 2024 11:08 am zzzzsys_object doesn't contain the form code, just the form id.
Example: nunotes_clone_1 appears just one, it's just in the zzzzsys_form table, and not in the objects table.
What changes it the form id (here 65f43103340166b), which can also be found in zzzzsys_object.

In your case, if you want to change the table name, just replace it everywhere where it occurs before executing the query:

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 12:29:07 PM

-- Form Description: Notes
-- Form Code: nunotes
-- Form Table: zzzzsys_note
-- Form Type: browseedit


--
-- zzzzsys_form: nunotes_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 
VALUES ( '65f43103340166b', 'browseedit', 'nunotes_clone_1', 'Notes', NULL, '#not_title#|New', 'zzzzsys_note', 'zzzzsys_note_id', '', '0', '0', '0', NULL, 'SELECT\n    zzzzsys_note.*, noc_name\nFROM\n    zzzzsys_note\nLEFT JOIN zzzzsys_note_category ON not_zzzzsys_note_category_id = zzzzsys_note_category.zzzzsys_note_category_id\nORDER BY\n    not_title ASC', NULL, NULL, 'nuHide(\'label_not_title\');\nnuSetPlaceholder(\'not_title\', nuTranslate(\'Title\'));\n\nnuHide(\'label_not_zzzzsys_note_category_id\');\nnuSetPlaceholder(\'not_zzzzsys_note_category_idcode\', nuTranslate(\'Category\'));\n\nhandleKeys();\n\nfunction handleKeys() {\n\n    $(\'#not_title\').on(\'keydown\', function(evt) {\n      if (evt.key === \'Enter\') {\n        evt.preventDefault();        \n\n        $(\'.ql-editor\').trigger(\"focus\");\n\n        let tinyB = tinyMCE.get(\'not_content_container\').getBody();\n        if (tinyB !== null) tinyB.trigger(\"focus\");\n\n      }\n    });\n\n}\n\n', '', '', NULL ); 

--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 
VALUES ( '65f43103344ed94', '65f43103340166b', 'Notes', '10', '', NULL, NULL ); 

--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f431033484f7c', '65f43103340166b', 'Notes', 'not_title', 'l', '', '20', '720', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f4310334867f9', '65f43103340166b', 'Category', 'noc_name', 'l', '', '10', '150', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f43103348714d', '65f43103340166b', 'Updated on', 'not_updated_on', 'l', '', '30', '145', NULL ); 

--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f4310334c49a8', '65f43103340166b', 'zzzzsys_note', 'input', 'not_title', 'Title', '65f43103344ed94', '10', '26', '26', '601', '24', '0', 'left', '3', '0', '', '0', 'CSS', 'color: maroon; padding-left: 8; font-weight: bold; font-size: 15px', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', NULL, 'text', NULL, NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f4310334cacbe', '65f43103340166b', 'zzzzsys_note', 'input', 'not_updated_on', 'Updated on', '65f43103344ed94', '40', '26', '1056', '130', '22', '0', 'left', '0', '1', '', '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', NULL, '', '', NULL, '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f4310334cdc68', '65f43103340166b', 'zzzzsys_note', 'editor', 'not_content', 'Content', '65f43103344ed94', '30', '65', '26', '1167', '460', '1', 'left', '0', '0', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '0', NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', NULL, '', '', NULL, NULL, NULL, '0', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f4310334d0e20', '65f43103340166b', 'zzzzsys_note', 'lookup', 'not_zzzzsys_note_category_id', 'Category', '65f43103344ed94', '20', '26', '648', '214', '24', '0', 'left', '0', '0', NULL, '0', NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'noc_name', 'noc_name', '0', NULL, 'nunotescategroy', '', NULL, 'zzzzsys_note_category', '', '', '', '', '', '', '0', '', '', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

The fact of the matter is that a new form does not appear in zzzzsys_form when using the cloner.
PHP7.7.33
Server version: 5.7.42-0ubuntu0.18.04.1 - (Ubuntu)
*******************************

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 02:37:22 PM

-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit


--
-- zzzzsys_form: fro_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 
VALUES ( '65f432f2e016571', 'browseedit', 'fro_clone_1', 'ДСЗ 1 - Отсев', NULL, NULL, 'frots', 'frots_id', NULL, NULL, '30', '0', NULL, 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', 'if (nuFormType() == \'browse\') {\n    //increaseBrowseTitleHeight();\n    $(\'[data-nu-column=\"3\"]\').each(function(index) {\n        var color = Number($(this).html()) > 2 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n    $(\'[data-nu-column=\"4\"]\').each(function(index) {\n        var color = Number($(this).html()) > 12 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n}\n\nnuStopBrowserResize();', NULL, NULL, NULL, NULL, NULL ); 

--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 
VALUES ( '65f432f2e04372b', '65f432f2e016571', 'Main', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 
VALUES ( '65f432f2e016571_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc15885415473941001\",\"position\":{\"top\":25.000001907348633,\"left\":21.99652862548828},\"tablename\":\"frots\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false]},{\"id\":\"boxc15885415526271002\",\"position\":{\"top\":22.986112594604492,\"left\":235.00001525878906},\"tablename\":\"tabel\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false]}],\"joins\":{\"field_1_boxc15885415473941001--field_0_boxc15885415526271002\":\"\"}}', 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', NULL, '1' ); 

--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 
VALUES ( '65f432f2e075820', '65f432f2e016571_BR', '3', 'frots_id', NULL, 'DESC', NULL, NULL ); 

--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e091d56', '65f432f2e016571', 'Дата', 'DATE_FORMAT(tab_data, \"%d.%m.%Y %H:%i\")', 'l', '', '10', '120', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e094182', '65f432f2e016571', 'Время', 'fro_vrem', 'l', '', '20', '50', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e095179', '65f432f2e016571', 'Питатели', 'fro_pit', 'l', '', '30', '70', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e096f75', '65f432f2e016571', '10<br>(2)', 'fro_10', 'l', '', '40', '30', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e097e7c', '65f432f2e016571', '5<br>(12)', 'fro_5', 'l', '', '50', '30', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e098c16', '65f432f2e016571', 'Соотв', 'REPLACE(REPLACE(fro_soot,1,\'✔\'),0,\'\')', 'l', '', '60', '40', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e099ae8', '65f432f2e016571', 'd', 'tab_data', 'l', NULL, '70', '0', NULL ); 

--
-- zzzzsys_php
--

INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 
VALUES ( '65f432f2e016571_BB', '65f432f2e016571_BB', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 
INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 
VALUES ( '65f432f2e016571_BE', '65f432f2e016571_BE', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 

--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0eec8c', '65f432f2e016571', 'frots', 'lookup', 'fro_data', 'Дата начала смены', '65f432f2e04372b', '10', '10', '150', '180', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'tab_data', 'tab_data', '0', '', '5e8a26a53ce5f49', '', '', 'tabel', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'datetime-local', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0f1d64', '65f432f2e016571', 'frots', 'input', 'fro_vrem', 'Время', '65f432f2e04372b', '20', '40', '235', '95', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'time', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0fcdab', '65f432f2e016571', 'frots', 'input', 'fro_pit', 'Питатели', '65f432f2e04372b', '30', '70', '210', '120', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0fea99', '65f432f2e016571', 'frots', 'input', 'fro_10', '10 (2)', '65f432f2e04372b', '40', '100', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e1010fd', '65f432f2e016571', 'frots', 'input', 'fro_5', '5 (12)', '65f432f2e04372b', '50', '130', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e103730', '65f432f2e016571', 'frots', 'input', 'fro_soot', 'Соотв', '65f432f2e04372b', '60', '160', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'checkbox', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
kev1n
nuBuilder Team
Posts: 4428
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 475 times
Contact:

Re: Question about cloning forms

Unread post by kev1n »

Did you run the SQL in e.g. phpMyAdmin? Then all rows will be inserted into the DB tables if there is no error.
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

It was in phpMyAdmin that I looked for records and took a screenshot of the tables in zzzzsys_form and zzzzsys_object
kev1n
nuBuilder Team
Posts: 4428
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 475 times
Contact:

Re: Question about cloning forms

Unread post by kev1n »

kev1n wrote: Fri Mar 15, 2024 1:07 pm Did you run the SQL in e.g. phpMyAdmin? Then all rows will be inserted into the DB tables if there is no error.
Did you successfully execute the query? And then, can the new form be found in zzzzsys_form ?
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

I showed a screenshot of the fully completed cloning procedure above. The new form does not appear in zzzzsys_form.

If you simply clone the form from the original form, then it appears, but without the Edit fields in zzzzsys_form .
If you then clone with a cloner with the rewrite checkbox in a new form, then after completing the procedure it writes only to the ---zzzzsys_object - REPLACE INTO... section, but the EDIT fields do not appear on the new form.
kev1n
nuBuilder Team
Posts: 4428
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 74 times
Been thanked: 475 times
Contact:

Re: Question about cloning forms

Unread post by kev1n »

I run your query in phpMyAdmin and saw your form right away under forms.
kknm wrote: Fri Mar 15, 2024 12:40 pm The fact of the matter is that a new form does not appear in zzzzsys_form when using the cloner.
PHP7.7.33
Server version: 5.7.42-0ubuntu0.18.04.1 - (Ubuntu)
*******************************

Code: Select all

-- nuBuilder cloner SQL Dump
-- Version 1.21
-- Generation Time: March 15, 2024 02:37:22 PM

-- Form Description: ДСЗ 1 - Отсев
-- Form Code: fro
-- Form Table: frots
-- Form Type: browseedit


--
-- zzzzsys_form: fro_clone_1
--

INSERT INTO zzzzsys_form (zzzzsys_form_id, sfo_type, sfo_code, sfo_description, sfo_group, sfo_breadcrumb_title, sfo_table, sfo_primary_key, sfo_browse_redirect_form_id, sfo_browse_row_height, sfo_browse_rows_per_page, sfo_browse_title_multiline, sfo_browse_autoresize_columns, sfo_browse_sql, sfo_javascript, sfo_browse_javascript, sfo_edit_javascript, sfo_style, sfo_mobile_view, sfo_json) 
VALUES ( '65f432f2e016571', 'browseedit', 'fro_clone_1', 'ДСЗ 1 - Отсев', NULL, NULL, 'frots', 'frots_id', NULL, NULL, '30', '0', NULL, 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', 'if (nuFormType() == \'browse\') {\n    //increaseBrowseTitleHeight();\n    $(\'[data-nu-column=\"3\"]\').each(function(index) {\n        var color = Number($(this).html()) > 2 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n    $(\'[data-nu-column=\"4\"]\').each(function(index) {\n        var color = Number($(this).html()) > 12 ? \'red\': \'black\';\n        $(this).css(\"color\", color);\n    });\n}\n\nnuStopBrowserResize();', NULL, NULL, NULL, NULL, NULL ); 

--
-- zzzzsys_tab
--

INSERT INTO zzzzsys_tab (zzzzsys_tab_id, syt_zzzzsys_form_id, syt_title, syt_order, syt_help, syt_access, syt_json) 
VALUES ( '65f432f2e04372b', '65f432f2e016571', 'Main', '10', NULL, NULL, NULL ); 

--
-- zzzzsys_select
--

INSERT INTO zzzzsys_select (zzzzsys_select_id, sse_code, sse_description, sse_json, sse_sql, sse_edit, sse_system) 
VALUES ( '65f432f2e016571_BR', NULL, NULL, '{\"tables\":[{\"id\":\"boxc15885415473941001\",\"position\":{\"top\":25.000001907348633,\"left\":21.99652862548828},\"tablename\":\"frots\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false,false,false]},{\"id\":\"boxc15885415526271002\",\"position\":{\"top\":22.986112594604492,\"left\":235.00001525878906},\"tablename\":\"tabel\",\"alias\":\"\",\"checkall\":true,\"checkboxes\":[false,false,false,false,false]}],\"joins\":{\"field_1_boxc15885415473941001--field_0_boxc15885415526271002\":\"\"}}', 'SELECT\n    frots.*,\n    tabel.*\n\nFROM\n    frots\n        JOIN tabel ON frots.fro_data = tabel.tabel_id\nORDER BY\n    frots_id DESC\n\n', NULL, '1' ); 

--
-- zzzzsys_select_clause
--

INSERT INTO zzzzsys_select_clause (zzzzsys_select_clause_id, ssc_zzzzsys_select_id, ssc_type, ssc_field, ssc_clause, ssc_sort, ssc_order, ssc_json) 
VALUES ( '65f432f2e075820', '65f432f2e016571_BR', '3', 'frots_id', NULL, 'DESC', NULL, NULL ); 

--
-- zzzzsys_browse
--

INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e091d56', '65f432f2e016571', 'Дата', 'DATE_FORMAT(tab_data, \"%d.%m.%Y %H:%i\")', 'l', '', '10', '120', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e094182', '65f432f2e016571', 'Время', 'fro_vrem', 'l', '', '20', '50', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e095179', '65f432f2e016571', 'Питатели', 'fro_pit', 'l', '', '30', '70', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e096f75', '65f432f2e016571', '10<br>(2)', 'fro_10', 'l', '', '40', '30', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e097e7c', '65f432f2e016571', '5<br>(12)', 'fro_5', 'l', '', '50', '30', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e098c16', '65f432f2e016571', 'Соотв', 'REPLACE(REPLACE(fro_soot,1,\'✔\'),0,\'\')', 'l', '', '60', '40', NULL ); 
INSERT INTO zzzzsys_browse (zzzzsys_browse_id, sbr_zzzzsys_form_id, sbr_title, sbr_display, sbr_align, sbr_format, sbr_order, sbr_width, sbr_json) 
VALUES ( '65f432f2e099ae8', '65f432f2e016571', 'd', 'tab_data', 'l', NULL, '70', '0', NULL ); 

--
-- zzzzsys_php
--

INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 
VALUES ( '65f432f2e016571_BB', '65f432f2e016571_BB', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 
INSERT INTO zzzzsys_php (zzzzsys_php_id, sph_code, sph_description, sph_group, sph_php, sph_run, sph_zzzzsys_form_id, sph_system, sph_global, sph_hide, sph_json) 
VALUES ( '65f432f2e016571_BE', '65f432f2e016571_BE', 'System PHP', 'nubuilder', NULL, NULL, NULL, '1', '0', NULL, NULL ); 

--
-- zzzzsys_object
--

INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0eec8c', '65f432f2e016571', 'frots', 'lookup', 'fro_data', 'Дата начала смены', '65f432f2e04372b', '10', '10', '150', '180', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', 'tab_data', 'tab_data', '0', '', '5e8a26a53ce5f49', '', '', 'tabel', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'datetime-local', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0f1d64', '65f432f2e016571', 'frots', 'input', 'fro_vrem', 'Время', '65f432f2e04372b', '20', '40', '235', '95', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'D|dd-mm-yy', 'time', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0fcdab', '65f432f2e016571', 'frots', 'input', 'fro_pit', 'Питатели', '65f432f2e04372b', '30', '70', '210', '120', '20', '1', 'left', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '', 'text', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e0fea99', '65f432f2e016571', 'frots', 'input', 'fro_10', '10 (2)', '65f432f2e04372b', '40', '100', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e1010fd', '65f432f2e016571', 'frots', 'input', 'fro_5', '5 (12)', '65f432f2e04372b', '50', '130', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'number', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
INSERT INTO zzzzsys_object (zzzzsys_object_id, sob_all_zzzzsys_form_id, sob_all_table, sob_all_type, sob_all_id, sob_all_label, sob_all_zzzzsys_tab_id, sob_all_order, sob_all_top, sob_all_left, sob_all_width, sob_all_height, sob_all_cloneable, sob_all_align, sob_all_validate, sob_all_access, sob_all_access_condition, sob_all_event, sob_all_style_type, sob_all_style, sob_calc_formula, sob_calc_format, sob_run_zzzzsys_form_id, sob_run_filter, sob_run_method, sob_run_target, sob_run_type, sob_run_id, sob_display_sql, sob_select_multiple, sob_select_2, sob_select_sql, sob_lookup_code, sob_lookup_description, sob_lookup_description_width, sob_lookup_autocomplete, sob_lookup_zzzzsys_form_id, sob_lookup_javascript, sob_lookup_php, sob_lookup_table, sob_subform_zzzzsys_form_id, sob_subform_foreign_key, sob_subform_add, sob_subform_delete, sob_subform_type, sob_subform_table, sob_input_count, sob_input_format, sob_input_type, sob_input_icon, sob_input_javascript, sob_input_datalist, sob_input_attribute, sob_input_file_target, sob_html_code, sob_html_chart_type, sob_html_javascript, sob_html_title, sob_html_vertical_label, sob_html_horizontal_label, sob_image_zzzzsys_file_id, sob_all_json, sob_json) 
VALUES ( '65f432f2e103730', '65f432f2e016571', 'frots', 'input', 'fro_soot', 'Соотв', '65f432f2e04372b', '60', '160', '270', '60', '20', '1', 'right', '0', '0', NULL, NULL, NULL, NULL, '', '', '', '', '', NULL, NULL, '', '', '', '0', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'N|1000.00', 'checkbox', NULL, '', NULL, NULL, '0', '', '', '', '', '', '', '', NULL, NULL ); 
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

What does -'I run your query in phpMyAdmin' mean?

I can't paste the request text from the cloner into phpMyAdmin, it's probably too big
kknm
Posts: 366
Joined: Sat Apr 11, 2020 12:03 am
Has thanked: 3 times
Been thanked: 4 times
Contact:

Re: Question about cloning forms

Unread post by kknm »

I understand - you meant the request for zzzzsys_form. It is executed in my PhpMyAdmin and the form appears in Forms.

I can't even paste the request text from the cloner into phpMyAdmin for zzzzsys_object - it's probably too big
Post Reply