Doubts about SQL Builder

[Giu]

I have some question about this functionality.

2024-06-06_09-47.png

"Copy" button is not working for me, does nothing. Console error

Code: Select all

Uncaught ReferenceError: nuCopySQL is not defined

BTW, looking in the title of the popup I think is not loaded properly.

As an improvement without thinking too much on it, could be interesting an option to load SQL queries stored previously, and if you want, be able to stay synced (or just copy). I mean, Maybe we have an SQL statement we must use in several places of the application. Maybe we have to load a previosly stored SQL and copy it to modify, or maybe we want to "link", and if we change that SQL stored, will be changed for all controls linked.
Idea is to point browse sql, lookup and so on, to an especific SQL

On the other side, there is no way to paste a SQL statement to SQL Builder, and diagram be refreshed right? Or it is what it does but not working for me right now?

Regards.

[kev1n]

Hi,

There appears to be an issue with the Copy button. Please run the following SQL query to resolve it:

Code: Select all

REPLACE 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 ('nuselect', 'browseedit', 'nuselect', 'SQL Builder', NULL, '#sse_description#|New', 'zzzzsys_select', 'zzzzsys_select_id', '', '0', '0', '0', NULL, 'SELECT * FROM zzzzsys_select \r\nWHERE (sse_system != 1 OR sse_system IS NULL)\r\nORDER BY sse_description ASC\r\n\r\n', NULL, NULL, 'nuSetToolTip(\'sse_resize\', \'Resize\');\r\n$(\'#sse_sql\').css(\'z-index\', 1);\r\nnuLabelOnTop([\'nusvg\']);\r\n\r\n\r\n\r\nif (nuIsNewRecord()) {\r\n $(\'#sse_edit\').val(0);\r\n}\r\n\r\n$(\"#sse_edit option[value=\'\']\").remove();\r\n\r\n$(\'#sse_sql\')\r\n.css(\'font-size\', \'10px\')\r\n.addClass(\'sql\')\r\n.on(\'dblclick\', function() {\r\n nuOpenAce(\'SQL\', this.id);\r\n});\r\n\r\n$(\'#label_sse_sql\').remove();\r\nnuHide(\'sse_code_snippet_lookupcode\');\r\nnuSetSnippetFormFilter(0, 0, 1);\r\n\r\n$(\'#sse_resize\').addClass(\'nuAllowDblClick\');\r\n\r\nnuSelectSetSFCB();\r\n\r\nif (window.filter == \'justsql\') {\r\n\r\n var sid = String(nuFORM.getCurrent().record_id);\r\n var from = sid.substring(sid.length-2);\r\n var targ = \'#sfo_browse_sql\';\r\n\r\n $(\'#nuDeleteButton\').remove();\r\n $(\'#nuCloneButton\').remove();\r\n $(\'#sse_description\').val(sid);\r\n\r\n nuHide(\'sse_description\');\r\n\r\n if (nuFORM.getCurrent().record_id != -1) {\r\n\r\n $(\'#nuSaveButton\').hide();\r\n\r\n if (from == \'BR\') {\r\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Form Browse SQL\', \'nuSelectCopySQL(\"sfo_browse_sql\")\');\r\n }\r\n if (from == \'SE\') {\r\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Select Object SQL\', \'nuSelectCopySQL(\"sob_select_sql\")\');\r\n }\r\n if (from == \'DI\') {\r\n nuAddActionButton(\'SaveToTextarea\', \'Copy to Display Object SQL\', \'nuSelectCopySQL(\"sob_display_sql\")\');\r\n }\r\n\r\n }\r\n\r\n}\r\n\r\n\r\n\r\n\r\n\r\n$(\'#sse_sql\').css(\'overflow-x\', \'scroll\');\r\n\r\n\r\nnuSelectWhereClauses();\r\n\r\n\r\nfunction nuSelectCopySQL(target) {\r\n\r\n const s = $(\'#sse_sql\').val();\r\n\r\n parent.$(\'#\' + target).val(s).change();\r\n\r\n parent.$(\'#dialogClose\').trigger(\"click\");\r\n\r\n}\r\n\r\n\r\nfunction nuSelectTempPHP() {\r\n\r\n var p = [];\r\n\r\n p.push(\'\');\r\n p.push(\'$sql = \"\');\r\n p.push(\'\');\r\n p.push(\'CREATE TABLE #TABLE_ID#\');\r\n p.push($(\'#sse_sql\').val());\r\n p.push(\'\');\r\n p.push(\'\";\');\r\n p.push(\'\');\r\n p.push(\"nuRunQuery($sql);\");\r\n p.push(\'\');\r\n nuMessage(p);\r\n\r\n $(\"#nuMessageDiv\").css(\'text-align\', \'left\');\r\n\r\n}\r\n\r\nfunction nuBeforeSave() {\r\n\r\n nuSelectBuildSQL();\r\n return true;\r\n\r\n}\r\n\r\nfunction nuSelectWhereClauses() {\r\n\r\n $(\"[id$=\'ssc_type\']select\").each(function(index) {\r\n\r\n var p = $(this).attr(\'data-nu-prefix\');\r\n var t = $(this).val();\r\n\r\n if (t == 2 || t == 3) {\r\n\r\n if ($(\'#\' + p + \'ssc_sort\').val() == \'\') {\r\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\r\n }\r\n\r\n $(\'#\' + p + \'ssc_clause\').hide();\r\n $(\'#\' + p + \'ssc_sort\').show();\r\n\r\n } else {\r\n\r\n $(\'#\' + p + \'ssc_clause\').show();\r\n $(\'#\' + p + \'ssc_sort\').hide();\r\n\r\n }\r\n\r\n });\r\n\r\n}\r\n\r\nfunction nuSelectWhereClausesold() {\r\n\r\n $(\"[id$=\'ssc_type\']select\").each(function(index) {\r\n\r\n var p = $(this).attr(\'data-nu-prefix\');\r\n var t = $(this).val();\r\n\r\n if (t == 2 || t == 3) {\r\n\r\n if ($(\'#\' + p + \'ssc_sort\').val() == \'\') {\r\n $(\'#\' + p + \'ssc_sort\').val(\'ASC\');\r\n }\r\n\r\n $(\'#\' + p + \'ssc_clause\').hide();\r\n $(\'#\' + p + \'ssc_sort\').show();\r\n\r\n } else {\r\n\r\n $(\'#\' + p + \'ssc_clause\').show();\r\n $(\'#\' + p + \'ssc_sort\').hide();\r\n\r\n }\r\n\r\n });\r\n\r\n}\r\n\r\nfunction nuSelectAddSQLTable(e) {\r\n\r\n let s = $(\'#sqlframe\')[0].contentWindow.nuSQL;\r\n\r\n s.addBox(e.target.value);\r\n e.target.value = \'\';\r\n s.buildSQL();\r\n\r\n}\r\n\r\nfunction nuSelectSFCB() {\r\n\r\n nuSelectWhereClauses();\r\n nuSelectBuildSQL();\r\n\r\n}\r\n\r\nfunction nuSelectBuildSQL() {\r\n $(\'#sqlframe\')[0].contentWindow.nuSQL.buildSQL();\r\n}\r\n\r\nfunction nuSelectSetSFCB() {\r\n\r\n $(\'.nuSubformCheckbox.zzzzsys_select_clause\').on(\'click\',\r\n function() {\r\n nuSelectSFCB();\r\n });\r\n\r\n\r\n}\r\n\r\nfunction nuSelectResizeSQL() {\r\n\r\n if ($(\'#sqlframe\').css(\'height\') == \'460px\') {\r\n $(\'#sqlframe\').css(\'height\', 700);\r\n } else {\r\n $(\'#sqlframe\').css(\'height\', 460);\r\n }\r\n\r\n}', NULL, '1', NULL)

The SQL builder is a "one-way road" and cannot generate a relationship diagram from a pasted SQL statement.