Features

• Forms and search fields now allow the editing of records from captured links.

Fixes

• Fixed problem in icon display, for fields that contain interval condition and capture link.
• Fixed problem in the messages in case of EOF, of the lookup of display in text fields.
• Fixed problem in alert display when running application with select field, radio or checkbox with no value in lookup.
• Fixed problem in the inclusion of the "datetime" field with the option of system data in the inclusion and configured as label.
• Fixed problem with BYTEA type when inserting data using signature type field.
• Fixed problem in the configuration of the dimensions of the signature field.
• Fixed problem creating untitled pages in the form.

Fixes

• Fixed problem when searching for "?", using the criterion contains, in quicksearch.
• Fixed Uncaught TypeError error: str_link is undefined when clicking on a tree menu item.
• Fixed problem not loading the menu, not Google Chrome and Microsoft Edge, due to large amount of iframes.
• Fixed problem when generating tab applications using old themes.

Fixes

• Fixed parse error: syntax error, unexpected '"', when using checkbox field with multiple values.
• Fixed problem in displaying the WORD option when exporting the chart.
• Fixed scrolling problem in methods interface.

Fixes

• Fixed problem when exporting PDF on forms with pages.
• Fixed problem in the initial value of special search criteria in DATETIME fields.
• Fixed problem in WORD export of grid summary.
• Fixed problem when using sc_error_message macro in the grid's onClick event.
• Fixed problem when using fields to select multiple values, with Select2.

Features

• Improved Microsoft Azure, Amazon RDS, Google Cloud and ODBC connection interfaces.
• Added sc_api_gc_get_url and sc_api_gc_get_obj macros to generate "token" parameter, to be used in the sc_api_upload macro of Google Drive.

Fixes

• Fixed problem in displaying the cursor for typing when using the "Display the Select2 search area" option.
• Fixed problem with fixed label alignment.
• Fixed problem when using "Navigation" option in the mobile tab of the menu.

Fixes

• Fixed problem when viewing events on the calendar with weekly and daily view.

Features

• Improved data visualization in SQL Builder.
• Added option to convert database charset to UTF-8 in project properties.

Fixes

• Fixed problem with the "Save in session" option in the "Persist State" button.
• Fixed problem with "language" field of applications, after creating batch applications, and project with only one language selected.
• Fixed problem with loss of default values, in manual lookup of radio and checkbox type fields, when clearing state of advanced grid search.
• Fixed problem when defining font size and tab color of form pages.
• Fixed problem when performing column ordering in forms with horizontal orientations.
• Fixed problem in the visualization of themes during project creation.
• Fixed problem when canceling duplicate files in the internal library.

Features

• Added support for utf8mb3 and utf8mb4 client encoding on MySQL connections.

Fixes

• Fixed problem when creating security module using Firebird connection.
• Fixed problem with the display of the "JSON Export" button on the security module.
• Fixed problem when inserting user information in the log table, using an environment with IPv6.
• Fixed problem in viewing the upload area in the form Grid editable (view).
• Fixed problem with the redirection parameter of the sc_ajax_message macro in event Ajax in the grid.
• Fixed JavaScript error when creating the connection in the production environment.
• Fixed problem in viewing records, after page break, in PDF export.
• Fixed problem with creating horizontal scroll bar when expanding vertical menu.
• Fixed problem with the display of an icon indicating the expansion of the menu in the PDF Layout.
• Fixed problem in the display of accented characters in the JSON export of the chart application.

Fixes

• Fixed display problem with the mini calendar.
• Fixed problem in the treemenu tabs, using language or theme options.

Features

• Added support for utf8mb3 and utf8mb4 client encoding for MySQL connections.

Fixes

• Fixed error Undefined property::$apl when assigning values to virtual checkbox fields, through events.
• Fixed problem in event visualization, after adding fields in dynamic group by.
• Fixed problem with creating horizontal scroll bar when expanding vertical menu.
• Fixed Parse error: syntax error, unexpected '.' in the query application using the google drive API.

Fixes

• Fixed problem with the generation of the diagnostic PHP file in the zip file of the production environment generated after publication.
• Fixed problem in uploading the Google drive API using the ISO-8859-1 charset. (It's Necessary to update the production environment).
• Fixed error when accessing SQL from the application menu.
• Fixed connection problem when installing Scriptcase in PostgreSQL 13 environment.
• Fixed problem when assigning totalization value in group by with more than one field.
• Fixed problem when disabling the field using the "Spin" option.
• Fixed problem with a global variable with no value when using the sc_exit macro.
• Fixed problem with onGroupBy events in fields named with underline(_).
• Fixed problem when searching for quicksearch in the master detail form.
• Fixed problem when searching for quicksearch in the grid, when the "lookup" field was selected for automatic, but empty.
• Fixed problem in the display of the primary key field, after adding a new record.
• Fixed problem with aligning headings on horizontal forms.
• Fixed problem with displaying the value of the label type field, after adding a new record.

Fixes

• Fixed problem with loading languages ​​in the field of regional settings.
• Fixed problem with displaying errors when copying an application with the same name to another project.
• Fixed problem in confirming the deletion of themes for charts.
• Fixed problem in downloading the PDF export using the sc_set_pdf_name macro.
• Fixed problem with the radio field label in the helpcase settings.
• Fixed problem in the description of the scriptcase toolbar.
• Fixed message error when recovering password generated by security module.
• Fixed problem when configuring the style of the links in the themes of the buttons.
• Fixed problem in required fields, after browsing between records in the form.
• Fixed problem when deleting items in the hotkey template.
• Fixed alignment problem in the action buttons of the hotkey template.
• Fixed problem when naming fields, using the automatic link of the form, during the creation of the application.
• Fixed problem in the definition of langs created in the data dictionary, in form labels.
• Fixed download problem in Document type fields, configured as read-only, when navigating form records.
• Fixed problem with SQL type of DATE columns using several tables in the same query, with Oracle connection.
• Fixed problem in defining refresh interval in grids, when used as a detail application in a master/detail.
• Fixed issue with duplicate list of languages ​​with different regional settings in the menu application.
• Fixed Javascript error: Uncaught SyntaxError, when selecting ZIP code to fill in values.
• Fixed count() error when generating form after changing dependencies, using the cascade delete option.
• Fixed problem with capturing fields in the Run button interface.
• Fixed problem in the helpCase interface when showing CSS code overlapping the buttons, in the code editor.
• Fixed problem when saving specific connection in the filter lookup, in the chart application.
• Fixed problem in formatting date/time fields when marked as a label.
• Fixed problem in the visualization of themes at the user and project level, in the creation of a new project.
• Fixed problem in the validation of the sc_changed macro for "data" type fields.
• Fixed problem in the initial load of the form visualization, using the application link via iframe.
• Fixed problem in the display of error messages in the html control application.
• Fixed problem with the preview of Youtube videos on grid, in an SSL environment.
• Fixed problem in Excel, CSV, XML and RTF export in SQL Server database with ISO charset.
• Fixed problem in displaying values ​​when using the complete feature with zeros in decimal fields of the chart.
• Fixed problem with the alignment of the menu sub-items.
• Fixed problem when saving connection parameters between applications.
• Fixed problem when using hashes (#) in code comments in application events.
• Fixed problem with German text of the "Exit" button, in form applications.
• Fixed problem with form dependencies error message, using multiple languages.
• Fixed problem with locality icon when creating project, using Chinese (traditional) language.

Fixes

• Fixed problem when exporting Grid PDF in CentOS8 environment.
• Fixed problem when exporting PDF in Chart in Linux CentOS8 environments.
• Fixed problem when exporting PDF in Form application in Linux CentOS8 environments.
• Fixed problem with displaying commented global variables.
• Fixed problem with Undefined property: $proc_fast_searc.
• Fixed problem with the "Notify discarded changes" message for the checkbox, radio and double select fields.
• Fixed problem when using the "Complete with zeros" feature in decimal and currency fields.
• Fixed problem with Fatal error: Uncaught ArgumentCountError: Too few arguments to function nmFontePHPFormHtml::GeraCorpo() in the N:N relationship binding attributes.
• Fixed problem in the HTML image field link to HTML control.
• Fixed problem when using the } character in a string in an internal library function.
• Fixed problem when double clicking on the back button of a form within a modal.
• Fixed problem with displaying records in fields with N: N relationship after reloading application.

Features

• Added tab for choosing values ​​when the summary filter fields option is a date range.
• Improved performance when generating project application source code.

Fixes

• Fixed problem with corrupted file when downloading in document fields (file name) in the query.
• Fixed problem when entering the value 0 in decimal field and the currency configured to display three characters.
• Fixed problem in the inclusion of a comma in values ​​beginning with zero, in decimal and currency fields.
• Fixed problem in displaying records after using a PHP button in a form editable grid view.
• Fixed problem with the "Exit" button when defining the initial menu application using a global variable.

Fixes

• Fixed problem in the group by lookup when using the same field as a metric.
• Fixed problem on new security options at project default values.
• Fixed problem in interface when saving button class.
• Fixed problem in viewing long-named tables when creating an application.
• Fixed problem when inserting negative values ​​in decimal fields of the form.
• Fixed problem with double quote, when inserting values ​​in BLOB and CLOB columns.
• Fixed problem in text editing when switching between run button events.
• Fixed problem with the lookup of the fields when performing research on the project.
• Fixed problem with the ajax event code editor when resizing the window.

Fixes

• Fixed problem with opacity on the days of adjacent months in the mini calendar.
• Fixed problem when changing theme CSS parameters in advanced filter autocomplete fields.
• Fixed problem when using global variable in the form confirmation message.
• Fixed problem with Hint input when creating buttons to accept global variables.
• Fixed problem in displaying items of connection property between applications when opening in Iframe.
• Fixed problem with blank printing on the calendar.
• Fixed problem when creating application with primary key field type BIGINT and starting with "All".
• Fixed problem with using fields after displaying the Sweet Alert message from the sc_alert macro.
• Fixed problem with menu items and sub-items after displaying Toast and Sweet Alert.
• Fixed problem when using sc_lookup macro in the menu application.
• Fixed problem when searching for records with "&" in the form's dynamic search.
• Fixed problem with block behavior when opening "Help by block" content.
• Fixed problem when deleting all records from a search, in a multiple record form.
• Fixed problem when importing project without applications.
• Fixed problem with highlight on single record type forms.

Features

• Added the ability to save HTML tags and JavaScript text input in control application's text fields.
• Added support for WEBP files in the image manager.
• Added support for PostgreSQL connection charsets to the production environment's encodings list.
• Added "Keep old aspect of uploading files" option in project properties.

Fixes

• Fixed problem with the behavior after selecting the "Save Grid" button.
• Fixed problem with the text display when filling in the To-Do List.
• Fixed problem with displaying buttons when sending project messages in low resolution.
• Fixed problem when restoring selected fields in the advanced Report PDF filter and grid.
• Fixed problem with advanced mode parameters with DB2 connection.
• Fixed problem with displaying Google Calendar buttons in the calendar application.
• Fixed problem in viewing HTML tags in the menu tabs, when using the toolbar buttons.
• Fixed problem when inserting data in the calendar using Google Calendar API.
• Fixed problem with redirection in the tree menu when selecting default application and opening items in a new tab.
• Fixed problem with the download of document (file name) field type files in the grid.
• Fixed problem with "save application" after synchronizing the table.
• Fixed problem when using space and capital letters, in global variables of the header and footer of the grid and form applications.
• Fixed problem with the mini calendar display.
• Fixed problem with displaying widget titles in dashboard applications.
• Fixed problem in viewing the applications configured in the tab application, using the French language.
• Fixed problem when sending link through the sc_mail_send macro.

Features

• Added reload button on the dashboard toolbar.
• Added SweetAlert option in the HTML control application interface.
  • Note: SweetAlert will only work if the scDisplayUserError() Javascript function is not being used.
• Added new security options to the HTML control application.
• Added "Error Display" option, located in the HTML control application settings.
  • Note: This feature will only work when the SweetAlert option is disabled.
• Change in the HTML control application. "submit" now done via Ajax.

Fixes

• Fixed problem when returning to the current record after redirection using the sc_redir macro.
• Fixed problem when using Image type field (file name) in multiple record and editable grid forms.
• Fixed "Undefined" error when expanding or collapsing events in the calendar application.
• Fixed "Undefined" error when changing time of calendar events in the display by day.
• Fixed problem in the "submit" of the HTML control application in Chrome browser. The form was submitted twice, causing an error in the validation of the login, with the message "Unauthorized user".
• Fixed problem with character validation when naming new themes for charts.
• Fixed problem with the use of fields in horizontal forms after the toast of Sweet Alert was displayed.
• Fixed problem when saving changes to the summary, in the project's default values.
• Fixed problem when saving changes to the summary, in the project's default values.
• Fixed problem when using Checkbox in dropdown with editable grid (view) orientation.
• Fixed error when using dynamic filter in chart applications.
• Fixed column alignment problem in summary breaks in the grid application.
• Fixed problem when saving grid summary using fixed columns.
• Fixed fopen error "(_lib / lib / js / GoJS.js): failed to open stream: No such file or directory" in menu applications.

Features

• Added new option for vertical alignment in all applications (excluding blank, tab, and menu).
• Added Native input boxes with 100% width as a default setting.
• Added new option for using the label of your fields below the entry field.
• Added new option for displaying the date field watermark inside the input fields.
• Added new option to display the label as a watermark, available only in the control application.
• Added new sc_statistic method which allows you to more easily calculate Median, Variance, Standard deviation, Amplitude, Number of different values, Amount of values, Number of non-null values, Lower value and Highest value.
• Added new configuration options to the save grid button.
• Added new button which allows you to save filtered data from a grid in session.
• Added the option to make use of the grid's 'lookup' within the summary 'lookup'.
• Added the ability to pin the columns during horizontal scrolling, option available in the summary.
• Added a 'Remember me' option for the login screens into the security module.
• Added new native security features, including:
  • Cookies Secure - Prevents the cookie from being captured via JavaScript, makes cookies work only in the application domain.
  • Auditor XSS - Avoids cross-site scripting and protects against malicious HTML and JavaScript.
  • Strict-Transport-Security - Forces browsers to use HTTPS in domains where it is enabled, instead of using HTTP.
  • X-Frame-Options - This header provides protection against clickjacking, known as 'click swipe' - this vulnerability can steal relevant information and data from the user.
  • X-Content-Type-Options - X-Content-Type-Options is used to protect against MIME detection vulnerabilities.
  • Referrer-Policy - Controls the traffic of sending messages, request control. Most commonly used option is “no-referrer-when-downgrade”.
  • Feature-Policy & Permissions-policy - Standard browser features, determine what the page will load. They have the same function, with different syntax. The Permissions-policy option is mostly used.
  • Content-Security-Policy - Determines the behavior of API functionality in the browser. The Content-Security-Policy header allows you to restrict resources such as JavaScript, CSS or just about anything the browser loads.