ScriptCase (64-bit)

What's new in this version:

ScriptCase 9.9.004 (64-bit)
Added:
- quicksearch for searching indexes in the Translate Applications tool
- fixed bar on project list screen with vertical orientation
- show/hide password icon on login and license registration screens
- Error Position option in Express Edit
- Display Field Error option in a modal in Express Edit
- Error Timeout option in Express Edit
- Display Date Format option in Express Edit and Default Values
- Date Display Position option in Express Edit and Default Values
- Show Message option in Express Edit

Improved:
- project message translation interface
- project data dictionary interface

Fixed:
- problem with displaying ordering icons, on the fixed bar of the project's list of applications, on screens with lower resolutions or after window resizing
- problem in maintaining the ordering state of the applications in the interface after closing the application's tab
- problem in buttons interface after project conversion from v8 to v9
- Fatal error: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array when creating buttons in converted applications
- Fatal error: Uncaught Exception: Serialization of 'LDAPConnection' in LDAP security module login screen
- grid sorting problem when using the MEDIUMINT data type in MySQL
- problem when inserting images/documents containing accents in the multi-upload field in the SQLServer database. The error only occurred when the option Conversion from charset to UTF8 by database was disabled in the project.
- problem when renaming folders with numerals in project messages


ScriptCase 9.9.003 (64-bit)
Improved:
- Added new "Last Accessed" column in the interface of all projects in List mode
- Added protection to not create buttons using parentheses

Fixed:
- problem with alignment of totals when changing the placement of action buttons
- problem with Grid navigation when using the sc_change_css macro
- problem in connection definition when publishing example projects
- views of Mssql Server connections "Native Srv" and "Native SRV PDO" in Linux and Mac development environments. The connections will only be visualized when the extensions are enabled in the environment
- the visualization of Mssql Server connections in the production environment. You will need to update the production environment.
- a Javascript error when exporting the grid for printing, using a nested grid link
- problem in viewing the code in the Ajax event button, created through the action bar, when making a change to the grid's SQL
- problem when accessing detail module in grid application using sc_change_css macro in PHP 7.3
- connection error with MSSQL Server Native SRV PDO driver in production environment
- problem when using the same nested grid name in the target application
- problem with Undefined array key "t_collapse" when accessing the "Blocks" option in the Form, in environments with PHP 8.1
- problem in exporting Excel in grids that have nested grid, when the Excel option was set to "No" in the nested grid
- problem in log generation in French and Italian languages
- problem when generating project source code by choosing outdated application options
- alignment of the font awesome icon on the application button if it is displayed without a label
- problem with Undefined variable $tbapl_Texto_Size_Header in grid generation
- a problem when searching the filter in the chart, using the Slider type option
- problem when activating dynamic totaling option in configuration of group by in grid application


ScriptCase 9.9.002 (64-bit)
Added:
- Click here and see all the news in version 9.9
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms
- sc_change_css() macro for grid application
- hint option for "Star" Rating fields

Fixed:
- problem displaying the cursor for typing when using "Select2" with the search area
- a problem with displaying the unsaved changes message in forms that contain the Signature field
- problem when using the "select2" option with multiple values


ScriptCase 9.9.001 (64-bit)
Added:
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms
- sc_change_css() macro for grid application
- hint option for "Star" Rating fields
- sc_actionbar_state macro in the grid action bar
- sc_actionbar_disable macro in the grid action bar
- sc_actionbar_show macro in the grid action bar
- sc_actionbar_clicked_state macro in the grid action bar
- sc_actionbar_enable macro in the grid action bar
- sc_actionbar_hide macro in the grid action bar

Improved:
- the layout of the Google Sheets API interface in the production environment

Fixed:
- problem when using uppercase fields in the form inclusion, using the Google Sheets api
- problem using action buttons when there is no link between applications and the detail module enabled in the grid
- Problem in viewing log module events in the application
- error of Undefined array key "name" in button creation interface
- problem when navigating between records when using subquery with iframe in Slide type orientation


ScriptCase 9.9.000 (64-bit)
Added:
- payment API (Stripe)
- payment API (Braintree)
- payment API (Mercado pago)
- field type Rating Smile
- field type Rating Thumbs
- Font Awesome support in "Rating" type field setting
- integration with Google Sheets in form applications
- action bar for grid applications
- the macros sc_actionbar_state(), sc_actionbar_clicked_state(), sc_actionbar_enable(), sc_actionbar_disable(), sc_actionbar_show(), sc_actionbar_hide(), in the grid action bar
- support for iframe in the nested grid, allowing to execute all the functionality of the grid
- preseeding for foreign key in data dictionary columns
- foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms

Fixed:
- problem with simultaneous selection of the Generate ZIP and Tar.Gz options with applications in typical publication, when selecting the Linux OS
- problem in the signature field in the Grid, when the record was inserted in the form with the signature field empty
- "Parse error: syntax error" when selecting fields for refined filter in queries that have "alias" in SQL, in PostgreSQL connections
- problem when totaling a field two or more times in the Grid
- problem in duplication of the "Documents Directory" field in the advanced publication directories step
- a problem when creating a Grid with customizable SQL in PostgreSQL connections
- "2 = Undefined array key 1" in Query source code generation in environments with PHP 8.1
- Fatal error: require_once on field binding, when configured to start by search


ScriptCase 9.8.014 (64-bit)
- Fixed problem when viewing the source code generation of outdated applications


ScriptCase 9.8.013 (64-bit)
Added:
- context menu to projects in "Gallery" and "List" modes, with shortcut options pertaining to the project
- new interface for project deletion
- option to create example database in the database tab, when creating a blank project

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


ScriptCase 9.8.012 (64-bit)
Added:
- Added PostgreSQL version 15 support

Fixed:
- problem of not inserting in the field of type "Signature", in SQL Server connections
- problem with undefined array key "webhelp" in PHP 8.1 environment
- problem when using global variable as statement of the WHERE clause of the form
- problem with PDF export in forms with HTML editor field
- problem in the totalization view when using fixed label in the grid
- problem in displaying the totalization label, with custom style in the summary
- problem with Undefined array key "MgCd2" error when generating a grid application in environments with PHP 8.1
- 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
- problem with variable not defined in Javascript console, when accessing form application
- problem with option to show all records on one page
- problem with file generation when publishing project without libraries and common files
- time indication in project publishing


ScriptCase 9.8.011 (64-bit)
Fixed:
- problem when saving zero value in initial interface configuration
- problem when executing the SQL of the chart application, when configuring a WHERE condition in SQL along with the filter
- problem in updating records in NVARCHAR columns with SQLite connection


ScriptCase 9.8.010 (64-bit)
Added:
- Added the fixed label in the application's home interface

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


ScriptCase 9.8.009 (64-bit)
Added:
- Added new option to change theme of application buttons, in express edition

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


ScriptCase 9.8.008 (64-bit)
Added:
- search box in the "Table Name" field in the Dashboard application's index creation interface
- table search box in SQL creation in field lookup
- FI

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


ScriptCase 9.8.007 (64-bit)
- Adjustments in the online shop example project, using the Mysql database
- Note: You will need to import the project

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


ScriptCase 9.8.006 (64-bit)
- Added search box in the "Table" field in the creation interface of the Form and Calendar applications

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


ScriptCase 9.8.005 (64-bit)
Fixed:
- "Fatal error: Uncaught TypeError: preg_match_all()" in project search interface when selecting "Words" and "All" options
- problem passing parameter of sc_ajax_message macro when "Use SweetAlert" option is enabled
- problem when using abbreviated value option in the grid summary
- problem when informing the initial value in the form interface. The error only occurred in PHP 8.1 environment
- problem when using spaces in the name of a saved state of the advanced search of the grid
- problem with "Back" button losing property after opening another application in a new tab
- problem in the list of projects logged in the interface with the Russian language
- error: Undefined variable $contr_colunas, when using the sc_field_style macro in the grid configured with the SLIDE orientation in PHP 8.1
- Fatal error: Uncaught TypeError: strcasecmp(), when performing the search grid on double select, checkbox and select multiple values ​​fields in PHP 8.1 environment
- 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
- problem in displaying virtual field masks in ReportPDF application
- problem with sending email function on export
- problem with Bubble chart visualization


ScriptCase 9.8.004 (64-bit)
Added:
- Added search in "lookup" fields with "ignore accent" option
- 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.
- 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:
- 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.
- 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.
- problem when uploading files in the "Image Manager" interface, using the PHP 8.1 environment
- problem when viewing the label filter in the grid
- problem when using the "sc_api_download" macro in the "run" type button
- "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.
- problem with comma handling in the message parameter of the sc_mail_send macro
- undefined variable $embedded_in_line_pdf
- problem when viewing navigation buttons using the sc_btn_display macro in the onLoad event
- problem in calendar event view using MySQL connection
- charset error when saving grid state
- undefined array key "arr_tipo_sql_look" error
- problem with label configuration and reload button hint on toolbar
- Undefined array key "concat" error
- Undefined array key "encryption" error when creating security module with LDAP
- problem when configuring API in production environment in PHP 8.1
- problem with label visualization in manual "lookup" in group by
- problem when using summary filter together with virtual fields in the total
- "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
- problem when configuring HTML printing to also print the graphic
- overlapping problem with fixed labels in the output modal in debug mode
- Fatal error: Uncaught TypeError: method_exists, when using file upload with storage API
- problem in viewing ajax output with fixed columns in the grid


ScriptCase 9.8.003 (64-bit)
Added:
- Added "Ignore accents" option in the filter configuration interface. The option to ignore accents considers accented and unaccented versions of letters to be identical for filtering purposes. Option available only for PostgreSQL type connection.

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


ScriptCase 9.8.002 (64-bit)
Fixed:
- problem when creating project in Italian language
- problem when using single quotes in the watermark of Form fields
- problem connecting to DB2 database using DB2 driver


ScriptCase 9.8.001 (64-bit)
Fixed:
- Fatal error: Uncaught TypeError: inarray() when performing quick search and dynamic filter
- "A non-numeric value encountered" error in develgeneratornm_gp_consulta_prep.php 668, when using '%' symbol in table width


ScriptCase 9.8.000 (64-bit)
Added:
- Added support for PHP 8.1 environments with Source Guardian

Fixed:
- Fixed problem when accessing SQL Server connections in Database Builder
- Fixed problem when synchronizing tables in the form


ScriptCase 9.7.023 (64-bit)
- Fixed issue in the Application List interface of tab applications


ScriptCase 9.7.022 (64-bit)
- Removed "get_magic_quotes_gpc" function call in PHP 7.4 environment. The function has been removed from versions 7.4 or higher.
- Fixed issue when uploading with filename containing "ç" in projects with ISO8859-1 charset


ScriptCase 9.7.021 (64-bit)
Fixed:
- problem in displaying background color of "Mac" layout in menu application
- problem with use theme background flag in menu application
- problem in displaying iframe properties in application links opening in modal
- problem in Excel export, when the title of the total contained a global variable
- problem in setting the width of layers in the menu
- problem when using tab navigation in menu applications


ScriptCase 9.7.020 (64-bit)
Added:
- Added support to hide grid detail header via sc_head_hide macro

Fixed:
- problem in displaying grouped buttons after search result without records in grid
- problem in image preview when informing file upload using the storage API. The error occurred when using the same file name with different content.
- problem with horizontal menu alignment
- problem when viewing the link application opening in iframe in a mobile grid
- problem with Quicksearch overlapping in grid when using advanced search label
- problem in the "label" view when selecting the calendar from the date field. The error only occurred on horizontal forms
- problem with horizontal alignment of the advanced search, when configuring and having an effect on the grid
- problem when displaying the title and collapse icon in the slide grid block on mobile
- problem after criticizing required fields in the last step of the form
- problem in shortcut to image directory for label icon on forms in advanced theme mode
- problem when viewing dropdown fields from mobile
- problem when viewing images in grid on mobile


ScriptCase 9.7.019 (64-bit)
Added:
- option to view the steps form on mobile. Option available in Layout : Pages
- option to view the steps form on mobile. Option available in Layout : Pages
- new sc_head_hide and sc_foot_hide macros
- new sc_head_hide and sc_foot_hide macros

Fixed:
- problem when viewing select2 in form fields on mobile devices
- problem when closing capture application after registration selection on mobile devices
- problem with editable grid (view) form modal on mobile devices
- problem when viewing the "date" field in the dashboard application index, using the DBLIB connection
- "Uncaught ArgumentCountError: Too few arguments to function", when performing the totalization of a virtual field configured with lookup
- problem with block title display in advanced search when the option to display block title is unchecked
- problem in validating group by, when selecting the automatic lookup method without informing the SQL command
- problem in displaying the header of an application redirected by the edit link when using mobile optimizations
- problem with Progress PDO connection failure
- problem in display of fixed label in "Select" column of applications with capture link
- problem in quicksearch result, using fields with reserved words or protected by double quotes
- problem when using the "date" field calendar in modal, in versions 8 and 9 themes. This type of visualization is available when the "New Calendar" option in the "date" field settings is deselected


ScriptCase 9.7.018 (64-bit)
- Added fixed column and form ordering options in express edition of applications

Fixed:
- problem when in Quicksearch using the Progress connection
- error Call to undefined function nm_psq_liga_cons, when running a grid application with the filter module disabled and the fields in quicksearch selected
- problem in generating PDF in Alma Linux 8.5 environment
- problem in synchronizing data dictionary langs in applications that have group by
- problem when viewing edit buttons on horizontal forms on mobile
- a problem with the fixed label working on mobile horizontal forms
- problem with text preview in mobile vertical grids (using more than one column per page)
- problem with displaying the height of form page tabs on mobile
- problem in displaying records in xls and xlsx export in grid applications with nested grids and left text alignment
- problem with initial value in the filter when configuring with zero
- issue of overlapping menu application theme color by project theme color


ScriptCase 9.7.017 (64-bit)
Added:
- option to "Display progress bar" in PDF export setting in chart application. The user will be able to choose whether or not to display the progress bar when generating the PDF. This will only be done when the "Generate PDF Directly" option is enabled.
- new property of the link "Open in another browser tab", in the links of the grid application

Fixed:
- Fatal error: Call to undefined method :gera_icone() when enabling the "Icon" option in document type virtual fields in grid applications
- problem with browser window opening when enabling "Display progress bar" option. From this release, the pdf will be generated in another browser tab.
- problem displaying discarded changes message when using signature type field in forms
- problem with loading the HTML editor when browsing editable grid forms
- conflict problem using the same field name with Scriptcase's internal function
- problem in displaying the modal window in the application toolbar button group interface
- problem with displaying "Print" and "Horizontal Line" buttons in the HTML Editor
- problem with the height of the HTML editor when the field is configured to be displayed on a form page
- problem in displaying grid fields in the side menu of the interface even after the option is disabled in the form


ScriptCase 9.7.016 (64-bit)
Added:
- option to "Display progress bar" in PDF export configuration. This will only be done when the "Generate PDF Directly" option is enabled
- mobile support for HTML editor fields
- feature to fix columns in horizontal forms (multiple records, editable grid and editable grid view)
- option to include records in modal, in the form with editable grid view orientation
- selection of fields that will be part of the editable grid (view), allowing different configuration of form fields
- new sorting icon types options on forms (set by theme or Font Awesome)

Fixed:
- Changed the text content of the advanced, dynamic and summary filter buttons to "Reset", in the English language
- problem in onGroupByAll event when performing calculations on fields
- problem when viewing the grid and summary export modules when the initial module was configured for PDF
- problem with Z-index of the option to save grid that was behind the application label
- problem when saving the option "Definition of the fields that will be displayed in the group by" in the group by field configuration
- problem in totaling a virtual field with negative values
- problem when viewing chart themes in the grid fields interface
- JS problem when using named fields with reserved words
- Parse error: syntax error, unexpected '' (T_NS_SEPARATOR), expecting identifier (T_STRING), when using global variables in "where" clause using JOIN in SQL. The error occurred when selecting some fields in the refined filter
- error when running application with theme for button that contains quote
- problem with lifetime setting of files in tmp directory


ScriptCase 9.7.015 (64-bit)
Fixed:
- PHP error in array_map() and array_fill_keys() Expected parameter, when using tcpdf library in blank application
- problem in field mask for different phone digits in the grid
- problem when adding the same regional setting using different charsets in the project language
- problem with refined filter when filtering a field with empty value in postgresql


ScriptCase 9.7.014 (64-bit)
Fixed:
- Parse error: syntax error, unexpected '(int)' (int) (T_INT_CAST) in grid and chart applications if using only one dimension
- Fatal error: Uncaught Error: Call to undefined function initializeFixedColumnsSummary, when enabling fixed column option in summary


ScriptCase 9.7.013 (64-bit)
Fixed:
- problem with sorting when grid has an INNER JOIN
- problem with fixed column when using nested grid configured with display below records
- problem in the option "fix column of options", when the detail module was disabled
- problem when using the "sc_redir" macro using the target as "modal" in the search application


ScriptCase 9.7.012 (64-bit)
Fixed:
- problem when making changes to the grid sorting tab
- problem displaying refined search labels in grid when exporting PDF
- error in the fix log when setting a directory in open_basedir
- Fatal error: Cannot redeclare initializeFixedColumnsGrid() when using fixed columns option in nested grid application
- problem displaying refined search labels after loading saved grid state


ScriptCase 9.7.011 (64-bit)
Added:
- fixed columns in the grid, freezes the data of the column during the horizontal scroll
- option to customize sort icons on field labels in grids

Fixed:
- problem with grid label overlapping on search label
- problem in console in the grid


ScriptCase 9.7.010 (64-bit)
Fixed:
- problem in tab colors on pages in the form
- problem with displaying bottom edge of last tile in Google Chrome browser
- error display problem in grid when removing radio type field from advanced search
- problem using the escaped comma in the hint parameter of the sc_link macro
- problem in displaying ajax events in grid fields after refined search
- problem with displaying Font Awesome icons on form buttons when using RTL languages


ScriptCase 9.7.009 (64-bit)
Fixed:
- problem with help indexes in the interface
- problem in creating FTP publishing directories without common libraries


ScriptCase 9.7.008 (64-bit)
Fixed:
- problem on the searching of the "select" field in the dynamic filter, when the field was not available in the advanced filter
- issue with displaying refined filter on mobile when "start as" option is collapsed


ScriptCase 9.7.007 (64-bit)
Added:
- Added the functions "scHideUserField" and "scShowUserField" to enable or hide fields in the html control application through the macro "sc_field_display". NOTE: The documentation of the new functions is available in the application itself through the "CHECK" button.

Fixed:
- Fixed issue when starting the search in the tag filter
- Fixed problem sending the email from the application "app_form_add_users" in the security module. It will be necessary to recreate the module.
- Fixed the login html templates in the external samples project library. The templates were modified to enable or hide the fields according to the settings informed in the security module.


ScriptCase 9.7.006 (64-bit)
Added:
- visualization in dashboard format in the grid detail on mobile
- new mobile options in the express edition

Fixed:
- problem with the refined filter collapse/expand option, with the filter module unchecked
- problem with layout when exporting the chart application
- problem in the fixed label that was duplicated in the mobile grid application
- problem in the fixed label that was displayed above the refined filter button in the mobile grid application
- problem in the login html template in the external project samples library. The templates were modified for the new security module fields
- problem when using capture link with special character in the captured field value
- problem when opening quicksearch dropdown in form applications using mobile devices
- problem in updating the procedure in the Editable Grid View form. The value was not being updated
- problem when editing or deleting the example Business project
- problem in form printing export with mobile optimization
- problem when viewing the toolbar of applications from the security module on mobile. It will be necessary to recreate the module
- problem in the "cancel" button in the "grid save" with the mobile option disabled


ScriptCase 9.7.005 (64-bit)
Added:
- Added option to generate mobile toolbar as simplified or free
- Added option to select year and month in mobile calendar

Fixed:
- Fixed error of "grid_save_grid.php not found" in the browser console, when running the grid application using the Enable mobile optimization option
- Fixed problem in the display of the scrollbar, using the Firefox browser in the "Insert Code" of the events


ScriptCase 9.7.004 (64-bit)
Forms with mobile optimization:
- Automatic optimization while accessing on mobile devices! features included
- Toolbar horizontal with scrolling, optimized mobile panels, fixed bottom toolbar, new scroll up button

Calendars with mobile optimization:
Automatic optimization while accessing on mobile devices! features included:
- 100% usage of the screen, new dates panel, calendar form with mobile optimization

New powerful security module options:
Profile image upload option and a new ‘Settings’ option within the security module, once enabled the ‘sys-admin’ end-user can change options such as:
- Session expiration action, remember me, expiration time cookie, retrieve password, new users creation, Brute force options, and 2FA options


ScriptCase 9.7.003 (64-bit)
Added:
- mobile optimization for form application
- mobile optimization for calendar application
- User profile image upload option in security module
- new 'Settings' option to end user in security module

Fixed:
- problem in the filter's clear button, in the checkbox type field, configured as manual lookup
- problem in formatting numeric fields passed as a parameter in the link The field was being formatted when using the open property in another window
- problem in the HTML printing of the grid, configured with static group by and the option to start treeview closed At the time of printing it only displayed the first record
- issue in the mobile grid toolbar, which only worked when there were buttons configured on the desktop toolbar
- issue with advanced filter mobile toolbar buttons It was only displayed in the mobile application if there were buttons on the desktop toolbar
- damaged file issue in macOS scriptcase installer
- problem in redirecting "sc_redir" macro to the pdf report application


ScriptCase 9.7.002 (64-bit)
Fixed:
- Fatal error: Uncaught Error: Call to undefined function NM_is_utf8() when using modal option in refined filter search
- problem when using the option "Rule Ordering" in the configuration of the grid sorting rules. The sorting was not being applied
- problem in displaying the format of "date" type breaks in Spanish
- problem in the display of the Exit (Back) button in the grid summary
- problem in generating applications when enabling the new mobile flag. Error: substr() expects parameter 1 to be string, array given


ScriptCase 9.7.001 (64-bit)
Added:
- new sample project: "Restaurant"

Fixed:
- problem in assigning value to a lang in the generated application
- error "Undefined variable: arr_def_proj" when creating the calendar application
- problem with size of tab margin-top in menu application
- problem when using the detail application, from a master/detail, in a step of the step form
- problem in creating tables during manual installation with MySQL connection, in PHP 7.0 environment
- problem in displaying "show" option items in menu toolbar interface. When changing the button type, some options were disabled
- problem in recognizing global variables in tab applications
- download file issue for damaged MAC OS
- problem in displaying alert message when adding a new language in the project
- problem in viewing the help of macros in events


ScriptCase 9.7.000 (64-bit)
Added:
- mobile optimization for grid, menu and chart applications
- Form Multi-Steps
- Two-Factor Authentication (2FA) to the security module
- API email configuration support in security module
- improvements to Refined Search
- new chart options (Zoomline, Scrolling and Overlapping)
- new sc_btn_disabled macro
- new sc_btn_label macro
- new sc_get_wizard_step macro
- new parameter "reply_to" in sc_mail_send macro

Fixed:
- error when generating source code for Online Shop project
- connection issue in CRM project when using SQL Server Native SRV PDO driver
- problem when using reload button when adding records
- sorting problem with column type CBLOB, BLOB and LONG, using Oracle database
- problem saving API in production environment, due to webkit update in some browsers
- problem when returning to the query application when using sc_redir macro in advanced search


ScriptCase 9.6.018 (64-bit)
- Added option to allow editing of records from capture link to forms and search fields

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


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


ScriptCase 9.6.016 (64-bit)
Fixed:
- parse error: syntax error, unexpected '"', when using checkbox field with multiple values
- problem in displaying the WORD option when exporting the chart
- scrolling problem in methods interface


ScriptCase 9.6.015 (64-bit)
Fixed:
- problem when exporting PDF on forms with pages
- problem in the initial value of special search criteria in DATETIME fields
- problem in WORD export of grid summary
- problem when using sc_error_message macro in the grid's onClick event
- problem when using fields to select multiple values, with Select2


ScriptCase 9.6.014 (64-bit)
- Improved connection interface: Microsoft Azure, Amazon RDS and Google Cloud and ODBC connection interface
- It will needed to clear your browser cache
- Added the sc_api_gc_get_url and sc_api_gc_get_obj macros to generate the "token" parameter, to be used in the sc_api_upload macro of google drive
- Fixed problem in displaying the cursor for typing when using the "Display the Select2 search area" option
- It will needed to clear your browser cache
- Fixed problem with fixed label alignment
- Fixed problem when using "Navigation" option in the mobile tab of the menu


ScriptCase 9.6.013 (64-bit)
- Fixed problem when viewing events on the calendar with weekly and daily view


ScriptCase 9.6.012 (64-bit)
Added:
- Improved data visualization in SQL Builder
- Added option to convert charset to UTF-8 by database in project properties. This option will convert the characters sent by the server to UTF-8, according to the database charset. As of this update, new projects will be created with this option enabled, which can be unchecked in themenu interface Project -> Properties.

Fixed:
- 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


ScriptCase 9.6.011 (64-bit)
Added:
- support for utf8mb3 and utf8mb4 client encoding on MySQL connection

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


ScriptCase 9.6.010 (64-bit)
- Fixed display problem with the mini calendar
- Fixed problem in the treemenu tabs, using language or theme options


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


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


ScriptCase 9.6.005 (64-bit)
Added:
- Added tab to choose values ​​when the option is date range in the summary filter fields

Improved:
- Improved performance when generating the source code of the project applications

Fixed:
- 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


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


ScriptCase 9.6.003 (64-bit)
- Change log not available for this version


ScriptCase 9.6.002 (64-bit)
Added:
- option to Save HTML tags and Javascript text input in text fields of the control application
- support for .webp files in the Scriptcase image manager
- support for PostgreSQL connection charsets to the production environment's encodings list
- "Keep old aspect of uploading files" option in the project properties

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


ScriptCase 9.6.001 (64-bit)
- 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 in the HTML control application

Added:
- Added "Error Display" option, located in the HTML control application settings
- NOTE: This feature will only work when the SweetAlert option is disabled

Improved:
- Change in the HTML control application. From that version, the "submit" will be done via Ajax

Fixed:
- 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&quo