Fixes

• Fixed problem when viewing the source code generation of outdated applications.

Features

• Added context menu to projects in "Gallery" and "List" modes, with shortcut options pertaining to the project.
• Added new interface for project deletion.
• Added the option to create an example database when creating a blank project.

Fixes

• Fixed problem with displaying duplicate icons in the ordering columns of the application list.
• Fixed problem with sc_field_disabled macro when used in auto-complete text fields with select2 enabled.
• Fixed code execution problem in Master/Detail application when there are no records.
• Fixed Fatal error: Uncaught TypeError: Unsupported operand types: string + int when accessing grid summary.
• Fixed Undefined array key "use_login_template" error when generating the security module, when using the option to use social networks.
• Fixed Fatal error: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array in chart application, in PHP 8.1 environment.
• Fixed Fatal error: Uncaught Error: Attempt to assign property "Db" on null in grid application, in PHP 8.1 environment.
• Fixed Fatal error: Uncaught TypeError: Unsupported operand types: string - int in the grid summary execution, in PHP 8.1 environment.
• Fixed Undefined array key "machine" when accessing "My Scriptcase" interface in PHP 8.1 environment.
• Fixed problem when using Slider in numeric type virtual fields in the control application.
• Fixed problem using the sc_date_dif 2 macro when the date difference corresponds to 28 days.
• Fixed "Trying to access array offset on value of type null" error when generating LDAP security module.
• Fixed Fatal error: Uncaught TypeError: array_keys(), when accessing "recent" folder of project applications.
• Fixed Fatal error: Uncaught Error: Class "nmMenuAppLayers" not found, when accessing the "Layers" option of the menu application.
• Fixed problem when returning to the previous application, in master/detail calls, accessing on mobile.

Features

• Added support for PostgreSQL version 15.

Fixes

• Fixed problem of not inserting in the field of type "Signature", in SQL Server connections.
• Fixed problem with undefined array key "webhelp" in PHP 8.1 environment.
• Fixed problem when using global variable as statement of the WHERE clause of the form.
• Fixed problem with PDF export in forms with HTML editor field.
• Fixed problem in the totalization view when using fixed label in the grid.
• Fixed problem in displaying the totalization label, with custom style in the summary.
• Fixed problem with Undefined array key "MgCd2" error when generating a grid application in environments with PHP 8.1.
• Fixed problem with fatal error in the chart application using the dimension with date "Days of the week", when the user's license type is Annual Subscription: Scriptcase 9 Professional.
• Fixed problem with variable not defined in JavaScript console, when accessing form application.
• Fixed problem with option to show all records on one page.
• Fixed problem with file generation when publishing project without libraries and common files.
• Fixed time indication in project publishing.

Features

• Added Font Awesome icons for sorting columns in the app list fixed label.

Fixes

• Fixed problem when saving zero value in initial interface configuration.
• Fixed problem when executing the SQL of the chart application, when configuring a WHERE condition in SQL along with the filter.
• Fixed problem in updating records in NVARCHAR columns with SQLite connection.
• Fixed problem with blank theme input support in button theme setting in express edition.
• Fixed problem with displaying the last application in the application list interface.
• Fixed application list fixed label display issue after page scrolling.
• Fixed problem in the CSS of the titles of the interface when performing a search.
• Fixed problem in the execution of the created buttons, being added in the upper and lower toolbar.
• Fixed "sc_lookup" and "sc_select" macros problem. A semicolon (;) was generated in the wrong place.

Features

• Added the fixed label in the application's home interface.

Fixes

• Fixed problem in displaying mandatory fields marker in multiple records and editable grid forms.
• Fixed crash problem when uploading images with PNG extension in the Images manager, in Linux and Mac environments.
• Fixed problem with the button link, in the options to open the application in another window and in another tab.
• Fixed problem when notifying discarded changes in HTML Editor fields of the form.
• Fixed Fatal error: Uncaught Error: Non-static method nmApplication::HasBackup() when restoring application in PHP 8.1 environment interface.
• Fixed problem loading images in HTML Editor type field.
• Fixed Undefined array key "app" error in application generation in PHP 8.1 environment.
• Fixed Fatal error: Uncaught Error: Call to undefined function each, when using PostgreSQL 7 or above connection in PHP 8.1 environment.

Features

• Added new option to change theme of application buttons, in express edition.

Fixes

• Fixed error_profile_test_module on connection, with Oracle drivers 8 and 8.0.5 or above, in production environment.
• Fixed problem with assigning "Data" type field to variables, when the "Use ComboBox" option is enabled.
• Fixed problem when saving duplicate file with new name in internal library.
• Fixed "Trying to access array offset on value of type null" error when adding a lang in PHP 8.1 environment.
• Fixed problem displaying inputs with numbers above three digits in Database Builder.
• Fixed "undefined array key" error in PHP 8.1 environment when accessing layout configuration, in form app.
• Fixed search behavior in the refined filter, when searching using the "See all" option.
• Fixed problem when importing a versioned project, using the PHP 8.1 environment.
• Fixed problem when assigning a value to a totalization variable of a virtual field.
• Fixed problem when using the "disable field" option in the multiple record form.
• Fixed crash problem after deleting a virtual field in the application.
• Fixed problem with sc_label macro when passing, as a parameter, a variable with a string value that starts with a capital letter.
• Fixed problem when using advanced search, along with a virtual field in the summary total.
• Fixed error when using the "sc_block_display" macro in the grid slide orientation, in the PHP 8.1 environment.
• Fixed fatal error when choosing a product for the table in the Restaurant example project.

Features

• Dashboard index creation interface now includes search box in the 'Table Name' field.
• Added table search box in SQL creation field lookup.

Fixes

• Fixed problem when creating security module in Italian and French languages.
• Fixed problem saving JavaScript methods after code changes.
• Fixed Fatal error: Uncaught TypeError: Illegal offset type in isset or empty, in advanced publishing in PHP 8.1 environment.
• Fixed problem with "Select all" button in refined filter modal.
• Fixed problem when downloading the file in the form using the ISO-8859-1 charset.
• Fixed problem when downloading the file using the Google Drive API.
• Fixed problem when downloading files using the Amazon S3 API.
• Fixed "Parameter must be an array or an object that implements Countable" error in Excel import.
• Fixed problem of not deleting master/detail of Form applications imported from previous versions.
• Fixed problem in the size of the text font input preview in the field settings in the Report Pdf application, in the Firefox browser.
• Fixed problem when applying dynamic filter on a Form with conditions in the WHERE clause.
• Fixed Fatal error: Uncaught TypeError: strpos(): Argument #1 ($haystack) must be of type string, in Report Pdf application in PHP 8.1 environment.
• Fixed problem with input display when inserting content in SC_HEADER header parameter, VALUE type, in the grid interface.
• Fixed problem with foreign key equal to 0 (zero) in the NxN relationship table in the Form.
• Fixed "Deprecated: substr(): Passing null to parameter #1 ($string) of type string is deprecated" error when creating a connection in PHP 8.1 production environment.
• Fixed problem with sending SMS using the sc_send_sms macro.
• Fixed problem in line break in vertical and slide grids.

Features

• Adjustments in the online shop example project, using the MySQL database.

Fixes

• Fixed error when deleting last form record from Helpdesk sample project.
• Fixed problem with displaying asterisk in required fields when marking as not displayed, in marker position.
• Fixed problem with modal when trying to close it by clicking the "exit" button of the application.
• Fixed undefined array key "dbms" error in PHP 8.1 environment.
• Fixed error when saving advanced grid filter with special characters.
• Fixed problem when saving a theme other than "SC9_" in applications, in PHP 8.1 environment.
• Fixed Undefined array key "nmgp_opc_soma_col" error in grid generation, in PHP 8.1 environment.
• Fixed Undefined array key errors "c_width", "t_height", "t_align_vert" and "contr_columns" in grid generation, in PHP 8.1 environment.
• Fixed Undefined array key "filldogname" and "nmgp_opc_soma_col" error in form generation, in PHP 8.1 environment.
• Fixed problem when using multi-upload field configured as Read-only.
• Fixed problem with setting the "Default Application" option in the menu when the linked application is renamed.
• Fixed problem with "Exit" and "Cancel" buttons not showing when the detail form is marked to use modal in editing and inserting.

Features

• Added a search box in the "Table" field in the creation interface of the Form and Calendar applications.

Fixes

• Fixed Undefined variable $str_dir_img error in menu application source generation, in PHP 8.1 environment.
• Fixed Undefined array key "refresh" error in source generation of grid application, in PHP 8.1 environment.
• Fixed Fatal error: Unsupported operand types: string - int, when using manual lookup of type "Multiple position values" in form application, in PHP 8.1 environment.
• Fixed error in the warning of the Group Label option in the Form.
• Fixed error when using manual lookup Multiple values (binary) in applications with field type BIT.
• Fixed "Invalid Data" message display when inserting empty records in select fields in the form.
• Fixed problem when viewing navigation buttons when using the sc_btn_display macro in the onLoad event.
• Fixed "Optional parameter $type declared before required parameter $bol_serialize" error in Access connection, in PHP 8.1 environment.
• Fixed Undefined array key "type" error in source generation of grid application, in PHP 8.1 environment.
• Fixed an error in the browser console, when calling the "fontawesome.css" file in the scriptcase interface.
• Fixed problem in generating Appointments example system in Sqlite and Mysql databases.
• Fixed problem in generating the Restaurant example system in Sqlite and Mysql databases.

Fixes

• Fixed "Fatal error: Uncaught TypeError: preg_match_all()" in project search interface when selecting "Words" and "All" options.
• Fixed problem passing parameter of sc_ajax_message macro when "Use SweetAlert" option is enabled.
• Fixed problem when using abbreviated value option in the grid summary.
• Fixed problem when informing the initial value in the form interface. The error only occurred in PHP 8.1 environment.
• Fixed problem when using spaces in the name of a saved state of the advanced search of the grid.
• Fixed problem with "Back" button losing property after opening another application in a new tab.
• Fixed problem in the list of projects logged in the interface with the Russian language.
• Fixed error: Undefined variable $contr_colunas, when using the sc_field_style macro in the grid configured with the SLIDE orientation in PHP 8.1.
• Fixed Fatal error: Uncaught TypeError: strcasecmp(), when performing the search grid on double select, checkbox and select multiple values ​​fields in PHP 8.1 environment.
• Fixed problem of not displaying the record right after insertion in a master/detail form with the detail configured to be displayed in a modal when editing and inserting.
• Fixed problem in displaying virtual field masks in ReportPDF application.
• Fixed problem with sending email function on export.
• Fixed problem with Bubble chart visualization.

Features

• Added field lookup support with "ignore accent" enabled.

Fixes

• Fixed displaying "FusionCharts trial" message in chart applications. Note: It is necessary to generate and republish the chart applications for the modification to take effect. It will not be necessary to update the production environment.
• Fixed problem when viewing the label filter in the grid.
• Fixed problem when using the "sc_api_download" macro in the "run" type button.
• Fixed "Fatal error: Uncaught Error: Call to undefined function is_countable()" in the "pivot_table" application of the Samples project in environments with PHP 7.0.
• Fixed problem with comma handling in the message parameter of the sc_mail_send macro.
• Fixed undefined variable $embedded_in_line_pdf.
• Fixed problem in calendar event view using MySQL connection.
• Fixed charset error when saving grid state.
• Fixed undefined array key "arr_tipo_sql_look" error.
• Fixed problem with label configuration and reload button hint on toolbar.
• Fixed Undefined array key "concat" error.
• Fixed Undefined array key "encryption" error when creating security module with LDAP.
• Fixed problem when configuring API in production environment in PHP 8.1.
• Fixed problem with label visualization in manual "lookup" in group by.
• Fixed problem when using summary filter together with virtual fields in the total.
• Fixed "Template Error: set_root: /opt/NetMake/v9-php73/wwwroot/scriptcase/devel/conf/grp/onlineShop/tpl/header/elegant_onlineshopping is not a directory" error in onlineShop project source code generation.
• Fixed problem when configuring HTML printing to also print the graphic.
• Fixed overlapping problem with fixed labels in the output modal in debug mode.
• Fixed Fatal error: Uncaught TypeError: method_exists, when using file upload with storage API.
• Fixed problem in viewing ajax output with fixed columns in the grid.
• Fixed Fatal error: Array and string offset access syntax with curly braces is no longer supported, in the "form_add_users" application generated by the security module. It is necessary to recreate the security module.
• Fixed Fatal error: Array and string offset access syntax with curly braces is no longer supported, in the "app_retrieve_pswd" application generated by the security module. It is necessary to recreate the security module.
• Fixed problem when uploading files in the "Image Manager" interface, using the PHP 8.1 environment.

Features

• Added 'Ignore accents' option to filter configuration interface. This option considers accented and unaccented versions of letters to be identical for filtering purposes. This option is only available for PostgreSQL connections.

Fixes

• Fixed error "Trying to access array offset on value of type null 4070" error.
• Fixed error "Undefined array key 160" error.
• Fixed problem when logging out of scriptcase, when accessing the Database Builder tool.
• Fixed problem in creating the data dictionary, using the Postgres connection.
• Fixed error "Fatal error: Uncaught Error: Call to undefined function get_magic_quotes_gpc()", when using "conditions" tab in SQL Builder.
• Fixed problem with zero value being returned as empty.
• Fixed problem when adding langs and global variables in Form fields watermark.
• Fixed problem in totaling using virtual field, being totalized through onGroupByAll event.
• Fixed problem when viewing the calendar in the date field in the dynamic search.
• Fixed problem when configuring API in production environment in PHP 8.1 environment.
• Fixed problem with lookup of break fields in licenses with expired upgrade.
• Fixed view of link to tables in Database Builder.
• Fixed problem with refined search when using percentage type field.
• Fixed charset error in scriptcase diagnosis.
• Fixed problem when inserting record in double select field.

Fixes

• Fixed problem when creating project in Italian language.
• Fixed problem when using single quotes in the watermark of Form fields.
• Fixed problem connecting to DB2 database using DB2 driver.

Fixes

• Fixed Fatal error: Uncaught TypeError: inarray() when performing quick search and dynamic filter.
• Fixed "A non-numeric value encountered" error in devel\generator\nm_gp_consulta_prep.php 668, when using '%' symbol in table width.

Features

• Added support for PHP 8.1 environments with SourceGuardian.
• Added a new property within the Grid application links which allows you to open in a new tab.
• The PDF export option within Grid and Charts now includes a progress bar and the file opens in a new browser tab.

Fixes

• Fixed problem when accessing SQL Server connections in Database Builder.
• Fixed problem when synchronizing tables in the form.