ProgDVB (64-bit)

What's new in this version:

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" in menu applications


ScriptCase 9.6.000 (64-bit)
Upgrade:
- Added "Notify discarded changes" option in the express edition
- Added "Keep me connected" option in the security module
- Added "Label position" options, including watermark, to the security module
- Added new format and options for the "Save grid" feature
- Added "Persist State" button to save data in the application session
- Added "Inherit from grid" option to group by lookup fields
- Added a new vertical alignment option for applications
- Added tag "below the field" in the fields of the form and grid applications
- Added new format for displaying the date field: Watermark
- Added new "sc_statistic" macro to perform calculations and statistics
- Added Table Width Unit and Table Width options in the express edition
- Added "Fixed columns" option for Grid's summary group by
- Added “100% width inputs” option in the settings of the control and form applications

Added:
- Added new security feature "Referrer-Policy" in applications
- Added new security feature "Feature-Policy" in applications
- Added new security feature "Permissions-policy" in applications
- Added new security feature "Content-Security-Policy" in applications
- Added new security feature "Strict-Transport-Security" in applications
- Added new security feature "X-Frame-Options" in applications
- Added new security feature "X-Content-Type-Options" in applications

Fixed:
- Fixed problem with the interface of the summary filter fields using the Firefox browser
- Fixed problem in viewing application images
- Fixed problem in the label of dynamic and static group by, with more than one field, in the grid and chart apps
- Fixed problem with XML export in columns containing the letter "V" in the Grid
- Fixed problem in the "After Inclusion" message from the form application, when called via a field link
- Fixed delay problem when returning a large number of records in autocomplete fields, in the advanced search
- Fixed problem when selecting condition saved in advanced search chart
- Fixed problem with a PDF export page break when using slide orientation and initial module as PDF
- Fixed problem in redirection when using the sc_link macro in vertically oriented grids
- Fixed problem in displaying the values ​​inside the chart bars in PDF export
- Fixed problem when using numeric initial in form application names in express creation
- Fixed problem in viewing selected tabs in SQL Builder
- Fixed problem in viewing the field options in the PDF Layout interface
- Fixed problem when using the lookup in the field in the PDF Layout interface, using a connection other than the main connection
- Fixed problem with clickatell API
- Fixed problem with FTP publishing using port other than the default
- Fixed problem with "undefined" alert display when moving events in the calendar
- Fixed problem with displaying events in the calendar when the category filter is visible


ScriptCase 9.5.003 (64-bit)
Added:
- Added option to use SweetAlert2 in the security module
- Added password display option (toggle password) at login of the security module
- Added option of extensions allowed by file size in image and document upload fields

Fixed:
- Fixed problem when saving search status in TIME type field in the advanced search
- Fixed problem with save and return buttons in the API in the production environment. (It's Necessary to update the production environment)
- Fixed problem with the macro help icon
- Fixed problem with the scroll bar display in the Firefox browser, when opening several applications in the interface
- Fixed problem when clearing auto-complete field value, using select2, in the advanced search


ScriptCase 9.5.002 (64-bit)
Added:
- Added option for clickable drag and drop area in the upload fields

Fixed:
- Fixed Fatal error: Uncaught Error: Call to undefined function GuzzleHttpHandleris_countable using Google Drive API with PHP 7.0
- Fixed error Undefined Index lang_btns_reload_hint when generating applications using the Reload button
- Fixed display problem in the tabs of applications opened through the menu
- Fixed problem in applications using Sweet Alert


ScriptCase 9.5.001 (64-bit)
- Fixed problem assigning values to fields through the onRecord event


ScriptCase 9.5.000 (64-bit)
Added:
- new Google Drive API
- new DropBox API
- new Amazon S3 API
- reload button in grid applications
- reload button in chart applications
- reload button in summary applications
- reload button in form applications
- Guaba theme for project applications
- BlueBerry theme for project applications
- Lemon theme for project applications
- new example project - Point of sales
- new macros sc_api_download and sc_api_upload
- options to connect to Amazon RDS databases
- options for connecting to Microsoft Azure databases
- options for connecting to Google Cloud databases
- options for connecting to Oracle Cloud databases
- new toggle to show or hide passwords
- new image viewer for grid, form and control
- option to remove application borders on dashboard widgets
- a new value "sc_format_region" to the "Output Format" parameter, in the sc_date_conv macro
- sc_set_export_name and sc_set_json_name macros for exporting grids and charts
- option to generate JSON directly
- file size option in the Multi-upload field settings
- new layout for quicksearch in the grid and form applications
- options to display automatically or manually application columns in quicksearch fields
- custom order of search criteria in quicksearch
- search for DATE type fields in the quicksearch of the grid and form
- feature to highlight terms searched in quicksearch
- option to notify discarded changes


ScriptCase 9.4.032 (64-bit)
- Documentation improvements


ScriptCase 9.4.031 (64-bit)
Added:
- "Differentiate uppercase/lowercase letters" option in the control application

Fixed:
- Fixed problem when creating procedure application in PHP 7.3 with SQL Server connection
- Fixed problem with blank values in fields of type Select on the form


ScriptCase 9.4.029 (64-bit)
Added:
- ILIKE command in the searching autocomplete text field

Fixed:
- problem when using concat or sc_concat macro in automatic text type lookup
- problem when using manual lookup (Multiple values ​​(position)) on the form
- problem when exporting grid summary when using group by and JOINs in SQL
- display size error for a field with select2 and Ajax reload in the search
- problem when using < > characters in the lookup title in Select fields


ScriptCase 9.4.028 (64-bit)
Fixed:
- problem that disabled the field overlaid by SweetAlert's toast on the form
- problem in JSON export with summary module, initially disabled
- problem with conflict internal variables used with sc_lookup macro
- problem with the return of the lookup on groupby with multibyte characters
- problem when using Ajax event on fields with slider enabled
- Javascript error when using apostrophe in refined grid search
- problem with image quality resized in the PDF report
- Invalid argument supplied for foreach() error when creating a project without a selected theme
- Undefined variable error when creating project with Oracle and PostgreSQL connection
- problem when defining exports generating directly, as the initial grid mode
- problem with updating the date when dragging events from the calendar
- problem with Summary button in grid with dynamic groupby
- problem when using "Search" option, in the field updates connection table, in PostgreSQL connection
- problem in viewing manual lookup records for multiple values ​​(position) in the grid
- problem in using index fields in dashboard, with non-UTF-8 characters
- problem in the export chart application
- problem with CHARSET in the search values, in the chart application


ScriptCase 9.4.027 (64-bit)
Added:
- Added option to run application after creating grid, form and calendar
- Added option to also create a form when creating the grid
- Added option to export JSON in grid and chart applications

Improved:
- Improved interface for creating projects

Fixed:
- Fixed problem when defining target parameter as modal, in the sc_redir macro
- Fixed problem when changing user privileges in Scriptcase administration
- Fixed problem in viewing fields after deleting the nested grid
- Fixed problem in the value of Excel export, when the field has a complex SQL lookup
- Fixed problem when selecting named field with space, in widget filter on dashboard
- Fixed problem in the visualization of the virtual field with summary in Excel export
- Fixed problem in displaying dynamic group by after converting the project
- Fixed problem when performing the sorting by the group by field, using Oracle connection
- Fixed problem when selecting a row for editing in SQL Builder
- Fixed problem with duplication in editing form fields
- Fixed problem in the security module with MariaDB connection and encode utf8mb4_general_ci
- Fixed problem when using columns named with special characters in SQL Builder, using Progress connection
- Fixed primary key detection problem in forms with Progress connection
- Fixed problem in the visualization of images after inclusion or alteration, using SQL Server Native SRV PDO driver
- Fixed problem in Excel export of the summary, in XLS format


Scrip