Scriptcase V9.9.x

Released: Nov 22, 2022

Updates in V9.9.x

9.9.024

Updated Oct 26, 2023

Fixes

  • Fixed problem when creating special conditions for the date field in the search.
  • Fixed "Undefined array key image_path" error in application layout after project conversion from Scriptcase version 8 to 9.
  • Fixed problem with the "Break" and "Configurable graph" buttons not being displayed in the query summary toolbar.
  • Fixed problem with creating an extra directory when generating the publication ZIP in a Windows environment.
  • Fixed problem when using JavaScript method passing parameters.
  • Fixed "Undefined array key backgroundColor" error when creating a new item in the "My toolbar" resource.

9.9.023

Updated Oct 17, 2023

Fixes

  • Fixed "Warning: Undefined property: stdClass::$orgtable" error when executing a SQL command in the Database Builder within the SQLite connection.
  • Fixed problem displaying inputs and confirming log module creation.
  • Fixed problem displaying the results of commands executed in SQLbuilder.
  • Fixed problem importing projects and applications into Scriptcase.

9.9.022

Updated Oct 12, 2023

Fixes

  • Fixed "Not Found" error when generating zip file in deploying and exporting applications and projects.

9.9.021

Updated Oct 10, 2023

Features

  • Added the ability to change documentation display in the Scriptcase interface: Online and Offline.
  • Added the ability to change documentation language in the Interface: English and Spanish.
  • Added new parameters to encrypted connection in Microsoft SQL Server.

Fixes

  • Fixed "Fatal error: Uncaught TypeError: Unsupported operand types: string + int" in the application interface menu.
  • Fixed trim() error: Passing null to parameter #1 ($string), in the grid application generated by the log module, using the Informix connection.
  • Fixed problem saving options configured in the connection security tab, after project creation.
  • Fixed problem with using 0 (zero) in the "Complete left" option in the Form text field.

9.9.020

Updated Sep 14, 2023

Features

  • Made adjustments to the interface for editing form application fields. From this release onwards, the insertion and update columns for fields that are not selected in the application will be disabled.

Fixes

  • Fixed problem when using application synchronization in the security module with access connection.
  • Fixed problem with displaying date and time fields in the calendar field listing.
  • Fixed problem with deleting the master detail on mobile. A Fatal error was generated: require_once(): Failed opening required.
  • Fixed problem when creating the form application, using the mandatory field settings in the data dictionary. Required field configuration was not being reflected upon creation or sync.
  • Fixed problem in generating langs in the data dictionary, when there were quotation marks in the field name.
  • Fixed Fatal error: Uncaught TypeError: Unsupported operand types: string * int in calculations in fields of type "data", in the PHP 8.1 environment.
  • Fixed problem translating the calendar in the date field in the filter into other languages.
  • Fixed problem with button alignment configuration in the HTML editor.

9.9.019

Updated Aug 31, 2023

Features

  • Improved management and positioning of fields in application interface.
  • Added 'sc_field_no_validate' macro for form, control and calendar applications.
  • Added 'Display field error in a modal' option in express editing.
  • Added support for 'wkhtmltopdf' on Linux operating systems based on RedHat 9.

Fixes

  • Fixed problem when using "disable field" option or "sc_field_disabled" macro in "select" type field with capture link. The link icon next to the field was not being hidden.
  • Fixed problem when creating the grid, when adding a WHERE clause in the SQL with the option to create the form for editing enabled.
  • Fixed problem when creating a grid, when unchecking some fields in the "edit fields" tab, if the option to create a form to edit the grid was enabled.
  • Fixed problem in validating the control application, when pressing the "Enter" key on the keyboard.
  • Fixed "Fatal error: Uncaught TypeError: trim(): Argument #1 ($string) must be of type string" in N:N relationship, after reloading the form from a field of type Select.
  • Fixed error "Incompatible data type in the criterion expression.", when performing an advanced filter with a field of type DATETIME in Access.
  • Fixed "Undefined array key grid_break_fixa" error when individually applying the "Fixed breaks" option in express editing.
  • Fixed Fatal error: Uncaught com_exception when importing Access base.
  • Fixed Fatal error: Uncaught Error: Call to undefined method Swift_Mailer::disconnect(), when clicking "Forgot your password?" on the Scriptcase login screen.
  • Fixed error when generating production environment via zip or tar.gz in advanced publishing.
  • Fixed problem when recovering password through a link in the security module.
  • Fixed a problem with fields not being displayed in the Form's SQL configuration, after some change was made in the option to define primary keys.
  • Fixed problem displaying calendar in advanced filter label after grid search.
  • Fixed a problem in the macro "sc_field_disabled" when using it in the data field with the false parameter. The calendar icon next to the field was displayed twice.
  • Fixed problem in master detail view on mobile.

9.9.018

Updated Aug 24, 2023

Features

  • Visual improvement in the application creation interface.

Fixes

  • Fixed Fatal error: Uncaught TypeError: trim(): Argument #1 ($string) in subselect field with image in Report Pdf application with PostgreSQL connection.
  • Fixed problem when configuring an initial application in the menu application.
  • Fixed problem in validating fields in the creation interface of the calendar application.
  • Fixed problem when uploading files in the "app_data" directory when deploying. From this version on, it will only send files referring to deployed applications.

9.9.017

Updated Aug 20, 2023

Features

  • Added support for global variables in grid buttons labels.
  • Added SQL grid sorting option.

Fixes

  • Fixed error "Undefined array key" vert_campos".
  • Fixed problem with alignment of title in multi-record form.
  • Fixed problem with linking HTML image field in control application when using the "open in another tab" property in link operation mode.
  • Fixed problem with display of FusionCharts Trial version message in manual calls to the library.
  • Fixed problem with visual with converted project buttons.
  • Fixed problem with the functionality of the sc_apl_default macro.
  • Fixed problem when opening the project with the "Save metadata cache to disk" option enabled, if the MSSQL Server extension module was disabled. Scriptcase redirected to login.
  • Fixed problem with background color in WORD export.
  • Fixed errors "Undefined array key" vert_campos", "sem_tag_php", and array key "sc_field_0" in PHP 8.1 environment.
  • Fixed problem with executing SQL command using sc_exec_sql macro in onValidate event with Oracle connection.
  • Fixed problem with the display of end time in week or day calendar application.
  • Fixed problem with line break in the display of week or day calendar application.
  • Fixed problem with layout with calendar application buttons on mobile.
  • Fixed fatal error count() when using validation {sc_mail_ok} in blank.
  • Fixed errors in the browser console in calendar application.
  • Fixed problem when deploying applications unchecking common files.
  • Fixed error 2 = Undefined array key when generating procedures in SQL Server.

9.9.016

Updated Aug 7, 2023

Features

  • Added width option in the 'use checkbox in dropdown in filter select' option.
  • Added criticism when trying to create an application with its name starting with a number.
  • Improvements in the first access screen of the production environment: Added CAPTCHA and removed default password splash screen.
  • Removed sc_pub_(date_time) directory from ZIP file generation on publication.

Fixes

  • Fixed error "2=Undefined array key 0", when generating source code of grid applications in environments with PHP 8.1.
  • Fixed count() error: Parameter must be an array or an object that implements Countable - nmPageServRestore2.class.php line: 116, on project import.
  • Fixed display error for the "window.open" method when selecting the "Toolbar buttons" option in express edition.
  • Fixed error foreach() argument must be of type array|object, null given | nmRestoreGroups.class.php line: 71 on project import.
  • Fixed error Undefined array key "dbms", when empty was selected in field "Connection" when creating a new application.
  • Fixed errors Undefined array key "entries" and Trying to access array offset on value of type null", when creating a Procedure application.
  • Fixed Fatal error: Uncaught TypeError: count(): Argument #1 ($value) on project import.
  • Fixed Parse error: syntax error, unexpected identifier "_grid_saveFixedColumnsGrid", when defining the initial of the grid name with a number or dash.
  • Fixed problem when importing saved SQL statements in SQL Builder
  • Fixed problem when inserting record with line break in form with multiline text field.
  • Fixed problem when listing pending connections in advanced publishing.
  • Fixed problem with calendar events not being displayed after insertion.
  • Fixed problem with the application's modal not being closed when the source application was a menu.
  • Fixed problem with the ZIP file not being removed when an SFTP publication was performed with just common files.
  • Fixed crash problem when generating the Excel file of the Procedure application.
  • Fixed problem with project creation on the project theme selection screen. No theme was being set as default.
  • Fixed problem in the formation of "data" type fields, when using the "definition of fields that will be displayed in the break" option.
  • Fixed problem when passing a parameter to the chart application's SQL.
  • Fixed problem in the synchronization of applications in the security module.
  • Fixed a problem when viewing a newly created table when creating an application with an Oracle connection.
  • Fixed problem in the look of the calendar buttons.

9.9.015

Updated Jul 18, 2023

Features

  • Improved the production environment interface
    • Completely redesigned the interface, added password recovery functionality, and implemented automatic updates for the production environment.
  • Improved Scriptcase libraries
    • Cleaned up the libraries, removing obsolete and unused ones while updating those in old versions.
  • Added new macro 'sc_lookup_field'
    • This macro allows the developer to execute a SELECT command at a time and have access to the data returned through the dataset parameter, in array format: {dataset[line_number][field_name]}.
  • Added support for Column Selection and Linking between applications in a grid with vertical orientation.
  • Added support for password recovery in the production environment.
  • Added the option in deployment to generate a page containing a link to the initial application.
  • Improved opening mode for downloading files from the "Document (File Name)" data type.

Fixes

  • Fixed problems displaying charts in applications from the Documents Library sample project.
  • Fixed problem with date field format during ajax processing.
  • Fixed problem when viewing blocks in a tab in the modal window of the editable grid form.
  • Fixed problem in viewing the description in the lookup of numeric and zip code fields in the form.
  • Fixed problem with calculator visualization on mobile devices when in form fields with horizontal orientation (multiple records and editable grids).
  • Fixed problem using confirmation message on action buttons.
  • Fixed problem when saving API edition in deployment environment.
  • Fixed a problem when reloading the grid page when configuring the details below.
  • Fixed problem when generating the diagnosis in the development environment.
  • Fixed problem displaying font color on selected tab in form application.
  • Fixed problem with Ajax-type action buttons in environments with PHP 8.1, when created after the first execution of the grid application.
  • Fixed problem with the upload modal crashing in the image manager, after uploading the image.
  • Fixed problem with returning to the login screen after accessing a project that contains an Oracle and SQL Server connection in Linux and macOS environments.
  • Fixed problem with the sc_btn_disabled macro not working in the Form application.
  • Fixed a problem with the connection to the database not being displayed in the interface, when opening and saving it.
  • Fixed problem with the label not being aligned in the summation of the summary.
  • Fixed problem with display when clicking on the calendar icon in a date and time type field in form applications.
  • Fixed problem when using the calendar of the "date" field in modal in the search application. This type of view is available when the "New Calendar" option in the "date" field settings is unchecked.
  • Fixed problem when using the SQL_NO_CACHE function in the grid's SQL.
  • Fixed problem when using sc_change_css() macro in field with "." (point).
  • Fixed error Undefined array key "t_text" when accessing the "Field Positioning" option of the Form in environments with PHP 8.1.
  • Fixed error Undefined array key "lang_subject_mail", when accessing project messages interface in environments with PHP 8.1.
  • Fixed problem with displaying the sc_lookup_field macro message, when it was not used, in the version with an expired upgrade.
  • Fixed error Connection attempt failed: SQLSTATE[42704]: Undefined object: 7 ERROR: unrecognized configuration parameter "bytea_output", when trying to connect to PostgreSQL on Amazon RDS.
  • Fixed error when using the "Grand total" option in the chart application.
  • Fixed problem with displaying the sc_lookup_field macro message, when it was not used, in the version with an expired upgrade.

9.9.014

Updated May 22, 2023

Features

  • Added the option to view diagnosis info in production environment.

Fixes

  • Fixed tab bar and refresh button when scrolling, in project default values interface.
  • Fixed error Undefined array key "b_bor_collapse", when editing blocks through advanced filter.
  • Fixed problem with SQLITE database access in Database Builder.
  • Fixed problem with not changing the language of the applications, when defining another default language for the project.
  • Fixed problem converting projects from version 8 to version 9.
  • Fixed problem when creating a calendar, using the option to create a table.
  • Fixed problem in retrieving "data" type fields using the "sc_lookup" and "sc_select" macros in the Native SRV driver of the SQL SERVER connection.
  • Fixed problem in viewing themes in the viewing interface, in licenses with expired upgrades.
  • Fixed problem in using procedures with rollback in environments with DBLIB driver.
  • Fixed problem with numeric fields in advanced filter when changing regional setting.

9.9.013

Updated May 5, 2023

Features

  • Added the option to reload tables and fields in field lookup.
  • Added the option to reload tables and fields in Dashboard index.
  • Improved usability when performing dynamic group by.

Fixes

  • Fixed problem displaying errors on the console when performing a restore.
  • Fixed a problem with the display of sorting icons in the Summary PDF.
  • Fixed problem displaying fields in the grid search tag in the mobile version.
  • Fixed problem with data display when configuring group by month and year in the grid.
  • Fixed problem with macro sc_vl_extenso() with application language in English.

9.9.012

Updated Apr 27, 2023

Features

  • Added header security options on unauthorized user pages.
  • Use passwords on generated applications.
  • Added header options in security module applications. The options will be included when creating a new security module from this release.

Fixes

  • Fixed problem with confirmation button on delete file screen in internal library.
  • Fixed problem when leaving the minimum value and maximum value fields empty in the data dictionary interface. A SQL error was being generated.
  • Fixed problem in saving the minimum and maximum value fields in the data dictionary interface.
  • Fixed problem in creating the data dictionary with the option to associate repository with connection.

9.9.011

Updated Apr 24, 2023

Fixes

  • WhatsApp API (ChatApi) has been removed due to it being discontinued.
  • Fixed problem exporting PDF via email: strtolower(): Passing null to parameter.
  • Fixed problem when performing search in dynamic filter and quicksearch.
  • Fixed "Invalid argument supplied for foreach()" error when generating data dictionary in PostgreSQL connection.
  • Fixed problem in viewing the list of projects after displaying the outdated version message.
  • Fixed problem in the action bar color editor when setting a color and not displaying correctly.
  • Fixed Undefined array key "t_name" error when accessing label type field settings.
  • Fixed problem with alignment of ordering icons in vertical grid.
  • Fixed problem when saving the "Hint" option in the properties of a "field" link.
  • Fixed state non-persistence issue when updating "Date display position" and "Display date format" options in the default values interface.
  • Fixed problem with quicksearch and navigation buttons not being displayed in the "form_sec_users_apps" application in the security modules per application and LDAP with full control.
  • Fixed error of Undefined array key "cod_grp" when performing a manual installation using the MySQL database.
  • Fixed problem with mobile resource definition loss in the Scriptcase interface after importing projects.
  • Fixed Undefined array key "css_btn_list_new" error when accessing the "Themes for buttons" option.
  • Fixed problem with the shortcut key for the new button in the edit link, if the option to use shortcut keys is activated.

9.9.010

Updated Apr 11, 2023

Features

  • Added a new option to compress files before sending in SFTP publishing.

Fixes

  • Fixed problem with button group option in action bar when loading grid quicksearch.
  • Fixed error with array key "nm_lang_locale" in "Subselect" field configuration in ReportPdf application on PHP 8.1 environment.
  • Fixed error 2 = Undefined array key "display_position" in grid application.
  • Fixed problem with displaying the "check" icon in the grid "Run" button. The icon was being shown 2x.
  • Fixed problem with viewing the "check" icon on the action bar button. The icon was being displayed 2x.
  • Fixed problem displaying the "check" icon on buttons being called through the display macros in the menu application. The icon was being displayed 2x.
  • Fixed problem with executing the Ajax button created from the action button when using the macro "sc_link" in the Onrecord event of the grid. The button code was not being executed.
  • Fixed problem of not styling the group label in nested grids.
  • Fixed menu creation problem in PHP 7.0 and 7.3 environments.
  • Fixed problem when viewing new tables in the data dictionary when the "save metadata cache to disk" option is enabled.
  • Fixed problem in express creation when checking the option to generate source code.
  • Fixed error when saving change in group by fields.
  • Fixed "Fatal error: Uncaught Error: Call to a member function getColumnMeta()" when using the macro sc_select() in a PHP method called by a field of type HTML Image with Ajax event.
  • Fixed "access array offset" error when creating security module.
  • Fixed problem when closing grid with filter in a capture link.
  • Fixed Undefined array key "pub_sftp_zip_file" error on the publication type selection screen.
  • Fixed problem with fixed label when fixed toolbar option is active.
  • Fixed problem with missing some files when publishing via SFTP, with the option "Compress files before sending" unchecked.
  • Fixed missing lang of the "Highlight results" option in express editing.

9.9.009

Updated Mar 24, 2023

Features

  • Added the option to display configuration of chart grid fields as an icon.
  • Added visual customization of grid field titles.
  • Added fixed toolbar in grid.
  • Added aggregation of rating fields.
  • Added support for displaying rating fields in grid group-by.
  • Added field grouping option to the grid.
  • Added button grouping option to action bar.
  • Added label configuration option to action bar.
  • Improved performance when creating applications using an Oracle connection.
  • Improved connection performance.
  • Improved internal library interface.
  • Visual improvement in the 'field grouping' sorting dropdown on mobile devices.

Fixes

  • Fixed problem when editing the application when the auto save option was activated.
  • Fixed problem when synchronizing the form with the option to save metadata cache on disk enabled.
  • Fixed problem when saving the nested grid interface in a license without entitlement.
  • Fixed problem in grid Ajax events when using SQL fields with JOIN between tables.
  • Fixed Undefined array key "hint" error in PHP 8.1 environment.
  • Fixed problem of display red background when converting menu type.
  • Fixed problem when creating blocks in the application with the auto save option activated.
  • Fixed a problem when viewing the options selected in the express edition of applications.
  • Fixed problem with ordering grouped fields with fixed label deactivated.
  • Fixed problem when accessing the project with connection failure. The scriptcase was logged out.
  • Fixed problem with displaying the "Back to top position" option in express editing.
  • Fixed error when saving changes in the field on group by.
  • Fixed "Use Security" option not working in express edition.

9.9.008

Updated Mar 23, 2023

Fixes

  • Fixed Undefined array key "mysql_ssl_cipher" error in MySQL connection when using SSL in PHP 8.1 environments.
  • Fixed SQL errors during source code generation of example CRM project with Firebird database.
  • Fixed SQL errors when generating the Documents Library project source code, with PostgreSQL and SQLite databases.
  • Fixed issue with Excel export crashing in the grid, due to the formatting of "percent" type fields.
  • Fixed an error that failed to compile in applications that had a friendly URL, at the end of the publication generation done through the "Publish" button at the end of the source code generation.
  • Fixed problem in Healthcare Project created with SQLIte database.
  • Fixed a problem when creating applications in the Access type connection, when using a table column with the reserved word "MOD".
  • Fixed problem when creating the form, using the "Foreign key optimization" option and the MySQLi connection.
  • Fixed problem in the "Value range" option for numeric values in the summary filter. The typing component was not created.
  • Fixed problem when selecting ODBC connection in SQL Server, Oracle, Db2 and Sybase connections. The connection driver was not being listed.
  • Fixed problem when importing example projects using MySQL connection.
  • Fixed Fatal error: Uncaught Error: Undefined constant "SCEOT" in the modal of WORD and RTF exports in the chart applications.
  • Fixed "Undefined array key" and "Trying to access array offset on value of type null" errors when accessing some options for editing application themes.
  • Fixed errors of Undefined array key "summary_export_xml_pwd_pwd" and "label_watermarked" in grid application, when using PHP 8.1 environment.
  • Fixed error "foreach() argument must be of type array|object, null given", which occurred when creating Generic ODBC connections.
  • Fixed "Uncaught Error: Call to undefined function sc_logged()" error, which occurred when trying to login with 2-factor authentication using the email API.
  • Fixed SQL errors when generating the source code of the Onlineshop sample project with a MySQL database.
  • Fixed problem with not displaying the rating field icons (star, smile and thumbs), when printing the Grid and the Summary.
  • Fixed Undefined array key "display" error, which occurred after saving some application themes at the public level.
  • Fixed error of Undefined array key "display", when editing menu application in PHP 8.1 environment.
  • Fixed Fatal error: Uncaught Error: Call to a member function initialize_arrays() on null, when executing the procedure using the SQL SERVER connection.
  • Fixed "Internal Server Error" and missing files when publishing projects via SFTP.

9.9.007

Updated Jan 19, 2023

Fixes

  • Fixed problem with outdated display of project messages on the submission screen to Scriptcase.
  • Fixed problem when navigating between folders in the project's message interface, after displaying an alert about unsaved changes.
  • Fixed problem with filter buttons being displayed when there are no records found in subqueries with Iframe.
  • Fixed problem with the sc_btn_disable and sc_btn_label macros not working, when the button is created with a space.
  • Fixed problem in the control application when using the sc_error_message macro and enabling the "Script error" option in settings.
  • Fixed problem when deleting autocomplete type records when using grid fields in forms.

9.9.006

Updated Jan 12, 2023

Features

  • Added support for resizing message inputs in the Application Translation tool.
  • Added the option to open div below or in modal in express editing and default values.
  • Added "Available Fields" and "Selected Fields" titles in the drag and drop boxes of the ordering, columns and select fields of the export in general, in grid application.

Fixes

  • Fixed issue when deleting project message indexes that contain spaces in the name.
  • Fixed problem with missing libraries in the installer for Linux 64 bits.
  • Fixed problem using ajax events after reloading a grid with full paging defined.

9.9.005

Updated Jan 3, 2023

Features

  • Improved layout of table and dictionary deletion alerts in project data dictionary.

Fixes

  • Fixed "Trying to access array offset on value of type null" error when generating security module in environments with license without upgrade.
  • Fixed problem in Position option of SweetAlert using Toast in express edition.
  • Fixed problem in Excel export generation, when using the sc_actionbar_disable macro in events.
  • Fixed problem when configuring a group by by month and year and sorting by day.
  • Fixed "Undefined array key" error when generating the calendar application, in the PHP 8.1 environment.
  • Fixed problem in the visualization of the "Timepicker" component of the hour field, next to the html editor field.
  • Fixed width problem in the columns of the save grid block, when the grid had many fields.
  • Fixed problem displaying the record using the MSSQL Server database uniqueidentifier data type.
  • Fixed problem with not compiling applications that had a friendly URL, at the end of publication generation.

9.9.004

Updated Dec 26, 2022

Features

  • Added quicksearch for searching indexes in the Translate Applications tool.
  • Added fixed bar on project list screen with vertical orientation.
  • Added show/hide password icon on login and license registration screens.
  • Added Error Position option in Express Edit.
  • Added Display Field Error option in a modal in Express Edit.
  • Added Error Timeout option in Express Edit.
  • Added Display Date Format option in Express Edit and Default Values.
  • Added Date Display Position option in Express Edit and Default Values.
  • Added Show Message option in Express Edit.
  • Improved project message translation interface.
  • Improved project data dictionary interface.

Fixes

  • 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.
  • Fixed problem in maintaining the ordering state of the applications in the interface after closing the application's tab.
  • Fixed problem in buttons interface after project conversion from v8 to v9.
  • Fixed Fatal error: Uncaught TypeError: array_keys(): Argument #1 ($array) must be of type array when creating buttons in converted applications.
  • Fixed Fatal error: Uncaught Exception: Serialization of 'LDAP\Connection' in LDAP security module login screen.
  • Fixed grid sorting problem when using the MEDIUMINT data type in MySQL.
  • Fixed 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.
  • Fixed problem when renaming folders with numerals in project messages.

9.9.003

Updated Dec 13, 2022

Features

  • Added new 'Last Accessed' column in the interface of all projects, in List mode.
  • Added protection to avoid creating buttons using parentheses.

Fixes

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

9.9.002

Updated Nov 29, 2022

Fixes

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

9.9.001

Updated Nov 24, 2022

Features

  • Added 'sc_change_css()' macro for grid applications.
  • Added hint option for Star Rating fields.
  • Improved layout of Google Sheets API interface in production environment.

Fixes

  • Fixed problem when using uppercase fields in the form inclusion, using the Google Sheets API.
  • Fixed 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.
  • Fixed error of Undefined array key "name" in button creation interface.
  • Fixed problem when navigating between records when using subquery with iframe in Slide type orientation.

9.9.000

Updated Nov 22, 2022

Features

  • Added Stripe, Braintree and Mercado pago payment APIs.
  • Added Rating Smile and Rating Thumbs field types.
  • Added Font Awesome support in "Rating" type field setting.
  • Added integration with Google Sheets in form applications.
  • Added action bar for grid applications.
  • Added the following to grid action bar:
    • macros sc_actionbar_state()
    • sc_actionbar_clicked_state()
    • sc_actionbar_enable()
    • sc_actionbar_disable()
    • sc_actionbar_show()
    • sc_actionbar_hide()
  • Added support for iframe in the nested grid.
  • Added pre-seeding for foreign key in data dictionary columns.
  • Added foreign key improvement option in Scriptcase settings, making it easier to define lookups in grids and forms.

Fixes

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