Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
Register and log in to access exclusive forums and content available only to registered users.
Question about cloning forms
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
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.
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.
-
- 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
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 );
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
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)
*******************************
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 );
-
- 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
Did you run the SQL in e.g. phpMyAdmin? Then all rows will be inserted into the DB tables if there is no error.
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
It was in phpMyAdmin that I looked for records and took a screenshot of the tables in zzzzsys_form and zzzzsys_object
-
- 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
Did you successfully execute the query? And then, can the new form be found in zzzzsys_form ?
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
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.
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.
-
- 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
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 );
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
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
I can't paste the request text from the cloner into phpMyAdmin, it's probably too big
-
- Posts: 366
- Joined: Sat Apr 11, 2020 12:03 am
- Has thanked: 3 times
- Been thanked: 4 times
- Contact:
Re: Question about cloning forms
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
I can't even paste the request text from the cloner into phpMyAdmin for zzzzsys_object - it's probably too big