Transferring pages, tables, forms, and dashboards.

To do this, each component has a transfer icon at the top right Transferring a component < / > (relevant for tables, forms, and dashboards). 

A similar button icon is also used for pages. 

Based on A

To export components from the database, it must contain the following functions and procedures, set in the following order:

• The split Function accepts the string to split and the symbol to split by. At the exit, returns a line-by-line broken string.
• Function as_system_getStringFromCode - accepts the stored procedure code at the input. Returns a string with the stored procedure code in which string comments are replaced with block comments.
• Function as_system_getSQL_procs - accepts the initial fragment of the name of the required procedures and overwrite (if 1, it will overwrite everything, if 0, it will add only what was not there). Returns a script string that includes create for the selected stored procedures
• Procedures-at the input accept the component code and overwrite (if 1, it will overwrite everything, if 0, it will add only what was not there). Returns a script string that includes insert for component data and create for the selected stored procedures of the component
• as_system_getSQL_page - transfers page data (from the pg_pages table), and its stored procedure pg_crumbs_{pageCode} - the so-called page SQL
• as_system_getSQL_table - transfers the data of the table and its columns (from tables as_crud_tables and as_crud_cols), stored procedure list _dict columns, and stored procedures table getItems, updateField, deteleField, fastCreate
• as_system_getSQL_form - transfers the data on the form and its columns (from tables as_forms and as_formCols), stored procedure list _dict columns, and stored procedures forms getItem, checkItem, saveItem
• as_system_getSQL_dashboards - transfers data about dashboards and their panels (as_dashboards and as_dashboardPanels), and all corresponding stored procedures

Next, to get a script for exporting a component (page, table, form, or dashboard), run the corresponding of the four procedures as follows:

• Select Create query
• Select the menu item Request/SQLCMD mode
• In the query window, write

:OUT D:\filename.txt

exec {Procedure name} '{component Code to export}'

• Find the file in the path specified above filename.txt, open and copy everything under the line:
  

Note: you only need to run one component at A time, otherwise the program will overwrite everything in one file, overlaying the code on top of each other

Based on B

We run the copied script, and we create the required component and the stored procedures attached to it.