ScriptCase Changelog

What's new in ScriptCase 9.10.013

Mar 28, 2024
  • Added:
  • Added support for local variables in the macro sc_field_style. Support is valid only for style parameters.
  • Added feature to export images separately, in a Zip file, in Word document export in the grid.
  • Fixed:
  • Fixed problem with correct recognition of field type in the interface of applications, for IMAGE type columns in Sybase connections.
  • Fixed problem when inserting images in Sybase connections (in IMAGE type column), in image fields (database) in the form application.
  • Fixed problem with updating the editable grid view form opened in modal.

New in ScriptCase 9.10.012 (Mar 26, 2024)

  • Fixed error 2 = Undefined array key "display" when generating source code for Control type applications in environments with PHP 8.1.
  • Fixed error Column 'usa_seguranca' specified twice when creating the blank application.
  • Fixed error in the time display format in calendar events, when the time was between 12:00PM and 12:59PM.
  • Fixed error Undefined array key "subst_campo", when accessing SQL in the grid in environments with PHP 8.1.
  • Fixed problem with data display with double select field being reloaded via ajax processing.
  • Fixed problem with displaying removed fields on the "Edit Fields" screen in the form application.
  • Fixed problem with the date not being displayed in the standard format in the Filter application footer, when no format was entered.
  • Fixed problem with the Form not working when defining a lang with double quotes in the label of a field.
  • Fixed problem with Sybase PDO ODBC connection.
  • Fixed problem viewing the "select2" field in the steps form.
  • Fixed problem viewing the open form in modal on mobile devices.
  • Fixed problem with viewing the fixed label in the summary, when switching between static and dynamic group by, and when navigating.
  • Fixed problem with the alignment of the lower toolbar, when enabling option "Pin lower toolbar" in the grid.
  • Fixed problem with the behavior of the summary "Reload" button.

New in ScriptCase 9.10.011 (Mar 20, 2024)

  • Added option "Apply date limits to calendar" in the "date" type field in the form application.
  • Added new feature "Remove background color/image" in master detail link properties in form application.
  • ADDED:
  • Added SSL support for secure connections in PostgreSQL connection.
  • IMPROVED:
  • Visual improvement in the image manager interface.
  • FIXED:
  • Fixed "Parse error: syntax error, unexpected token < " in the Form application, when adding the backslash () as an allowed character.
  • Fixed "Fatal error: Uncaught ArgumentCountError: Too few arguments to function." when clicking the advance to the end button in a grid dynamic group by displayed after the records.
  • Fixed error "2 = Undefined array key 1" when generating the grid source code in environments with PHP 8.1.
  • Fixed problem with displaying the name of the month in the calendar on mobile.
  • Fixed Parse error: syntax error, unexpected token ";" in XLS export.
  • Fixed problem with data visualization in XLS export in the summary.
  • Fixed problem with improper display of the "Exit" button in forms linked to the grid, after conversion to version 9 of Scriptcase.
  • Fixed Undefined array key "charset" error that was displayed after losing a session.
  • Fixed TCPDF ERROR: [Image] Unable to get the size of the image when generating images in the ReportPDF application.
  • Fixed "Records not found" problem when reloading the summary, when dynamic group by fields were only selected at run time.
  • Fixed problem with the link type action button not working when set to open in an Iframe.
  • Fixed problem with summary header not displaying in PDF export.
  • Fixed problem with display of graph application buttons in the grid summary toolbar.
  • Fixed PHP Fatal error: Uncaught ValueError: mb_convert_encoding(): Argument #3 ($from_encoding) contains invalid encoding “undefined”, in the application creation interface.
  • Fixed problem in displaying the grid's dynamic group by layout when not using the "Support for multiple items" feature.
  • Fixed error when recovering password via email in the security module, when informing a user that does not exist.
  • Fixed problem with the SYBASE PDO connection in the Windows environment.
  • Fixed problem when using secondary connection in the lookup fields, in connections with SSL support.
  • Fixed the production environment interface for connections with SSL support.

New in ScriptCase 9.10.010 (Mar 4, 2024)

  • Added feature to select and drag multiple items on grid application toolbar buttons.
  • Added new themes: Softcloud and Softcloud Small.
  • Added options to define header and footer templates in advanced theme mode.
  • Added option to configure input hover in advanced theme mode.
  • Added feature for customizing the message displayed for required fields in the form and filter.
  • ADDED:
  • Added new directory with project images in the image manager.
  • Added support for unique key recognition when creating the form application automatically, in the Db2 connection.
  • Added support for recognizing the DATA data type as NOT NULL when creating the form application automatically, in the Db2 connection. The interface will mark the required field.
  • IMPROVED:
  • Adjustments to the list of Db2 connection drivers.
  • Changed the Firebird extension to version 4.0 in the Linux installer.
  • FIXED:
  • Fixed problem when performing a search in quicksearch when a field that had a lookup did not have ORDER BY in its SQL statement.
  • Fixed problem with displaying a required field message when canceling an action on the form.
  • Fixed problem when executing the sc_exec_sql macro after performing a search in quicksearch with the option to highlight results activated.
  • Fixed problem with including values in the image and database document fields in the Db2 connection.
  • Fixed problem when manually installing Scriptcase using the MySQLi driver.
  • Fixed problem downloading files from the database document field in the Mssql Server connection.
  • Fixed problem with incorrect display of vertical scroll bar in connection widgets in Dashboard application.
  • Fixed problem using the slide field in the summary filter.
  • Fixed problem downloading files from the Multi-Upload field in the Native SRV PDO Mssql Server driver.
  • Fixed problem with key fields marked as required in the Form application not being critical.
  • Fixed problem in displaying group by values when using totalization variables in events.
  • Fixed problem when using the sc_redir macro in the onload event in the menu application.
  • Fixed problem when displaying summary data using dynamic wrapping.
  • Fixed problem when saving label position definition in filter application blocks and grid advanced filter.
  • Fixed error of Undefined array key "tot_res_criar_grafico" in the grid, in the PHP 8.1 environment.
  • Fixed Fatal error: Uncaught Error: Cannot use a scalar value as an array in the chart application, when using group by in the SQL command.

New in ScriptCase 9.10.009 (Jan 31, 2024)

  • Fixed problem in record insertion when using automatic auto-increment with sequence in MariaDB connections.
  • Fixed problem with case-sensitive sorting in break fields.
  • Fixed problem with sorting for display in break fields with lookup.
  • Fixed problem when selecting records in refined search after performing an advanced search in a query application with Firebird connection.
  • Fixed problem with sorting special conditions in date-type field filters in grid applications.

New in ScriptCase 9.10.008 (Jan 23, 2024)

  • Fixed problem in the configuration of the columns option when using grouped fields.
  • Fixed field auto-completion problem when associating tables when creating a security module with Oracle, SQL Server and Postgres connections.
  • Fixed problem with the "Close form after updating or adding" options and editing link. The form was not being closed.
  • Fixed problem with the date field being changed to varchar, when a grid has a special SELECT (INNER JOIN, SUBSELECT, etc.) in Firebird.
  • Fixed problem in displaying sorting rules, when in advanced sorting we chose the "Define fields manually" option.
  • Fixed error "Invalid default value for 'mfa_last_updated'" when creating a security module.

New in ScriptCase 9.10.007 (Jan 18, 2024)

  • Fixed problem with saving the display definition of the nested grid (iframe-less mode) in the query application interface.
  • Fixed problem with .xls and .xlsx export in chart applications.
  • Fixed problem when using the "Chart" option as the initial module of the grid.
  • Fixed problem with the display of the date type field in the chart.

New in ScriptCase 9.10.006 (Jan 16, 2024)

  • Added a feature to set the validity period in days for a session, performed via Two-Factor Authentication (2FA), in the new security module.
  • Added a counter for the expiration time of the two-factor authentication code in the security module.
  • Fixed problem when disabling the "Code expiration time" feature in Two-Factor Authentication (2FA), in the security module, by setting its value to zero.
  • Fixed problem when using the Clickatell API and the sc_send_sms macro in Linux environments.
  • Fixed problem with the page scrolling in the user editing modal of the group/users application in the new security module.
  • Fixed problem of not displaying the options for the "Relative Period" component of the "Date" field in the summary filter.
  • Fixed "Parse error: Unmatched '}' in" when running a Form application.
  • Fixed error "The file was not generated with Scriptcase version 9" when importing an application. It was necessary to import the application again for proper functioning.
  • Fixed errors "2 = Undefined array key 180" and "2 = Trying to access array offset on value of type null" when generating a Query application in environments with PHP 8.1.
  • Fixed error when searching in the quick search of the group/users application in the security module.
  • Fixed error when importing a project from the "Project -> Export Project" option.
  • Fixed problem in the interface of the Query blocks after converting a project from version 8 to 9.
  • Fixed problem when generating PDF directly without respecting Query export modules.
  • Fixed problem with the operation of the sc_redir macro in the onAplicationInit event of the new menu.
  • Fixed problem in the Query when the option to generate Excel directly is activated. Clicking the back button was regenerating the xls.
  • Fixed problem with the sc_format_num macro in the onRecord event, along with the sc_format_num_region macro.
  • Fixed error "[object Object]" displayed in the interface after editing fields in "Edit Fields" of the form application.
  • Fixed problem with the responsive menu with vertical orientation in Arabic language on mobile devices.
  • Fixed problem with locking when trying to edit the theme for the "Flat Blue" button.

New in ScriptCase 9.10.005 (Jan 16, 2024)

  • Fixed "Fatal error: Uncaught Error: Cannot assign an empty string to a string offset" when running some grid applications in environments with PHP 8.1.
  • Fixed error 2 = Undefined array key "outro" when generating grid application in environments with PHP 8.1.
  • Fixed Fatal error: Uncaught Error: Cannot use a scalar value as an array when using onGroupByAll event
  • Fixed problem with the group by header not being displayed on all pages in dynamic group by, when the "Enable TreeView" option was disabled.
  • Fixed problem in the application interface when selecting fields in the advanced filter and positioning the fields in environments with PHP 7.3.

New in ScriptCase 9.10.004 (Jan 3, 2024)

  • ADDED:
  • Added behavior option when navigating in the steps form. Option available in Layout > Pages > Steps Configuration.
  • Added support for the "sc_btn_disabled" macro in created buttons.
  • FIXED:
  • Fixed problem when opening items with subitems in the Tree Menu application (Production environment update required).
  • Fixed problem in the menu toolbar when redirecting to an application with the hide menu option enabled.
  • Fixed problem of non-persistence of state when changing the charset in the project's connection interface.
  • Fixed problem of application not reloading in the tree menu from the second click on items with the "Open items in tabs" option disabled.
  • Fixed problem in the configuration of the Google Drive API in the production environment.
  • Fixed problem in the listing of auto-increment values in key fields in the Oracle connection.
  • Fixed problem in editing iframe properties in the link between applications.
  • Fixed "Fatal error: Uncaught Error: Cannot use a scalar value as an array" when running a query in environments with PHP 8.1.

New in ScriptCase 9.10.003 (Dec 27, 2023)

  • Added option to start expanded menu, in menu settings, when menu layout is vertical.
  • Added special condition "Existing years in the database" in the "Date comparison" field in the grid search.
  • FIXED
  • Fixed "Fatal error: Uncaught Error: Call to undefined method application_name_grafico::load_chart_theme()" when accessing chart in Summary, when the chart module was disabled in "Grid modules".
  • Fixed error 2 = Undefined array key "other" when generating grid application in environments with PHP 8.1.
  • Fixed error Undefined array key "extension", when editing a Control application in environments with PHP 8.1.
  • Fixed Fatal error: Uncaught TypeError: Cannot access offset of type string on string when starting from the summary module.
  • Fixed Fatal error: Uncaught TypeError: count(): Argument #1 ($value) in grid menu interface.
  • Fixed Fatal error: Uncaught TypeError: in_array(): Argument #2 ($haystack) must be of type array, null given in the dynamic group by of the grid.
  • Fixed problem when renaming responsive menu application.
  • Fixed problem with the average value in tables with few records.
  • Fixed problem with ordering icons not being displayed in Summary totalization fields when the grid had a JOIN.
  • Fixed problem when searching for items in the dynamic responsive menu.
  • Fixed problem with viewing the calendar icon in the date field with the "new calendar" option activated.
  • Fixed problem in the calendar view when using the sc_field_disabled macro in ajax events.
  • Fixed problem with menu display when using a large number of sub-items.
  • Fixed problem with downloading multi-upload files over the Postgres connection.
  • Fixed problem with linking dynamic responsive menu items when the sc_redir macro is called in an event.

New in ScriptCase 9.10.002 (Dec 18, 2023)

  • ADDED:
  • Added horizontal scrollbar in language interface.
  • Added support for creating a lang index containing numbers.
  • Added support for Sonoma (14.2) version of MacOs.
  • FIXED:
  • Fixed "Fatal error: Uncaught Error: Object of class application_name_ini could not be converted to string", when defining a lang in the label of a button with "Link" display mode.
  • Fixed error "Attention Undefined index: iframe", when the target "_self" was passed in the sc_appmenu_add_item macro in the new menu in environments with PHP 7.3.
  • Fixed undefined array key "arquivo3" error when generating the dashboard application.
  • Fixed undefined array key "filial" error in the grid application with the PHP 8.1 environment.
  • Fixed undefined array key 0 error in a grid application with the PHP 8.1 environment.
  • Fixed problem when using the security module configuration application in Spanish.
  • Fixed field label display problem when capturing a field of the "Field grouping" type.
  • Fixed problem with the "Display percentage" option in the Summary fields interface in old applications.
  • Fixed problem visualizing the exit button in the summary.

New in ScriptCase 9.10.000 (Dec 1, 2023)

  • ADDED:
  • Added new 100% responsive and fluid menu application with:
  • New toolbar;
  • Item search;
  • Shortcuts;
  • Dynamic language and theme switch;
  • User menu integrated into the security module.
  • Added a new date range comparison field in the search with a new calendar component for selection.
  • Added a comparative chart between dates on the summary page.
  • Added the option for percentage in relation to the total in the Summary.
  • Added pagination in the summary.
  • Added an option for the positioning of the overall total in the summary.
  • Added a new security module 100% configurable by the end system user, generated with:
  • New interface in the development environment;
  • Access mode through login, email, or both;
  • New option to define user creation rules;
  • New option for optional use of authentication (2FA);
  • Last password change.
  • IMPROVED:
  • Improved performance in the summary.

New in ScriptCase 9.9.024 (Oct 26, 2023)

  • 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.

New in ScriptCase 9.9.023 (Oct 18, 2023)

  • 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.

New in ScriptCase 9.9.022 (Oct 12, 2023)

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

New in ScriptCase 9.9.021 (Oct 11, 2023)

  • ADDED:
  • Added possibility to change documentation display in the Scriptcase interface: Online and Offline.
  • Added possibility to change documentation language in the Interface: English and Spanish.
  • Added new parameters to encrypted connection in SQL Server.
  • FIXED:
  • 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.

New in ScriptCase 9.9.020 (Sep 15, 2023)

  • IMPROVED:
  • 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.
  • FIXED:
  • 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.

New in ScriptCase 9.9.019 (Aug 31, 2023)

  • ADDED:
  • Added search feature in the management and positioning of fields in the applications 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.
  • IMPROVED:
  • Improved interface and usability in the production environment download via zip and tar.gz generation in advanced publishing.
  • Visual improvement of management and positioning of fields in the applications interface.
  • FIXED:
  • 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. For those who already have the security module, please check our tutorial to adjust the application.
  • 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.

New in ScriptCase 9.9.018 (Aug 25, 2023)

  • IMPROVED:
  • Visual improvement in the application creation interface.
  • FIXED:
  • 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.

New in ScriptCase 9.9.017 (Aug 21, 2023)

  • Added support for global variable in the label of grid buttons.
  • Added sorting option for SQL in the grid.
  • FIXED
  • 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.

New in ScriptCase 9.9.016 (Aug 8, 2023)

  • ADDED:
  • Added width option in option use checkbox in dropdown in filter select.
  • Added criticism when trying to create an application with its name starting with a number.
  • IMPROVED:
  • 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.
  • FIXED:
  • 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. For those who already have the security module, please check our tutorial to adjust the application.
  • 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.

New in ScriptCase 9.9.015 (Jul 19, 2023)

  • Added new macro sc_lookup_field.
  • ADDED:
  • Added support for Column Selection and Linking between applications in grid with vertical orientation.
  • Added support for password recovery, with SMTP configuration, in production environment.
  • Added option in deployment to generate page containing a link to the initial application.
  • Added support for Column Selection and Linking between applications in grid with vertical orientation.
  • Added support for password recovery, with SMTP configuration, in production environment.
  • Added option in deployment to generate page containing a link to the initial application.
  • FIXED:
  • Improved opening mode for downloading files from the "Document (File Name)" data type.
  • Removed the info and diagnosis files from the site's deployment file.
  • Improvement in the production environment interface
  • Improvement in the Scriptcase libraries.
  • IMPROVED:
  • Improved Scriptcase libraries.
  • FIXED:
  • 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 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 error Undefined array key "lang_subject_mail", when accessing project messages interface in environments with PHP 8.1.
  • 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.

New in ScriptCase 9.9.014 (May 23, 2023)

  • Added option to view the diagnosis in the production environment. We recommend deleting the info and diagnosis files in the production environment.
  • Fixed tab bar and refresh button when scrolling, in project default values interface.
  • FIXED:
  • Fixed error when using the "Grand total" option in the chart application.
  • Fixed error Undefined array key "b_bor_collapse", when editing blocks through advanced filter.
  • Fixed issue 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 a problem when creating a calendar, using the option to create a table.
  • Fixed a 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.

New in ScriptCase 9.9.013 (May 5, 2023)

  • ADDED:
  • Added option to reload tables and fields in field lookup.
  • Added option to reload tables and fields in Dashboard index.
  • IMPROVED:
  • Usability improvement in the fields initial values of dynamic group by.
  • FIXED:
  • 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.

New in ScriptCase 9.9.012 (Apr 28, 2023)

  • ADDED:
  • Added headers security options on unauthorized user pages and use password on generated applications.
  • Added headers options in security module applications. The options will be included when creating a new security module from this release.
  • Note: For the security module already created, just use the express edition to configure the security headers in the applications. For more information about security headers, please access our documentation.
  • FIXED:
  • Fixed problem with confirmation button on delete file screen in internal library.

New in ScriptCase 9.9.011 (Apr 25, 2023)

  • WhatsApp API (ChatApi) removed due to being discontinued.
  • FIXED:
  • 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.

New in ScriptCase 9.9.010 (Apr 11, 2023)

  • Added new option to compress files before sending in SFTP publishing.
  • 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.

New in ScriptCase 9.9.009 (Mar 24, 2023)

  • ADDED:
  • Added option to display chart configuration of grid fields as an icon or keep the buttons.
  • Added visual customization of grid field titles.
  • Added fixed toolbar in grid.
  • Added aggregation of rating fields in summary.
  • Added display of rating fields in grid group by.
  • Added field grouping option in the grid.
  • Added confirmation message option in the visual configuration of the button in the action bar.
  • Added button grouping option in action bar.
  • Added button option in button visual setting in action bar.
  • Added label configuration option in action bar column.
  • IMPROVED:
  • Improved performance in the creation of applications, using the Oracle connection.
  • Improved visual when creating a new langs folder.
  • Improved connection performance.
  • Note: If the new version is updated manually, it will be necessary to apply the permissions in the Scriptcase directory.
  • Improved internal library interface.
  • Improved visual in the notification of saving changes in the interface.
  • FIXED:
  • 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 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.

New in ScriptCase 9.9.006 (Jan 12, 2023)

  • ADDED:
  • Added support for resizing message inputs in the Application Translation tool.
  • Added option to open div below or in modal in express editing and default values.
  • FIXED:
  • 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.

New in ScriptCase 9.9.005 (Jan 3, 2023)

  • Improved:
  • Improved layout of table and dictionary deletion alerts in project data dictionary.
  • Fixed:
  • 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.

New in ScriptCase 9.9.004 (Dec 26, 2022)

  • ADDED:
  • 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:
  • Improved project message translation interface.
  • Improved project data dictionary interface.
  • FIXED:
  • 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 'LDAPConnection' 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.

New in ScriptCase 9.9.003 (Dec 14, 2022)

  • IMPROVED:
  • Added new "Last Accessed" column in the interface of all projects in List mode.
  • Added protection to not create buttons using parentheses.
  • FIXED:
  • 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 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.
  • Fixed the visualization of Mssql 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 MSSQL 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.

New in ScriptCase 9.9.002 (Nov 29, 2022)

  • ADDED:
  • Click here and see all the news in version 9.9
  • Added payment API (Stripe).
  • Added payment API (Braintree).
  • Added payment API (Mercado pago).
  • Added field type Rating Smile.
  • Added field type Rating Thumbs.
  • Added Font Awesome support in "Rating" type field setting.
  • Added integration with Google Sheets in form applications.
  • Added action bar for grid applications.
  • Added support for iframe in the nested grid, allowing to execute all the functionality of the grid.
  • Added preseeding 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.
  • Added sc_change_css() macro for grid application.
  • Added hint option for "Star" Rating fields.
  • FIXED:
  • 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.

New in ScriptCase 9.9.001 (Nov 25, 2022)

  • ADDED:
  • Added payment API (Stripe).
  • Added payment API (Braintree).
  • Added payment API (Mercado pago).
  • Added field type Rating Smile.
  • Added field type Rating Thumbs.
  • Added Font Awesome support in "Rating" type field setting.
  • Added integration with Google Sheets in form applications.
  • Added action bar for grid applications.
  • Added support for iframe in the nested grid, allowing to execute all the functionality of the grid.
  • Added preseeding 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.
  • Added sc_change_css() macro for grid application.
  • Added hint option for "Star" Rating fields.
  • Added sc_actionbar_state macro in the grid action bar.
  • Added sc_actionbar_disable macro in the grid action bar.
  • Added sc_actionbar_show macro in the grid action bar.
  • Added sc_actionbar_clicked_state macro in the grid action bar.
  • Added sc_actionbar_enable macro in the grid action bar.
  • Added sc_actionbar_hide macro in the grid action bar.
  • IMPROVED:
  • Improved the layout of the Google Sheets API interface in the production environment.
  • FIXED:
  • 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.

New in ScriptCase 9.9.000 (Nov 22, 2022)

  • Added payment API (Stripe).
  • Added payment API (Braintree).
  • Added payment API (Mercado pago).
  • Added field type Rating Smile.
  • Added field type Rating Thumbs.
  • 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 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.
  • Added support for iframe in the nested grid, allowing to execute all the functionality of the grid.
  • Added preseeding 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.
  • 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.

New in ScriptCase 9.8.014 (Nov 14, 2022)

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

New in ScriptCase 9.8.013 (Nov 1, 2022)

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

New in ScriptCase 9.8.012 (Oct 22, 2022)

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

New in ScriptCase 9.8.011 (Oct 14, 2022)

  • Fixed problem when saving zero value in initial interface configuration.
  • Fixed problem when executing the SQL of the chart application, when configuring a WHERE condition in SQL along with the filter.
  • Fixed problem in updating records in NVARCHAR columns with SQLite connection.

New in ScriptCase 9.8.010 (Oct 6, 2022)

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

New in ScriptCase 9.8.009 (Sep 28, 2022)

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

New in ScriptCase 9.8.008 (Sep 20, 2022)

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

New in ScriptCase 9.8.007 (Sep 13, 2022)

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

New in ScriptCase 9.8.006 (Sep 8, 2022)

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

New in ScriptCase 9.8.005 (Sep 1, 2022)

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

New in ScriptCase 9.8.004 (Aug 25, 2022)

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

New in ScriptCase 9.8.003 (Aug 18, 2022)

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

New in ScriptCase 9.8.002 (Aug 11, 2022)

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

New in ScriptCase 9.8.001 (Aug 8, 2022)

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

New in ScriptCase 9.8.000 (Aug 4, 2022)

  • 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.

New in ScriptCase 9.8.000 (Aug 4, 2022)

  • 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.

New in ScriptCase 9.7.023 (Jun 21, 2022)

  • Fixed issue in the Application List interface of tab applications.

New in ScriptCase 9.7.022 (Jun 15, 2022)

  • 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

New in ScriptCase 9.7.021 (Jun 7, 2022)

  • Fixed problem in displaying background color of "Mac" layout in menu application.
  • Fixed problem with use theme background flag in menu application.
  • Fixed problem in displaying iframe properties in application links opening in modal.
  • Fixed problem in Excel export, when the title of the total contained a global variable.
  • Fixed problem in setting the width of layers in the menu.
  • Fixed problem when using tab navigation in menu applications.

New in ScriptCase 9.7.020 (Jun 2, 2022)

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

New in ScriptCase 9.7.019 (May 20, 2022)

  • ADDED:
  • Added option to view the steps form on mobile. Option available in Layout : Pages.
  • Added option to view the steps form on mobile. Option available in Layout : Pages.
  • Added new sc_head_hide and sc_foot_hide macros.
  • Added new sc_head_hide and sc_foot_hide macros.
  • FIXED:
  • Fixed problem when viewing select2 in form fields on mobile devices.
  • Fixed problem when closing capture application after registration selection on mobile devices.
  • Fixed problem with editable grid (view) form modal on mobile devices.
  • Fixed problem when viewing the "date" field in the dashboard application index, using the DBLIB connection.
  • Fixed "Uncaught ArgumentCountError: Too few arguments to function", when performing the totalization of a virtual field configured with lookup.
  • Fixed problem with block title display in advanced search when the option to display block title is unchecked.
  • Fixed problem in validating group by, when selecting the automatic lookup method without informing the SQL command.
  • Fixed problem in displaying the header of an application redirected by the edit link when using mobile optimizations.
  • Fixed problem with Progress PDO connection failure.
  • Fixed problem in display of fixed label in "Select" column of applications with capture link.
  • Fixed problem in quicksearch result, using fields with reserved words or protected by double quotes.
  • Fixed 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.

New in ScriptCase 9.7.018 (May 9, 2022)

  • Added fixed column and form ordering options in express edition of applications.
  • Fixed problem when in Quicksearch using the Progress connection.
  • Fixed 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.
  • Fixed problem in generating PDF in Alma Linux 8.5 environment.
  • Fixed problem in synchronizing data dictionary langs in applications that have group by.
  • Fixed problem when viewing edit buttons on horizontal forms on mobile.
  • Fixed a problem with the fixed label working on mobile horizontal forms.
  • Fixed problem with text preview in mobile vertical grids (using more than one column per page).
  • Fixed problem with displaying the height of form page tabs on mobile.
  • Fixed problem in displaying records in xls and xlsx export in grid applications with nested grids and left text alignment.
  • Fixed problem with initial value in the filter when configuring with zero.
  • Fixed issue of overlapping menu application theme color by project theme color.

New in ScriptCase 9.7.017 (Apr 27, 2022)

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

New in ScriptCase 9.7.016 (Apr 14, 2022)

  • ADDED:
  • Added option to "Display progress bar" in PDF export configuration. This will only be done when the "Generate PDF Directly" option is enabled.
  • Added mobile support for HTML editor fields.
  • Added feature to fix columns in horizontal forms (multiple records, editable grid and editable grid view).
  • Added option to include records in modal, in the form with editable grid view orientation.
  • Added selection of fields that will be part of the editable grid (view), allowing different configuration of form fields.
  • Added 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.
  • FIXED:
  • Fixed problem in onGroupByAll event when performing calculations on fields.
  • Fixed problem when viewing the grid and summary export modules when the initial module was configured for PDF.
  • Fixed problem with Z-index of the option to save grid that was behind the application label.
  • Fixed problem when saving the option "Definition of the fields that will be displayed in the group by" in the group by field configuration.
  • Fixed problem in totaling a virtual field with negative values.
  • Fixed problem when viewing chart themes in the grid fields interface.
  • Fixed JS problem when using named fields with reserved words.
  • Fixed 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.
  • Fixed error when running application with theme for button that contains quote.
  • Fixed problem with lifetime setting of files in tmp directory.

New in ScriptCase 9.7.015 (Mar 19, 2022)

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

New in ScriptCase 9.7.014 (Mar 14, 2022)

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

New in ScriptCase 9.7.013 (Mar 4, 2022)

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

New in ScriptCase 9.7.012 (Feb 25, 2022)

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

New in ScriptCase 9.7.011 (Feb 21, 2022)

  • Added:
  • Added fixed columns in the grid, freezes the data of the column during the horizontal scroll.
  • Added option to customize sort icons on field labels in grids.
  • Fixed:
  • Fixed problem with grid label overlapping on search label.
  • Fixed problem in console in the grid.

New in ScriptCase 9.7.010 (Jan 26, 2022)

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

New in ScriptCase 9.7.009 (Jan 3, 2022)

  • Fixed problem with help indexes in the interface.
  • Fixed problem in creating FTP publishing directories without common libraries.

New in ScriptCase 9.7.008 (Dec 29, 2021)

  • Fixed problem on the searching of the "select" field in the dynamic filter, when the field was not available in the advanced filter.
  • Fixed issue with displaying refined filter on mobile when "start as" option is collapsed.

New in ScriptCase 9.7.007 (Dec 23, 2021)

  • 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.

New in ScriptCase 9.7.006 (Dec 16, 2021)

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

New in ScriptCase 9.7.005 (Dec 2, 2021)

  • 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.

New in ScriptCase 9.7.004 (Nov 29, 2021)

  • 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.

New in ScriptCase 9.7.003 (Nov 25, 2021)

  • ADDED:
  • Added mobile optimization for form application
  • Added mobile optimization for calendar application
  • Added User profile image upload option in security module
  • Added new 'Settings' option to end user in security module
  • FIXED:
  • Fixed problem in the filter's clear button, in the checkbox type field, configured as manual lookup
  • Fixed 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
  • Fixed 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
  • Fixed issue in the mobile grid toolbar, which only worked when there were buttons configured on the desktop toolbar
  • Fixed issue with advanced filter mobile toolbar buttons It was only displayed in the mobile application if there were buttons on the desktop toolbar
  • Fixed damaged file issue in macOS scriptcase installer
  • Fixed problem in redirecting "sc_redir" macro to the pdf report application

New in ScriptCase 9.7.002 (Nov 11, 2021)

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

New in ScriptCase 9.7.001 (Nov 5, 2021)

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

New in ScriptCase 9.7.000 (Oct 28, 2021)

  • Added:
  • Added mobile optimization for grid, menu and chart applications.
  • Added Form Multi-Steps.
  • Added Two-Factor Authentication (2FA) to the security module.
  • Added API email configuration support in security module.
  • Added improvements to Refined Search.
  • Added new chart options (Zoomline, Scrolling and Overlapping).
  • Added new sc_btn_disabled macro.
  • Added new sc_btn_label macro.
  • Added new sc_get_wizard_step macro.
  • Added new parameter "reply_to" in sc_mail_send macro.
  • Fixed:
  • Fixed error when generating source code for Online Shop project.
  • Fixed connection issue in CRM project when using SQL Server Native SRV PDO driver.
  • Fixed problem when using reload button when adding records.
  • Fixed sorting problem with column type CBLOB, BLOB and LONG, using Oracle database.
  • Fixed problem saving API in production environment, due to webkit update in some browsers.
  • Fixed problem when returning to the query application when using sc_redir macro in advanced search.

New in ScriptCase 9.6.018 (Jul 27, 2021)

  • 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.
  • Fixed problem in the messages in case of EOF, of the lookup of display in text fields.
  • Fixed problem in alert display when running application with select field, radio or checkbox with no value in lookup.
  • Fixed problem in the inclusion of the "datetime" field with the option of system data in the inclusion and configured as label.
  • Fixed problem with BYTEA type when inserting data using signature type field.
  • Fixed problem in the configuration of the dimensions of the signature field.
  • Fixed problem creating untitled pages in the form.

New in ScriptCase 9.6.017 (Jul 13, 2021)

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

New in ScriptCase 9.6.016 (Jul 2, 2021)

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

New in ScriptCase 9.6.015 (Jun 23, 2021)

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

New in ScriptCase 9.6.014 (Jun 10, 2021)

  • 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.

New in ScriptCase 9.6.013 (Jun 4, 2021)

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

New in ScriptCase 9.6.012 (Jun 3, 2021)

  • 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.

New in ScriptCase 9.6.011 (May 11, 2021)

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

New in ScriptCase 9.6.010 (May 4, 2021)

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

New in ScriptCase 9.6.009 (May 4, 2021)

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

New in ScriptCase 9.6.008 (May 4, 2021)

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

New in ScriptCase 9.6.007 (Apr 2, 2021)

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

New in ScriptCase 9.6.006 (Feb 25, 2021)

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

New in ScriptCase 9.6.005 (Feb 12, 2021)

  • 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.

New in ScriptCase 9.6.004 (Feb 5, 2021)

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

New in ScriptCase 9.6.002 (Dec 30, 2020)

  • Added option to Save HTML tags and Javascript text input in text fields of the control application.
  • Added support for .webp files in the Scriptcase image manager.
  • Added support for PostgreSQL connection charsets to the production environment's encodings list.
  • Added "Keep old aspect of uploading files" option in the project properties.
  • Fixed problem with the behavior after selecting the "Save Grid" button.
  • Fixed problem with the text display when filling in the To-Do List.
  • Fixed problem with displaying buttons when sending project messages in low resolution.
  • Fixed problem when restoring selected fields in the advanced Report PDF filter and grid.
  • Fixed problem with advanced mode parameters with DB2 connection.
  • Fixed problem with displaying Google Calendar buttons in the calendar application.
  • Fixed problem in viewing HTML tags in the menu tabs, when using the toolbar buttons.
  • Fixed problem when inserting data in the calendar using Google Calendar API.
  • Fixed problem with redirection in the tree menu when selecting default application and opening items in a new tab.
  • Fixed problem with the download of document (file name) field type files in the grid.
  • Fixed problem with "save application" after synchronizing the table.
  • Fixed problem when using space and capital letters, in global variables of the header and footer of the grid and form applications.
  • Fixed problem with the mini calendar display.
  • Fixed problem with displaying widget titles in dashboard applications.
  • Fixed problem in viewing the applications configured in the tab application, using the French language.
  • Fixed problem when sending link through the sc_mail_send macro.

New in ScriptCase 9.6.001 (Dec 17, 2020)

  • 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.

New in ScriptCase 9.6.000 (Dec 3, 2020)

  • 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.

New in ScriptCase 9.5.003 (Oct 2, 2020)

  • 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.

New in ScriptCase 9.5.002 (Sep 22, 2020)

  • 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.

New in ScriptCase 9.5.001 (Sep 18, 2020)

  • Fixed problem assigning values to fields through the onRecord event.

New in ScriptCase 9.5.000 (Sep 18, 2020)

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

New in ScriptCase 9.4.032 (Jul 8, 2020)

  • Documentation improvements

New in ScriptCase 9.4.031 (Jun 11, 2020)

  • ADDED:
  • 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.

New in ScriptCase 9.4.029 (Jun 1, 2020)

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

New in ScriptCase 9.4.028 (May 19, 2020)

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

New in ScriptCase 9.4.027 (May 13, 2020)

  • 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.

New in ScriptCase 9.4.000 (Jul 24, 2019)

  • New functionalities UPGRADE REQUIRED:
  • Added the new CSS theme Sweet Blue for applications.
  • Added the new CSS theme Sweet Amour for applications.
  • Added the new CSS theme Sweet Coral for applications.
  • Added the new CSS theme Sweet Golden Sand for spplications.
  • Added the new CSS theme Sweet Hollyhock for applications.
  • Added an option to link google fonts in CSS themes.
  • Added an option to download and make google fonts available offline in applications.
  • Added support to individual button class behaviours into the CSS Buttons setings.
  • Added selected buttons class behaviour into the CSS Buttons settings.
  • Added Font Awesome icons support in CSS Buttons settings.
  • Added Font Awesome icons support in toolbar's group button settings.
  • Added an option to show group buttons either Side by Side or Dropdown.
  • Added support to SweetAlert2 as Modal or Toast in-app notifications.
  • Added SweetAlert2 support in sc_alert, sc_ajax_message and sc_error_message macros.
  • Added an option to set SweetAlert2 notifications positioning. Added an option to include totals in grid and nested grid Excel export.
  • Added progress bar for Word, Excel, CSV, XML and RTF export in grid applications.
  • Bugs:
  • Fixed problem with miliseconds in date and hour field's lookup using SQL Server.
  • Fixed problem in nested grid with empty records in Excel export.
  • Fixed problem to save a grid that uses refined search.
  • Fixed problem with ReportPDF cells position after converting from a previous version.
  • Fixed problem in quicksearch and auto-complete text case sensitivity.
  • Fixed problem to use refined search with virtual fields in the group by totals.
  • Fixed problem with numeric fields values increment using a slider in the refined search.
  • Fixed problem to update values using numeric lookup in the grid.
  • Fixed problem with advanced search having TIME fields.

New in ScriptCase 9.3.012 (May 24, 2019)

  • New functionalitiesUPGRADE REQUIRED:
  • Added option to clear other filters after submitting in advanced filter settings.
  • Added 'Interact with dynamic filter' option in advanced filter settings.
  • Added option to display labels as readonly in advanced filter settings.
  • Bug:
  • Fixed problem with license expired using Progress driver.
  • Fixed problem when using SQL function in lookup of fields.
  • Fixed problem in the SQL preview of the current value in grid using WHERE in the SQL clause.
  • Fixed Javascript problem when restoring columns and sorting.
  • Fixed problem using specific characters when creating APIs.

New in ScriptCase 9.3.011 (May 15, 2019)

  • New functionalities:
  • Added option to restore initial values of the dynamic and static group by in the grid application.
  • Added language and regional settings for Gujarati.
  • Added language and regional settings for Sinhalese.
  • Bug:
  • Fixed problem when using virtual field type "Grid Fields" in the grid searh.
  • Fixed problem when using the respective macros sc_exit and sc_error_message in the control application.

New in ScriptCase 9.3.010 (Apr 25, 2019)

  • New functionalitiesUPGRADE REQUIRED:
  • Added option for settings in the 'Actual value' methods in the lookup of search field.
  • Bug:
  • Fixed loop problem in redirect using the sc_apl_default macro on mobile devices.
  • Fixed problem when navigating from a form to the grid through the menu breadcrumb.
  • Fixed problem when using saved search with double select field.
  • Fixed problem in label search criteria when changing grid language.
  • Fixed problem when saving search with date field, using 'between two values' date criteria.
  • Fixed problem displaying images in the header, when configured as record per page type in the Report PDF.
  • Fixed problem in list of links between applications.

New in ScriptCase 9.3.009 (Apr 12, 2019)

  • New functionalities:
  • Added option to restore initial values ​​in the columns and sort buttons, in the grid application.
  • Bug:
  • Fixed error "TypeError: dt_fmt is undefined" when loading filter profile with datetime fields using special conditions.
  • Fixed problem in database creation through project connection.
  • Fixed error "Allowed memory exhausted" when publishing project generating TAR.GZ file.
  • Fixed problem of duplicate fields in Ajax processing.
  • Fixed problem when not repeating values ​​in Excel export.
  • Fixed problem in time display format in Report PDF.
  • Fixed problem loading in infinite scroll in grid application without records.
  • Fixed problem displaying the export buttons when naming grid application with numbers only.
  • Fixed problem of displaying the search condition on the search tag when applying a previous state of the previously saved grid.

New in ScriptCase 9.3.008 (Apr 4, 2019)

  • Specific correction:
  • Fixed Javascript error when creating connection in production environment.
  • Bug:
  • Fixed problem in the insert or update mode, in Image (Database) and Image (Filename) fields in the form.
  • Fixed problem at header height of the PDF Report as Lines per Page, from the second page onwards.
  • Fixed problem in initial value definition in date fields, with special conditions, in chart search.
  • Fixed problem when using DISTINCTROW in SQL of the grid.

New in ScriptCase 9.3.007 (Apr 2, 2019)

  • New functionalities:
  • Added option for refresh interval in summary settings.
  • Added support for tab applications in general project search.
  • Added option to view or hide PDF settings in layout preview.
  • Performance improvement:
  • Improved master/detail link interface.
  • Improved control link interface.
  • Improved form link interface.
  • Improved search link interface.
  • Improved layout in the width of the list of tables and fields in SQL Builder.
  • Bug:
  • Fixed problem in the interface when selecting a special condition for date fields, in the grid search.
  • Fixed problem when clicking "Click to download common ZIP libraries" when performing an advanced deployment.
  • Fixed problem in dynamic search with 'All period' condition in DATETIME fields in SQL Server.
  • Fixed problem in PDF export of charts of Pyramid, Radar, Gauge and Funnel types.
  • Fixed problem in message 'Required field' when adding a record, in the form application.
  • Fixed problem when making changes to a virtual field of the auto-complete type, on a multiple records form.
  • Fixed problem when performing Ajax processing between fields using dropdown.
  • Fixed problem when updating or inserting a new record containing label field with javascript text, in Google Chrome.
  • Fixed problem in viewing the contents of the "Document (Database)" field in the form Grid Editable View.
  • Fixed problem when exporting files in Safari.
  • Fixed problem of displaying radio fields on forms using fixed label.
  • Fixed problem of permission to export PDF from grid, in publications generated from .tgz file.
  • Fixed problem with macro sc_date when incrementing month.
  • Fixed problem in displaying users using openLDAP in Linux.
  • Fixed problem with sc_label macro using variable type attribute.
  • Fixed problem in viewing the signature field in Report PDF.
  • Fixed "Data to long for column" error when importing an application.
  • Fixed problem using onChange event in auto-complete text fields.
  • Fixed problem in repetition of lookup queries in form multiple records.
  • Fixed problem in mandatory field message in date fields with calendar.
  • Fixed problem using mandatory fields in tag search.
  • Fixed problem in search of relative summary search in DATETIME type fields.
  • Fixed problem in extracting files compressed by Scriptcase in CentOS environment.
  • Fixed problem when exporting PDF in a grid, using search as initial module, iframe and hiding header.
  • Fixed Javascript error in tabs without application.
  • Fixed problem in language change in control applications.
  • Fixed problem with macro sc_format_num in fields with lookup.
  • Fixed problem when clearing Auto-Complete fields for Ajax processing.
  • Fixed problem in color palette display, on forms with "Grid Editable View" orientation.
  • Fixed problem in the view of buttons created in the grid in the summary toolbar.
  • Fixed problem in the interface when connecting applications in the application of tab.
  • Fixed problem in publishing with API in Linux environments.
  • Fixed problem in variable naming with uppercase letters in blank applications.
  • Fixed problem when setting double quotes in allowed characters in a form application.
  • Fixed problem with VARYING data types in PostgreSQL.
  • Fixed problem alignment problem when scrolling the page in summary using fixed label.
  • Fixed problem in disabled item view through sc_menu_disable macro, in menu application.
  • Fixed problem when using the sc_btn_display macro in the groups of buttons.
  • Fixed problem of calendar scroll bar in dashboard widgets.
  • Fixed problem in content view when clicking the "View SQL" button in SQL errors on the form.
  • Fixed problem when using Ajax onChange events in Auto-Complete fields using Select 2.
  • Fixed problem in displaying grid's "Back" button in dashboard widgets.
  • Fixed problem when formatting the value in scales with negative numbers in dashboard application.
  • Fixed problem in right alignment of vertical menu, using hidden menu option.
  • Fixed problem when using checkbox in dropdown, with empty title in Select type fields.
  • Fixed problem in preview when changing layout orientation in Report PDF.
  • Fixed problem of viewing PDF settings in the layout preview in the Firefox browser.
  • Fixed problem when using 'Use slider' option in virtual numeric fields in grid search.
  • Fixed tab problem with Enter key in numerical field using spin.
  • Fixed display problem in header margin in tab application.
  • Fixed interface problem when reporting incorrect login in log module creation.
  • Fixed problem when using textarea in the user editor in an HTML control application.
  • Fixed Fatal error: Uncaught Error: Call to a member function MoveNext() when executing grid application, containing SELECT with several parameters.
  • Fixed problem in aligning slider fields in grid search.
  • Fixed problem in description view when defining initial application in project settings.
  • Fixed problem in PDF export using headers and titles in Mac OS environments.
  • Fixed width problem when using Select2, in field type Select.
  • Fixed problem in displaying the magnifying glass icon in a form application with master/detail.
  • Fixed problem when using date type field in a label search and enable calendar view.
  • Fixed problem of displaying the search condition on the search tag when applying a previous state of the previously saved grid.
  • Fixed problem when using the sc_redir macro in queries with slide orientation.
  • Fixed invalid data problem when performing special character search in grid.
  • Fixed captcha settings problem in the advanced settings of the theme.
  • Fixed problem at the time of the Report PDF header as Lines per Page.
  • Fixed problem in inserting or updating values ​​in undefined label fields.
  • Fixed problem in Ajax events between decimal fields in Edge and Safari browsers.
  • Fixed problem in generating PDF in queries configured not to display titles.
  • Fixed problem in the width of select2, initially hidden, loaded from a block or frame.
  • Fixed problem with the "back" button of the calendar, accessing application directly.
  • Fixed problem in dynamic search search, in date fields using combobox.
  • Fixed problem of visualization in database builder with PostgreSQL connection.
  • Fixed problem in Javascript application through events in forms, from mobile devices.
  • Fixed problem in master loading / detail accessing from mobile devices.
  • Fixed paging problem with HTML color field in form.

New in ScriptCase 9.3.006 (Feb 28, 2019)

  • Specific correction:
  • Fixed problem in viewing the "Week " in the calendar. You will need to clear the browser cache.
  • Fixed problem in exporting compressed PDF using password in Linux and MAC environments.
  • Fixed issue when exporting PDF in Debian distribution (Linux).
  • Bug:
  • Fixed problem in exporting PDF compressed in application form.
  • Fixed problem in the button "Download " in the form PDF export.
  • Fixed Password field display problem in the form, when exporting PDF, even when the password function was previously disabled.
  • Fixed problem setting format values as percentage, in Pie chart type.
  • Fixed Notice: Use of undefined constant s-assumed's in the tab application using PDF export.
  • Fixed problem in exporting images using password in the Chart application.
  • Fixed issue in the HTML printing of the form application.

New in ScriptCase 9.3.005 (Feb 22, 2019)

  • New functionalities:
  • Added options for color and thickness settings for trendlines in the chart theme.
  • Bug:
  • Fixed problem in handling data entered in SMALLDATETIME fields, using SQL Server connection.
  • Fixed error Uncaught Error: Call to undefined function SC_dir_app_name() when accessing menu application without security.
  • Fixed problem when cleaning label filter conditions in the grid with infinite scroll.
  • Fixed problem in the field title, when using nested grids as title on the same line.
  • Fixed crash problem in forms navigation using Informix connection.
  • Fixed problem in retrieving SQL types in clauses with INNER JOIN, using MySQLi driver.
  • Fixed crash problem in resume export Excel.

New in ScriptCase 9.3.004 (Feb 15, 2019)

  • New functionalities / UPGRADE REQUIRED:
  • Added option for password in form PDF export.
  • Added option for password in chart export to PDF, Excel, Word, CSV, XML and images.
  • Added option for settings in the image export in the chart application.
  • Added option to display items in the export to the end user in the grid and chart applications.
  • Added option to export compressed PDF (.zip) in grid, chart and form applications.
  • Added option "Distinguish uppercase/lowercase" in the express edition of the applications.
  • Added option to allow files to be downloaded through Document type fields, even if readonly.
  • Bug:
  • Fixed problem in WHERE of grid using refined search, after redirect of summary.
  • Fixed problem loading CSS button settings.
  • Fixed problem in refined search view in grid HTML print.
  • Fixed problem when displaying records in the calendar, using initial day mode.
  • Fixed problem in source code when using external libraries through the onScriptInit event in the grid application.
  • Fixed problem in numeric field calculator when multiplying with numbers containing zeros on the right.
  • Fixed problem in header during HTML print of grid with orientation of slide type.
  • Fixed problem in header during HTML print of grid with orientation of vertical type.
  • Fixed problem in sc_field_display macro to hide fields from nested grid, in grid with slide orientation.
  • Fixed problem using Ctrl + S shortcut to save Helpcase files.
  • Fixed problem when using Ajax event in numeric fields with spin.
  • Fixed problem when generating column charts in grid fields.

New in ScriptCase 9.3.003 (Feb 5, 2019)

  • Fixed problem when importing same application in project.
  • Fixed problem when searching for content with single quotes in the grid advanced search.
  • Fixed problem in generating the PDF using the grid with vertical orientation.
  • Fixed problem in printing the header in the PDF export, using the grid with slide orientation.
  • Fixed problem in sorting when editing global variable in a PHP method.
  • Fixed problem in two-point named tables (:) in Postgres, when generating grid in SQL Builder.
  • Fixed authentication problem when using Database Builder with SQL Server connection.
  • Fixed problem in vertical alignment of input in checkbox fields.
  • Fixed problem in vertical alignment of subselect fields in Report PDF.
  • Fixed problem in advanced search of date type fields as VARCHAR in the database.
  • Fixed problem in displaying the label below the group by, not using configurable PDF.
  • Fixed problem of vertical alignment of date fields using conditions between two values.
  • Fixed issue when using digital signature fields in Report PDF applications.
  • Fixed error in_array () expects parameter when accessing express edition.
  • Fixed problem in the compressed export library (.zip) in Mac OS.
  • Fixed JavaScript error document.registerElement is deprecated from the treemenu.
  • Fixed problem in screen resolution in rename application interface, containing multiple bindings.
  • Fixed problem in displaying the lines in Report PDF.
  • Fixed problem in SQL complex using connection with MySQLi driver.
  • Fixed problem in detail HTML printout in grid application.
  • Fixed problem Parse error: syntax error in N:N settings.
  • Fixed problem using sc_concat macro in field lookup, in control application.
  • Fixed problem in displaying defined user grid buttons using master/detail.
  • Fixed problem in title when uploading JS files in Helpcase.
  • Fixed error when setting orientation as free format and initial "Print" module in the grid application.
  • Fixed problem in the regional settings of the mini calendar in the calendar application.

New in ScriptCase 9.3.002 (Jan 26, 2019)

  • Fixed problem when saving fields in the interface, using the Spanish language.

New in ScriptCase 9.3.001 (Jan 25, 2019)

  • Fixed problem in Excel export using dynamic group by, in grid application.
  • Fixed problem saving changes to fields of type SELECT, in form application.

New in ScriptCase 9.3.000 (Jan 24, 2019)

  • New functionalities:
  • Option to add password (using a fixed value or global variable) to protect the exported files in PDF, XML, EXCEL, WORD and RTF.
  • Option to display titles on all PDF pages.
  • Option to display header on all PDF pages.
  • Dynamic columns selection for PDF, XML, EXCEL, WORD, RTF and PRINT.
  • Dynamic selection of modules for PDF display (Grid, Summary and Chart).
  • Option to export Grid and Summary in Excel tabs.
  • Option to export Excel with "XLS" or "XLSX" formats.
  • Dynamic module selection (Grid and Summary) in Excel, XML and CSV and Grid in Word, RTF.
  • Option to display CSV settings for export.
  • Integration with the CHATAPI library to use with WhatsApp.
  • New macro to send whatsapp messages: sc_send_whatsapp
  • Option to insert a trendline in a chart, to attract the attention of viewers to a particular section within data values, on any of the axes.
  • Option to insert trend zones to a chart. They are similar to trend lines, except that they mark out an entire range of values, rather than just a single value.
  • Option for you to create/edit code snippets and add to them events.
  • New options to express configuration for Grid fields.
  • Added for Grid and Form filters the select2, slide, auto-complete, switch and checkbox dropdown and options - fields.
  • New watermark options in filter fields.
  • Option for data-type fields to display format next or below for: Control, Calendar, Filters and Form.
  • Added relative dashboard filters for indexes.
  • Fixed label option added in the application for the horizontal-type Form.
  • Fixed label option added in the Grid’s Summary.
  • Added new option for the Form to put the “Help” next to the titles.
  • New Macro sc_apl_default added to set an initial application to return upon session crash.
  • Macro sc_apl_default now available at creation for security module.
  • New functionalities:
  • New option for setting the level of the APIs as public, project and user.
  • Improvements to usability of Grid application link-interface.
  • Bug:
  • Fixed error in the timing of the users using the LDAP security module.

New in ScriptCase 9.2.016 (Nov 14, 2018)

  • New functionalities:
  • Added support for Jsmind, JKanban, and Orgchart components in the sc_inclube_lib macro.
  • Bug:
  • Fixed problem in the internal format of the date field in the search.
  • Fixed problem in the message view "Records not found" in the PDF Report application, using charset ISO-8859-1
  • GoJS library is no longer available for native use in Scriptcase

New in ScriptCase 9.2.015 (Nov 1, 2018)

  • Bug:
  • Fixed CSRF Tokken problem when accessing control and form applications.
  • Fixed Javascript problem generated in Blank applications.
  • Fixed problem in Ajax event in autocomplete fields.

New in ScriptCase 9.2.014 (Oct 30, 2018)

  • Fixed problem in viewing the "Unauthorized User" message logged in another language when the PHP session was expired.
  • Fixed problem when disabling HTML Editor fields
  • Fixed problem of connection variables when using connection to database in menu application from publication.

New in ScriptCase 9.2.013 (Oct 26, 2018)

  • Fixed problem in totalization when updating record linked to opening form and new window.
  • Fixed frame width problem when clicking on the menu tab.
  • Fixed problem in menu tab navigation.
  • Fixed problem in button freeze when performing Onchange Ajax processing.
  • Fixed problem in title when renaming files in helpcase.
  • Fixed problem when using select2 field on a form that has linking to another.
  • Fixed problem in project name in minor resolutions.
  • Fixed problem in the interpretation of tags in auto-complete fields, using the sc_concat macro.
  • Fixed problem in the view of type select2 field, initially configured as hidden.
  • Fixed SQL error after running the grid run button, containing a calculated field.
  • Fixed problem in looukp query processing using multi-valued option.
  • Fixed problem with the "back" button of the calendar when connected through a search application.

New in ScriptCase 9.2.012 (Oct 16, 2018)

  • Bug:
  • Fixed problem in description SSL settings for MySQL connection in the production environment.
  • Fixed problem when performing search in Quick Search using sc_concat macro in field lookup.
  • Fixed problem in the interpretation of tags in text fields of editable grid form (view).
  • Fixed CHARSET problem when using title in Select's lookup with Ajax processing.

New in ScriptCase 9.2.011 (Oct 4, 2018)

  • Bug:
  • Fixed problem in the label preview in CSV export, using the macro "sc_field_display".
  • Fixed problem with "exit URL" security settings option in menu, tab, and blank application.
  • Fixed problem when using capture text in auto-complete fields without Select2.
  • Fixed problem in CHARSET of fields when loading application settings in side menu.
  • Fixed problem when using help settings in HTML Editor fields.
  • Fixed problem using more than one link for more than one widget on the dashboard.
  • Fixed problem when creating applications in Internet Explorer 11.
  • Fixed SQL error, in XLS export, on group by with empty values.
  • Fixed problem when selecting the special conditions of the search, using the french language.
  • Fixed problem with height resizing in Ajax event editor.
  • Fixed problem when using the sc_field_color macro in Report PDF applications.
  • Fixed problem using Google Maps field, hiding columns with latitude and longitude in the grid.
  • Fixed problem in print export of grid with group by.
  • Fixed problem when using date fields with no regional setting in dynamic search with special conditions.

New in ScriptCase 9.2.010 (Sep 26, 2018)

  • New functionalities:
  • Added initial database support in editing PostgreSQL connections.
  • Bug:
  • Fixed problem when using refined search in applications, with GROUP BY in SQL clause.
  • Fixed Uninitialized string offset: 0 error, when executing form applications.
  • Fixed problem when using dropdown option in SELECT search fields.
  • Fixed problem viewing the "Jump to" button on the forms.
  • Fixed problem when using Ajax onFocus events in auto-complete fields using select2.

New in ScriptCase 9.2.009 (Sep 25, 2018)

  • New functionalities:
  • Added new example CRM system, Customer Relationship Management.
  • Bug:
  • Fixed problem when using group by in the grid, by fields containing records with single quotation marks.
  • Fixed problem in multiple lines text fields, in editable grid forms (view), adding the BR tag to break line records.
  • Fixed problem in incrementing versions using option to keep user logged in.
  • Fixed problem in select field width using Select2 with Ajax processing.
  • Fixed problem when using ajax onBlur and onChange events in auto-complete fields using select2.
  • Fixed problem loading initial helpcase file list.
  • Fixed problem in vertical alignment of responsive charts.
  • Fixed problem when using call functions inside other functions in internal libraries.
  • Fixed problem using advanced search and dynamic search with INNER JOIN.

New in ScriptCase 9.2.008 (Sep 14, 2018)

  • Bug:
  • Fixed problem in button group when saving to default project values.
  • Fixed problem in button lock when using Ajax events between fields.
  • Fixed scrolling problem in project connection at minor resolutions.
  • Fixed problem when using duplicate named methods in internal libraries.

New in ScriptCase 9.2.007 (Sep 6, 2018)

  • New functionalities:
  • Added support for 'Null' and 'Not Null' conditions in the table fields, used in the index filter on the dashboard.
  • Performance improvement:
  • Recognizing the type of form in the detail properties in the master/detail properties.
  • Bug:
  • Fixed problem with search toolbar buttons, in the Scriptcase default values.
  • Fixed problem executing checkbox fields in the search application.
  • Fixed problem displaying 'TestConn' in the connections of the production environment.
  • Fixed problem when tabbing with ENTER in auto-complete fields.
  • Fixed error Undefined variable: tmp_apl_or when executing form applications in master/detail creation.
  • Fixed error Undefined variable: sNomeCampo field when compiling form applications using Ajax event.
  • Fixed Javascript error in the execution of the helpcase button, in form and control applications.
  • Fixed problem of overlapping charts in PDF export, using charts on same page of summary.
  • Fixed problem of duplicate charts in PDF export, using charts on same page of summary.
  • Fixed empty page problem in PDF export grid with group by.

New in ScriptCase 9.2.006 (Aug 30, 2018)

  • New functionalities:
  • Added support to schema in Oracle connection settings.
  • Added support to schema in PostgreSQL connection settings.
  • Added support to initial database in creating PostgreSQL connections.
  • Bug:
  • Fixed problem in title when renaming helpcase files.
  • Fixed problem when using 'date' fields not displayed in form application.
  • Fixed problem in the positioning of the records when using the option 'Records per line' in the PDF report.
  • Fixed problem using format 1- for negative numbers.
  • Fixed problem when generating full report option in exporting HTML print.

New in ScriptCase 9.2.005 (Aug 24, 2018)

  • Fixed problem when using Oracle PDO connection without schemas enabled.
  • Fixed problem in sorting columns that list project applications.
  • Fixed problem in viewing Progress connection in projects.
  • Fixed interface problem when deleting linked virtual fields.
  • Fixed problem in sorting the fields on the form using the DB2 connection.
  • Fixed problem when using digital signature fields in grid with user defined orientation.
  • Fixed problem in the view of the "In" condition of the filter in the double select field.
  • Fixed "htmlspecialchars() expects parameter 1 to be string" error when accessing the data session interface.
  • Fixed problem in searching the field "Text autocomplete", using upper case in dynamic search.
  • Fixed problem using refined search with complex SQL queries in the grid applications.
  • Fixed problem in displaying newly modified applications in environments installed with PostgreSQL.

New in ScriptCase 9.2.004 (Aug 16, 2018)

  • Bug:
  • Fixed problem when using Current Value option in double select fields.
  • Fixed Scriptcase access problem after installing in Linux environments.
  • Fixed view problem with special periods in date fields, in the dynamic search on form.
  • Fixed problem with pageview when searching for records that didn't exist on the form.
  • Fixed problem when using dynamic group by starting with closed treeview.
  • Fixed problem in positioning the fixed label when using treeview option in the group by.
  • Fixed problem in updating numeric fields and auto-complete without filling new features.
  • Fixed problem in inserting images when using multi upload fields.
  • Fixed problem in time display in date and time fields, under special filter conditions.
  • Fixed problem when using Group Results option in the grid label filter.
  • Fixed problem when opening image manager through group of buttons in toolbar.
  • Fixed problem Fatal error: Invalid handle returned when connecting to SQL Server PDO.
  • Fixed processing problem when using Ajax events in fields assigning values ​​to itself.

New in ScriptCase 9.2.003 (Aug 8, 2018)

  • Specific correction:
  • Fixed problem when using dynamic groupby in grid applications.
  • Bug:
  • Fixed connection problem with Sybase PDO DBLIB in the production environment. (You need to upgrade production environment)
  • Fixed error Invalid argument supplied for foreach() when accessing dynamic summary without totalization.

New in ScriptCase 9.2.002 (Aug 7, 2018)

  • New functionalities:
  • Added option for the toolbar to inherit settings from project default values toolbar, using Express Edition feature.
  • Performance improvement:
  • Layout improvement on new database connection creation within the Project Edit Connection feature.
  • Bug:
  • Fixed issue in visualization of document icons on multi upload.
  • Fixed issue in blocking of buttons when using Ajax events between fields.
  • Fixed problem saving the project themes.
  • Fixed issue in data view, when navigating between records of auto-complete.
  • Fixed issue in buttons when using Grids within widgets in dashboard.
  • Fixed formatting problem in numerical values in export XLS.
  • Fixed problem with default values of the new features available in version 9.2
  • Fixed language of message ' close or Esc Key ' in modal. (Necessary to clean the browser cache)
  • Fixed issue in return for signature fields values, through the events in the control application.
  • Fixed issue when using option for indentation by space rather than in the events tab.
  • Fixed problem on inserting images into IMAGE columns with Sybase PDO connection.
  • Fixed error Invalid argument supplied for foreach () when saving settings.
  • Fixed error 2 = in_array() expects parameter 2 to be array, null given in generating query applications.

New in ScriptCase 9.2.001 (Jul 31, 2018)

  • New functionalities:
  • Added option for slider increment value in number and decimal fields.
  • Added ODBC PDO driver on Progress connections.
  • Added option for slider increment value in number and decimal fields.
  • Added support for Ajax events in rating fields.
  • Added ODBC PDO driver on Progress connections.
  • Bug:
  • Fixed installation problem in Linux Ubuntu 18 environments.
  • Fixed behavior issue when using the 'Hide menu' option in tree-menu applications.
  • Fixed issue in column recognition when synchronizing table with Oracle PDO connections.
  • Fixed connection problem with SQL Server from the production environment.
  • Fixed problem when disabling numeric fields using slider.
  • Fixed issue when using numeric fields without populating slider width.
  • Fixed bug "Invalid argument supplied for foreach ()" when using subselect fields in Report PDF applications.
  • Fixed issue in date fields using combo while browsing records.
  • Fixed width problem when resizing layers from menu structure.
  • Fixed issue in menu width, using layers in menu structure.
  • Fixed positioning problem for vertical menu.
  • Fixed issue using select select fields disabled.
  • Fixed navigation problem when using infinite scroll.
  • Fixed issue when navigating between number of pages.
  • Fixed issue when searching for fields with "no displayed conditions" in search.
  • Fixed installation problem in Linux Ubuntu 18 environments.
  • Fixed behavior issue when using the 'Hide menu' option in tree-menu applications.
  • Fixed issue in column recognition when synchronizing table with Oracle PDO connections.
  • Fixed connection problem with SQL Server from the production environment.
  • Fixed problem when disabling numeric fields using slider.
  • Fixed issue when using numeric fields without populating slider width.
  • Fixed bug "Invalid argument supplied for foreach ()" when using subselect fields in Report PDF applications.
  • Fixed issue in date fields using combo while browsing records.
  • Fixed width problem when resizing layers from menu structure.
  • Fixed issue in menu width, using layers in menu structure.
  • Fixed positioning problem for vertical menu.
  • Fixed issue using select select fields disabled.
  • Fixed navigation problem when using infinite scroll.
  • Fixed issue when navigating between number of pages.
  • Fixed issue when searching for fields with no displayed conditions in search.

New in ScriptCase 9.2.000 (Jul 23, 2018)

  • New functionalities:
  • Added PDO IBM driver on DB2 connections.
  • Added PDO ODBC driver on DB2 connections.
  • Added support for PDO driver on the Firebird connection.
  • Added support for PDO driver on Oracle connection.
  • Added support for XML export in Nested Grids.
  • Added more options to generate the XML elements, such as attribute or value.
  • Added support for customizing relative periods in date/time fields in the Filter.
  • Added new "Current Value" option to display values ​​of the column itself, without repetitions, in selection fields in the filter.
  • Added new option to customize Scriptcase hotkeys interface.
  • Added new option for exporting / importing Scriptcase hotkeys interface.
  • Added support for new combinations of hotkeys in the generated applications.
  • Added new Rating type field to display classifications in icons, within Form, Control, Calendar and Grid applications.
  • Added new digital signature type field in Form, Control, Calendar and Grid applications.
  • Added new option to "Use Select2" for select type fields.
  • Added new option to "Use Select2" for auto-complete type fields.
  • Added new option to "Use Slider" for numeric fields.
  • Added new option to "Use Switch" for radio type and checkbox.
  • Added support for API integration with Paypal Express.
  • Added support for API integration with Paypal Express Incontext.
  • Added support for API integration with Paypal Pro.
  • Added support for API integration with Paypal Rest.
  • Added support for API integration with Pagseguro.
  • Added support for integration of API with SMS Clickatell.
  • Added support for API integration with SMS Plivo.
  • Added support for API integration with Twilio SMS.
  • New functionalities:
  • Added PDO DBLIB driver on the SYBASE connections.
  • Added support for automatic key recognition, dependencies and default values ​​for Progress connections.
  • Added new option to save Search profiles in the tag filter.
  • Bug:
  • Fixed duplicity problem in Summary toolbar when using "Save Grid" option.
  • Fixed issue when running applications through the shortcut in Scriptcase interface, after changes.
  • Fixed issue in recognizing TIME type columns in application creation.
  • Fixed issue using SQL with parentheses in the sc_lookup macro parameter.
  • Fixed issue when performing dynamic content Filter search with content (+).
  • Fixed issue in task list after project conversions.
  • Fixed issue in progress bar preview during application publishing.
  • Fixed issue in displaying the Advanced Filter tags when opened in modal.
  • Fixed issue in the field label when using virtual fields, in the labels Filter.
  • Fixed issue when using Ajax event in decimal fields.
  • Fixed problem when incrementing versions of the project, bigger than the current version.

New in ScriptCase 9.1.009 (Jun 20, 2018)

  • Fixed issue using special conditions in date fields, in filter.

New in ScriptCase 9.1.008 (Jun 19, 2018)

  • Fixed Fatal error: Uncaught Error: Call to undefined method appname_apl:: SC_lookup_nas () within the search of the Quicksearch.
  • Fixed problem in viewing the manual lookup, in the Grid detail module.
  • Fixed problem when using the sc_redir macro in menu applications.

New in ScriptCase 9.1.007 (Jun 14, 2018)

  • Fixed problem when using sc_redir macro in blank applications.

New in ScriptCase 9.1.006 (Jun 11, 2018)

  • Fixed problem when sending email to more than one administrator, in security module.
  • Fixed problem when performing searches in Database Builder.
  • Fixed problem in the target "parameter" when opening the application call, using the sc_redir macro together with the sc_exit macro.
  • Fixed problem when using macro sc_redir with modal passing as parameter variable with single quotes.
  • Fixed problem when using 'Exit Application' option on Forms with capture connection.
  • Fixed problem when using Ajax processing in filter fields in Grid application.
  • Fixed problem when customizing regional settings of date fields in dynamic Groupby's.
  • Fixed problem when using the sc_redir macro, opening in new page, in PHP buttons.

New in ScriptCase 9.1.005 (Jun 6, 2018)

  • Bug:
  • Fixed problem when reporting the negative sign before the value, in numeric fields.
  • Fixed problem in running summary filter when grid was started in chart mode.
  • Fixed problem when saving changes to the interface of the project default values.
  • Fixed problem when generating the summary using the SQL limit option.
  • Fixed problem in express edition, applying changes individually in all applications.
  • Fixed 'Back' button description in drilldown charts.
  • Fixed problem when listing macros in control (HTML) applications.
  • Fixed problem for line break in multi line text fields.
  • Fixed problem when using floating menu without toolbar.

New in ScriptCase 9.1.004 (May 26, 2018)

  • New functionalities:
  • Added style support for CSS, LESS, SCSS, JS, HTML, XML and PHP code from the file extension used in the external library.
  • Added shortcut CTRL(CMD) + ALT + I for automatic indentation of selected code. You will need to clear your browser's cache.
  • Added functionality to expand/collapse code blocks in the editor.
  • Bug:
  • Fixed problem in floating vertical menu, using toolbar.
  • Fixed problem in displaying the "Positive currency format" option in summary numeric fields.
  • Fixed problem in incrementing days in sc_date macro.
  • Fixed problem when viewing the image field in the form grid editable(View), shortly after a search in the QuickSearch filter.
  • Fixed problem in the application view procedure, when there were other connections other than the MS SQL Server connection.
  • Fixed problem saving chart themes.
  • Fixed problem when selecting value in capture link, in editable grid forms.
  • Fixed problem while clearing a QuickSearch search.
  • Fixed problem in form's onChange Ajax event. The event was being processed 2 times.
  • Fixed problem in label filter when using fields with Ajax processing.

New in ScriptCase 9.1.003 (May 19, 2018)

  • Bug:
  • Fixed 'unauthorized user' error message when deleting the project.
  • Fixed issue when using comment with slash on events.
  • Fixed crash when generating applications that contains parentheses in the application's SQL.
  • Fixed issue in creating Grid application when informing SQL with parentheses.

New in ScriptCase 9.1.002 (May 18, 2018)

  • New functionalities:
  • Added support for global variables in reCaptcha and Captcha fields.
  • Added capture link in tags filter.
  • Updated new component of the SPIN option of the Form.
  • Bug:
  • Fixed issue in navigating the Grid using the Internet Explorer 11 browser.
  • Fixed horizontal scrolling issue in SQL Builder with results with many columns.
  • Fixed error in SQL, when changing charset in the creation of the application.
  • Fixed issue when using a global variable in sql Grid fields.
  • Fixed issue in aligning numeric fields in GridEditable forms.
  • Fixed issue in the display of the option "Validation Image" in the field of type "data", configured as mandatory.
  • Fixed issue in displaying the mandatory field message in ajax in date field in Forms.
  • Fixed issue in SELECT, RADIO and CHECKBOX fields using manual lookup in HTML controls.
  • Fixed issue when creating Grid applications using SQL functions without aliasing.
  • Fixed issue when creating Grid applications using queries like SELECT * table.
  • Fixed issue in the menu when using the toolbar buttons with the "hide menu" option. The buttons were not being displayed correctly.
  • Fixed issue using URL without "maps.google.com" in Google Maps fields.
  • Fixed reCAPTCHA validation on Form update.
  • Fixed error in running a Grid using JOIN on Access type connections.
  • Fixed problem in Search of QuickSearch containing apostrophe.
  • Fixed CSRF Token error in applications opened within the menu tabs.
  • Corrected problem using the "Use Password" option in the security of applications that used connections. The applications that received the connection were loaded by requesting the password again.

New in ScriptCase 9.1.001 (May 10, 2018)

  • New functionalitiesUPGRADE REQUIRED :
  • Enabled the email export buttons in the Grid's detail.
  • Bug:
  • Fixed issue in Access connections using password.
  • Fixed issue in menu events using strings.
  • Fixed charset issue when entering values in form Editable Grid view.
  • Fixed charset issue in the "Description" field in the calendar application when using ISO-8859-1 charset.
  • Fixed issue in the email API interface in the production environment. (You will need to update your production environment).
  • Fixed problem in typing the numeric fields by using the option complete with zeros.

New in ScriptCase 9.1.000 (May 7, 2018)

  • New features:
  • A new interface for managing APIs directly from Scriptcase with automatic integration with the email APIs services: Mailchimp, Mandrill and Amazon SES.
  • New Macros sc_call_api and sc_send_email_api for advanced implementations with APIs integration within Scriptcase events, control and blanks.
  • New button to send emails from Grids, Pivot Tables and Charts with reports attached in PDF, HTML, XLS, XML, CSV, RTF, WORD or images. Push settings can easily be shown within the interface using SMTP, Amazon SES or Mandrill.
  • For Chart applications where added new settings to export to formats: XLS, XML, CSV, RTF, WORD and image;
  • For HTML and Images exports from Chart applications, it was added a new important option for Chart depth output selection, according to the metrics used.
  • New option for depth output selection to PDF exports within Grid Applications.
  • New dynamic tags for Advance Search module that allow you to select or manipulate the conditions and fields with ajax directly within the application with a simple and modern interface.
  • New configurations options that allows, for example, to add buttons within the Advanced Search form body.
  • In the Summary and Chart Search feature were added new relative period conditions to Filter: "Current week until today", “Current quarter until today” and “year to date”.
  • New options for creating customized periods with related conditions directly within the Summary and Chats Filter interface. It gives you freedom to create special period of date.
  • Added new keyboard shortcuts for performing basic functions of Scriptcase as: Generate the source code, Save application, Run, Closing/Opening tabs, access SQL Builder and others
  • New option to display Nested Grids as XLS export.
  • New setting to configure Chart original sorting values to and return to default state.
  • Scriptcase codes editor, used within the events, control and application blank with new options for viewing with lateral expansion or full screen code area and access to new themes.
  • Integration with shortcut keys from editors Emmet and Sublime Text, that is, the shortcut keys of these editors will be recognized within the Scriptcase.
  • CSS and Javascript language interpretation support within the code editor.
  • New button for project execution.
  • New example template with the HTML diagram library of GoJS for creating Mind maps This template will be inside the "Samples" project (you will need to import samples project to access the applications).
  • Database Builder update with a new Interface facilitating performance for creating and changing your database. New theme, store server-side to avoid excessive requests, accessibility labels (HTML5) and new languages: Danish, Greek, Galician, Bulgarian, Bosnian, Finnish, Hebrew and Malay.
  • Database Builder update for MySQL: Support connecting to MySQL via SSL, support JSON data type, Support MySQL 8.
  • Atualização do Database Builder para o MariaDB: Suporte JSON desde o MariaDB 10.2 e suporte a índices fulltext e espaciais no InnoDB.
  • Database Builder update for PostgreSQL: Support binary files in bytea fields.
  • Database Builder update for PostgreSQL: support JSON and JSONB data types, materialized views.
  • Database Builder update for SQLite: Allow deleting PRIMARY KEY from tables with auto increment.
  • Database Builder update for SQLite: enable FOREIGN KEY CHECKS.
  • Database Builder update for SQL Server: Support freetds.
  • Database Builder update for SQL Server: support pdo_dblib.
  • Performance improvement:
  • Updating the new HTML editor
  • Bugs:
  • Fixed issue when using the macro sc_label in multiple record forms and grid editable.
  • Fixed issue in setting the maximum size of the field on the filter settings.
  • Fixed issue in preview of the label of the columns in the XLS export when the application was using language variables.
  • Fixed issue in the duplicity of the characters as they are typed in mobile environments.

New in ScriptCase 9.0.043 (Mar 23, 2018)

  • Specific correction:
  • Fixed problem with alignment of fields' type "radio" and "checkbox" when using manual lookup.
  • Fixed issue in visualization of indexes on the dashboard applications using the SQL Server connection.
  • Fixed issue in the HealthCare System with Postgres, SQL Server and Oracle connections.
  • Performance improvement:
  • Improvements in the applications sorting in the project applications's list.
  • Bug:
  • Fixed issue in target "_blank" parameter of the macro "sc_redir" by using the macro along with the macro sc_exit.
  • Fixed issue when using the "dynamic filter" button on summary application.

New in ScriptCase 9.0.042 (Mar 16, 2018)

  • Specific correction:
  • Fixed problem using the macro sc_hide_groupby_rule in grid applications.
  • Performance improvement:
  • Improvement in group by of summary group by using Progress connection.

New in ScriptCase 9.0.041 (Mar 15, 2018)

  • New functionalities:
  • Added new healthcare sample system.
  • Specific correction:
  • Fixed issue in Quicksearch when using the connections of type "Progress".
  • Fixed issue of accentuation in the help descriptions of the fields in the Filter application.
  • Fixed issue of accentuation in the visualization of the values of the manual lookup in the breakdown of the query.
  • Fixed issue in the search of field type "data" in connection of type "Progress".
  • Bug:
  • Fixed issue in viewing the "rows" button in the Grid, when the Summary module was disabled.

New in ScriptCase 9.0.040 (Mar 8, 2018)

  • New functionalities:
  • Added option to run the onchange event in the field of the master Form when using sc_master_value macro in Form detail.
  • Specific correction:
  • Corrected issue when using the values of the field of type "data" in the Groupby of the Summary, in the connections of type Progress.
  • Bug:
  • Fixed issue using the CONCAT command in the Grid lookup.
  • Fixed bug when using the "Arial" font in the Reportpdf application.
  • Fixed issue in Chart filter view when exporting to pdf.

New in ScriptCase 9.0.039 (Mar 1, 2018)

  • Specific correction:
  • Fixed issue in updating the values in the lookup type of multiple binary values.
  • Fixed issue in the field tab "date" in the Filter using the range condition.
  • Fixed issue when using SQL UNION in autocomplete fields.
  • Performance improvement:
  • Improved performance in the "date" field searches on MSSQL Server connections.
  • Bug:
  • Fixed issue with “Filter Saving” using "double select" field type.
  • Corrected issue with "Filter Saving", when the Grid had Group by using data type fields.
  • Fixed issue when saving theme in Charts, in Scriptcase versions that were installed with Mysql.
  • Fixed issue in ajax events of the Grid when using full pagination. Before that, the event was only created in the first 10 records.
  • Fixed issue in Filter search with negative values.
  • Fixed issue in character display in Summary Filter using charset windows-1255 (Hebrew).
  • Fixed issue using the CONCAT command in the Grid lookup

New in ScriptCase 9.0.038 (Feb 22, 2018)

  • Adjustments in the display of the Chart application and Summary Filter buttons.
  • Bug:
  • Fixed issue in the lookup description of the text fields and autocomplete numbers when returning from the Grid.
  • Fixed height in the checkbox by clicking multiselect on refined filter.
  • Fixed issue when using the sc_log_add macro in the Blank application.
  • Fixed issue when assembling the "Order by" in the SQL of the Grid, when the application has two breaks for the same field of type data.
  • Fixed issue in viewing images from field "image file name" using the subdirectory option.

New in ScriptCase 9.0.037 (Feb 16, 2018)

  • Specific correction:
  • Fixed issue when using parentheses at the "hint" parameter in the sc_link macro.
  • Fixed issue when using the "sc_label" macro in fields that use language variables, generated by the data dictionary in Grid applications.
  • Fixed issue in the display of the "docx" extension icon, when using the "Display the file type icon" option in the document fields of the Grid application.
  • Corrected height in the checkbox by clicking multiselect of the refined filter.
  • Performance improvement:
  • Improved performance in Summary applications.
  • Improved performance in field data searches on Postgres connections.

New in ScriptCase 9.0.036 (Feb 6, 2018)

  • New functionalities:
  • Added support for global variables through the new macro "sc_make_link".
  • Added new options under summary and charts filters.
  • Specific correction:
  • Fixed problem in the table creator interface for calendar applications with an Access connection.
  • Fixed problem with the format of time values in the backup filenames.
  • When using an Editable Grid (View) form, File Upload fields now can only be downloaded on lines that are in editing mode.
  • Performance improvement:
  • Improvement of performance of autocomplete fields on a filter.
  • Bug:
  • Fixed problem with the images and templates copied while migrating from version 7 to 9.
  • Fixed problem with the images and templates copied while migrating from version 6 to 9.
  • Fixed problem that could corrupt GroupBy data while migrating from version 6 to 9.
  • Fixed issue in version 5 to 9 migration.
  • Fixed problem when using sc_redir in a PHP method called from a PHP button.

New in ScriptCase 9.0.035 (Jan 25, 2018)

  • Specific correction:
  • Fixed issue in returning a connection when we use the sc_select (where) macro in the source application.
  • Fixed issue when running the application "Dashboard" in the interface's initial mode.
  • Fixed issue in view of field view lookup when condition had dot.
  • Fixed problem of accentuation in the label of the macro button "sc_ajax_message", when using charset other than UTF-8.
  • Corrected spacing of the navigation buttons being displayed below.
  • Bug:
  • Corrected issue in displaying the values of the field "Data" in the interface of the Group By. You will need to clear your browser's cache.
  • Fixed special SQL error in Grid Application.
  • Fixed anchor of the menu link in the documentation.

New in ScriptCase 9.0.034 (Jan 19, 2018)

  • New functionalities:
  • Added lang support in the sc_alert macro. Ex: sc_alert ({lang_btns_ajax})
  • Enabled the image and document database fields in the Grid columns interface.
  • Enabled the examples in the onScriptInit event of the Grid.
  • Specific correction:
  • Fixed validation of values in the interface of version incrementation.
  • Fixed issue in the events help link.
  • Fixed issue in searching for Dynamic Search with data type "TIMESTAMP WITH LOCAL TIMEZONE".
  • Corrected issue in viewing the refined filter values, after returning from Summary Group by links.
  • Fixed issue in hint viewing on field links using Sc7_Black theme.
  • Bug:
  • Fixed issue Tab_lig_apls is not defined in Grid links called through the Menu.
  • Fixed issue in the display of the "delete" button when canceling the edition of record in the Grid view editable Form.
  • Fixed "Array to string conversion" error when using the sc_mail_send macro.
  • Fixed issue when generating a free format Grid without the toolbar buttons.

New in ScriptCase 9.0.033 (Jan 12, 2018)

  • New functionalities:
  • Added RTL language support in the Summary filter.
  • Specific correction:
  • Fixed Grid export issue when using macros "sc_seq_register" and "count_ger" in the OnRecord event.
  • Fixed macro help link in events.
  • Bug:
  • Fixed issue in Chart display in pdf export.
  • Fixed issue in NestedGrid type links.

New in ScriptCase 9.0.032 (Jan 10, 2018)

  • New functionalities:
  • Added option to display the background image of the pdf report when no record is found. This option is available in the SQL interface menu.
  • Added option for the positioning of the registration message that does not exist in the PDF Report. This option is available in the SQL interface menu.
  • Added dropdown support in SELECT filter fields.
  • Added support for complex SQL in Auto-complete fields.

New in ScriptCase 9.0.031 (Dec 27, 2017)

  • New functionalities:
  • Added new values ​​in the "negative currency format" option in the total fields of the summary.
  • Added grid navigation configuration support from master / detail.
  • Added support for YEAR fields.
  • Added support for Nested Grids in Grid details.
  • Implemented support to macro "sc_format_num" in the onrecord event of the grid, using summary fields.
  • Added "port" option in SFTP publishing settings.
  • Added port data entry for DB2 connection.
  • Specific correction:
  • Fixed issue when converting Access tables that have images.
  • Fixed issue in the initial execution of pyramid and 2D funnel charts.
  • Fixed issue when using subselect command in field lookup.
  • Fixed issue when running operations directly in the application's SQL.
  • Fixed issue using "Use ENTER to Submit" option in dynamic filter settings.
  • Adjustments in the Nested Grid css when using the title option on the same row.
  • Fixed issue in view of the buttons size on the iframe type connections.
  • Bug:
  • Fixed issue in viewing the records in the calendar by checking the option "all day". The schedule showed less 1 day.
  • Fixed issue in formatting millisecond fields.
  • Fixed duplicate data insertion problem with dynamic search.
  • Fixed issue when using the database session option in the post.
  • Fixed issue in viewing calendar time on Oracle connections.
  • Fixed issue in the Themes view of the tree menu. The tree menu was not inheriting the Themes css.
  • Fixed Fatal error: Uncaught Error: Call a member function Execute () when using the sc_lookup macro in the ReportPdf application onHeader event.
  • Fixed issue in the informed value of the negative field of manual lookup of the multiple selection fields.
  • Fixed issue in viewing calendar records on Access database connections.
  • Fixed issue when using the menu toolbar with image type buttons.
  • Fixed issue when using link button in Editable Grid Form (view).
  • Fixed issue in pdf export when printing mode was configured for economic.

New in ScriptCase 9.0.030 (Dec 14, 2017)

  • New functionalities:
  • Added macro support "sc_format_num" in the onrecord event of the grid.
  • Specific correction:
  • Adjustment in error display when editing multi-upload fields.
  • Fixed issue in gantt chart view with other date formats.
  • CSS settings in the editing of the menu toolbar and editing of menu items.
  • Bug:
  • Fixed issue in macro "sc_field_disabled" in fields select multiple values in single record form.
  • Fixed issue in connection of subquery type in firebird connections.
  • Fixed issue in express creation of applications.
  • Fixed bug with sc_ajax_message macro.

New in ScriptCase 9.0.029 (Dec 12, 2017)

  • New functionalities:
  • Addition of new sources from the Reportpdf application.
  • Added option for title break in calendar view.
  • Specific correction:
  • Fixed issue in the display of the "filter conditions" in the "double select" field in the generated filter applications. From this version onwards, the filter will support the conditions: equal, contains, different, does not contain, empty content, non-empty content.
  • Implemented the option to use the "FORCE ORDER" command in grids using the MSSQL Server connection.
  • Fixed issue using the sc_ajax_message macro in the html control application.
  • Fixed issue in assigning the fields in the onLoad event in the html control application.
  • Added macro support "sc_btn_display" in editable grid forms and editable grid view. Note: The code must be used in the onLoadRecord event, where it will be executed with each record in the record. If done on onLoad, it will run only once.
  • Fixed issue when using submit option in onChange and Ajax processing in grid filter.
  • Bug:
  • Fixed issue in displaying the characters when being informed in the quicksearch field. The error occurred in Chrome and Safari browsers.
  • Fixed "Undefined offset" error when using the sc_date_dif_2 macro.
  • Fixed issue when creating a Subselect field in the Reportpdf application on Firebird connections.
  • Fixed issue in displaying the fields of the breaks in the matrix summary selection interface.
  • Fixed issue in viewing recurrence fields in calendar application. The fields were not being hidden in the Firebird and Oracle connections.
  • Fixed issue in the 'Display values' option of the generated application not being inherited from the interface.

New in ScriptCase 9.0.028 (Dec 3, 2017)

  • Specific correction:
  • Fixed issue when running the sc_error_message macro in the onValid event on mobile devices.
  • Fixed issue when using the high box setting of text type fields on mobile devices.
  • Fixed issue in time view in calendar events using SQL Server connection.
  • Bug:
  • Fixed issue in grid export containing hour type fields.
  • Fixed issue when informing the path of the data source in the interface Import of Access.
  • Fixed error of Undefined variable: str_tog_help when clicking on the relationship item N x N.

New in ScriptCase 9.0.027 (Nov 28, 2017)

  • New functionalities:
  • Added new values for the "uncategorized" option in the "category" field in the calendar application.
  • Specific correction:
  • Fixed issue when using the "Database session" option with the MariaDB SGDB.
  • Fixed bug in field view when application was created containing the hyphen character in application name.
  • Fixed issue in creating calendar table in Oracle connections.
  • Bug:
  • Fixed issue in the "where" clause of the grid filter, when the main SQL had a clause "where".
  • Fixed bug in the creation of the field "Subselect" in the connections of type Access.
  • Fixed issue in viewing the records in the calendar when using the category filter option.

New in ScriptCase 9.0.026 (Nov 22, 2017)

  • New functionalities
  • Added new options for border "color" and "width" in the form blocks' CSS
  • Automatic Recovery of ' auto increment ' value in the DB2 type connections
  • Added support for "tab" key for autocomplete fields for the first record add.
  • Added new options for border "color" and "width" in the form fields' CSS
  • Added support to ajax events creation for the "category" field in the calendar application.
  • Specific correction
  • Fixed Fatal error: Invalid handle returned, MSSQL SERVER connections.
  • Fixed issue in Grid SQL when using the character * (asterisk) within a case statement.
  • Fixed issue when creating the calendar table using Firebird connection.
  • Fixed issue in the amendment and updating of the indexes in the data dictionary.
  • Fixed issue when synchronizing the field size in the data dictionary.
  • Fixed issue in Grid SQL when using the character "hyphen" within a case statement.
  • Fixed issue when creating a button and choosing that it only appears when edditing a Editable Form (Grid view) format.
  • Bug
  • Fixed formatting problem of the fields "currency" and "decimal precision" in the Advanced Search.
  • Fixed issue with scrollbar when changing menu's tab.
  • Fixed issue when creating Grid application using JOIN in Access connections.
  • Fixed issue when using the macro "sc_date_conv" at the OnHeader event from ReportPDF application.
  • Fixed an issue in the Editable Form (Grid view), when the primary key field was not displayed in the application.

New in ScriptCase 9.0.025 (Nov 17, 2017)

  • New functionalities:
  • Improved responsiveness of the calendar application toolbar.
  • Specific correction:
  • Adjustments made in the "Characters Allowed" field alignment in the field settings of type "Text".
  • Fixed issue using global variables in sc_exec_sql macro.
  • Fixed issue in retrieving data types when importing an excel file.
  • Fixed issue when editing the field that updates the application connection table "app_form_edit_users" generated by the security module.
  • Fixed issue when incrementing the version of a project, when there was a log module configured to the project.
  • Fixed issue when automatically identifying the unique keys of the Sqlite connections in the form.
  • Fixed issue using the sc_changed macro in the DATETIME field in the MSSQL SERVER connections.
  • Fixed issue when updating zip code in the onChange event, using autocomplete fields in assignments.
  • Performance improvement:
  • Adjustments in the application creation interface when the table and field names exceed the input preview limits.
  • Removed white space in the html code generated by the form when there was a capture link.
  • Bug:
  • Fixed issue when using refined filter in field with alias in query with GROUP BY.
  • Fixed issue when using a field containing a capture link and an ajax event on mobile devices.
  • Fixed issue using the sc_set_language macro in the onScriptInit and onApplicationInit events.
  • Fixed issue using the sc_error_exit () macro in the onValidate event of the filter.
  • Fixed issue in the calendar's exit button display in deployed environments.
  • Fixed issue in visualizing the fields of the dynamic breaks in the totals of the grid.
  • Fixed issue in link of dynamic breaks using SQL with JOIN and fields using capital letters.
  • Fixed bug when adding another display field in summary filter lookup. You will need to clear your browser's cache.
  • Corrected issue in the option "Create link in chart" of Grid chart.
  • Fixed issue in XLS and XML export when referencing some field of type "date" in onGroupByAll events.
  • Corrected issue in aligning the fields of the pdf report using the "record per line" type.
  • Fixed issue with line break in HTML editor fields with fields of type LONGBLOB.

New in ScriptCase 9.0.024 (Nov 13, 2017)

  • New functionalities:
  • Added option to hide caption in chart. Option is now available in the chart settings.
  • Inclusion of the 'BETWEEN TWO VALUES' condition for the 'TEXT', 'VALUE' (currency) and 'DECIMAL' field types under the filter conditions.
  • Added option to select initial values ​​in the dynamic break interface.
  • Added the value of "Dynamic Break" in the "Break Initial" option in the break settings.
  • Added option to display or not the "new record" button of the grid in the Dashboard toolbar.
  • Adjustments in the layout of breaks.
  • Specific correction:
  • Fixed issue of downloading files in the Multi-upload form in mobile mode.
  • Fixed issue in option 'Display values' and 'Short values' in multi-series graphics.
  • Fixed issue in event display while hiding calendar categories filter.
  • Fixed issue when setting the maximum file size. The application allowed to send a file of a larger size than the one that was configured.
  • Fixed issue when copying html files in Helpcase tool. The title of the page was not being replaced.
  • Fixed issue in displaying project name after accessing Scriptcase.
  • Fixed issue in time display in events with no time and / or end date in the calendar.
  • Fixed issue using the sc_changed macro in the date and time field in the MSSQL SERVER connections.
  • Fixed issue in the "Display Mask" option in the settings of the break fields.
  • Bug:
  • Fixed issue in the preview of the default values ​​in the summary filter.
  • Fixed error in the pdf layout by the registry option per line in the interface.
  • Fixed the Grand Total option of chart applications.
  • Fixed issue when changing the grid SQL in grid and graphical applications. The "Number of records" field was being removed from the total.
  • Fixed issue sending file with extension that are not allowed. Invalid file message was not being displayed.
  • Fixed unserialize () error: Error at offset 625 of 774 bytes | Script: nmField.class.php line: 4114, when entering more than one lookup field in the summary filter.
  • Fixed issue in the summary link generated through dynamic breaks using SQL with JOIN.
  • Fixed issue in Gauge chart generation.
  • Fixed error: Invalid argument supplied for foreach () - 2707 nm_gp_consulta_cons.php when using the empty "break" option.

New in ScriptCase 9.0.023 (Nov 5, 2017)

  • Specific correction:
  • Fixed mkdir() error in generating applications.

New in ScriptCase 9.0.022 (Nov 5, 2017)

  • New functionalities:
  • Added option to display events without filter categories within the calendar.
  • Added support to add multiple categories in the calendar filter.
  • Added option to hide the filter categories field within calendar.
  • Added option to export calendar events to Google Calendar.
  • Updating the FusionCharts Chart Library, now supports FusionMaps(Need to upgrade your production environment)
  • Added support for the FusionCharts library in the sc_include_lib macro. Check the documentation
  • Performance improvement:
  • Improvement of Scriptcase projects converter.
  • Bug:
  • Fixed problem in the PDF report layout display on the interface when using the width and height parameters in the customized format.
  • Fixed problem when using label fields with Javascript code.
  • Fixed problem in the PDF report help ruler when using the customized format.
  • Fixed interface problem with PHP method names.
  • Fixed problem with when selecting an internal library in the project default values, and then creating a blank application. The library wasn't being check in that cases.
  • Fixed problem when using lookup as field description in MS SQL Server connections.
  • Fixed problem with the link between Grids and Forms (throttling starts by the filter). The exit button was not displayed.
  • Fixed problem when using sc_set_language macro in the blank application.
  • Fixed problem when using the macro sc_select_where(add) with the option "any condition" in the Grid filter.
  • Fixed problem accessing the Image Manager from the home page in the Helpcase settings.
  • Fixed problem accessing records in the calendar after the update/insert other.
  • Fixed problem on "Repeat one each" insertion on calendar events.
  • Fixed problem in calendar events display, from printing.
  • Fixed problem when using the "sc_concat" macro from search autocomplete fields.
  • Fixed problem in the lookup display in the dynamic group by from Grids when using a calculated field.
  • Fixed problem when running the menu using the Catalan language (Spanish).
  • Fixed problem in size of the object "Double Select" display from dynamic search.
  • Fixed problem with global variables display when defined within group by lookups.
  • Fixed problem in the search autocomplete when using subselect in the Grid main SQL.
  • Fixed problem with the summary link when using dynamic group by.
  • Fixed problem with pie chart button for various dimensions with drill down using only one metric.
  • Fixed problem on Grid application when creating a link from the Chart to a Grid.

New in ScriptCase 9.0.021 (Oct 20, 2017)

  • New functionalities:
  • Added new example project Personal Finances.
  • Added new events in the calendar application: onCalendarApplicationInit and onCalendarScriptInit.
  • Added DB2 support in sample projects.
  • Added support for .tgz formats in the deploy generation.
  • Added support for the GoJS library in the sc_include_lib macro. Check the documentation
  • Specific correction:
  • Fixed bug in reCAPTCHA SSL certificate in Mac OS. For environments already installed, see the tutorial
  • Fixed problem when dragging multi-day events into calendar.
  • Improvement in the layout of the Calendar Categories field in the form of calendar application.
  • Fixed preview problem on calendars buttons called from dashboards.
  • Fixed problem in multi-day event viewing in calendar.
  • Fixed problem in viewing times at events marked 'full day' in the calendar.
  • Bug:
  • Fixed error "file_get_contents() failed to open stream: No such file or directory" when viewing the layout in the application settings.
  • Fixed problem when saving theme name of the menu using the "/" character.
  • Fixed problem viewing the HTML code of a header template copied in Helpcase.
  • Fixed problem creating header template in Helpcase.
  • Fixed problem in the analysis of comments by blocks and line with global variables.
  • Fixed problem navigating forms, when using option "Use Checkbox in drop down" in select fields.
  • Fixed problem using global variable in lookup field with group by in the grid.
  • Fixed problem using the connection parameter, being created dynamically through the macro sc_connection_new.
  • Fixed problem with displaying language/regional settings in application settings.
  • Fixed problem in the options saved in the security module profile.
  • Fixed problem displaying the date field using other formats in the chart application.
  • Improved text in the interface for uploading external libraries.
  • Fixed problem in link of type application, when the key field had dot.
  • Fixed problem in grid totals when using Group by syntax in main SQL.
  • Fixed problem when entering values ​​with accent in the option "Text between values" in the settings of the date field in the search.
  • Fixed problem when inserting date type fields, disabled in the interface and assigned through events.
  • Fixed problem in "Save Filter" option in generated applications, using select fields with Ajax processing.

New in ScriptCase 9.0.020 (Oct 9, 2017)

  • Specific correction:
  • Fixed problem in automatic updating in Windows environments. (failed to open stream: Invalid argument, md5_file)

New in ScriptCase 9.0.019 (Oct 6, 2017)

  • New functionalities:
  • Added option to hide recurrence fields in calendar application.
  • Added option to hide time fields when scoring all day in calendar application.
  • Added new field for calendar categories.
  • Added category filter in calendar sidebar
  • Added Google reCAPTCHA v2 integration in creating the security module.
  • Added Google reCAPTCHA v2 integration in form, control, and calendar application security.
  • Added option for color palette in the Color HTML fields.
  • Bug:
  • Fixed problem in "Empty Content" condition of checkbox fields in search.
  • Fixed problem when using the "Select the fields that will be displayed in the Group By line" option when the field was not being used in the Group By.
  • Fixed issue when running menu application without setting up a connection.
  • Fixed problem in analysis of comments by lines and blocks.
  • Fixed issue when using sc_field_style macro on links created by the sc_link macro.
  • Fixed problem when displaying date type values ​​when using the sc_log_split macro.
  • Fixed problem in later records behavior when using sc_field_style macro.
  • Fixed problem in reloading dashboard indexes.
  • Fixed problem in the use of virtual fields in the grid Group By.
  • Fixed issue of footer display in PDF export of Chart.
  • Fixed issue when using special characters fields in grid Group By using MSSQL Server connections.
  • Fixed problem using field variable on Group By label.
  • Fixed problem in totalization display when Group By field has value 0.

New in ScriptCase 9.0.018 (Sep 6, 2017)

  • New functionalities:
  • Added new application theme, "Sc9_Meadow".
  • Added support for default values ​​in chart and summary search.
  • Added new values ​​to the "Relative Period" option in the summary search.
  • Added option to sort values ​​in chart with drill down navigation.
  • Improved display of filtered field for chart and summary.
  • Specific correction:
  • Fixed problem in PDF export of chart application.
  • Fixed execution problem in checkbox fields configured with manual lookup and Ajax event.
  • Fixed problem when accessing dynamic group by in summary: At least one field should be related to the Y axis.
  • Bug:
  • Fixed problem uploading files to HTML templates.
  • Fixed problem with 'copy' button for Helpcase HTML template.
  • Fixed problem when creating a Helpcase header template.
  • Fixed problem in "Create Select" interface in lookup settings.
  • Fixed problem using "Relative Period" with "Multiple Values" option in summary and chart search.
  • Fixed interface problem when renaming the application.
  • Fixed problem when saving "Negative number format" option in fields and regional settings.
  • Fixed problem when copying images through image manager.
  • Fixed problem in viewing the connection icons in XLS, CSV and Access import.
  • Fixed display problem in dimension numeric field settings.
  • Fixed problem in langs view in the calendar of data type fields.

New in ScriptCase 9.0.017 (Aug 19, 2017)

  • New functionalities:
  • Added button to print in the export of the detail of the print type query.
  • Specific correction:
  • Fixed issue in the visualization of the buttons using the sc_btn_display macro.

New in ScriptCase 9.0.016 (Aug 18, 2017)

  • New functionalities:
  • Added option to start by the filter in chart applications. Option available in settings interface.
  • Improved display of the "Export Chart" option in the chart interface. Option available in chart settings.
  • Improved the look of the "Filter Conditions" item of the filter menu in the interface.
  • Added the control application in the "Connection Widget" of the dashboard.
  • Added sc_text_style macro for Query application. View documentation
  • Added button to print in the Print Query export.
  • Added option " between two values " in filter conditions for numeric fields.
  • Specific correction:
  • Fixed issue in displaying the field type Youtube configured as modal.
  • Fixed recording of the "File name (only to store in the database)" option in the multi upload fields.
  • Fixed chart display when using filter in chart applications.
  • Fixed issue in totalization variables in onGroupBy when not using groupby.
  • Fixed negative format display for Decimal fields of groupby totalization in the query application.
  • Fixed image upload selector display in HTML Templates.
  • Fixed issue when listing internal libraries in the project default values.
  • Fixed issue using global uppercase variables in the dashboard filter.
  • Fixed issue in the HINT view of the sc_link macro in URL fields.
  • Fixed issue using sc_field_read only macro in Ajax Events.
  • Fixed issue in button display when using sc_btn_display macro.
  • FIxed issue in horizontal scrolling of the side menu of applications.
  • Fixed issue in displaying " Filter Settings " and " Special Conditions " options in "date" and "datetime" virtual fields of the filter.
  • Performance improvement:
  • Improved performance in advanced search of date fields using PostgreSQL connections.
  • Bug:
  • Fixed issue in the visualization of the field options "Initial ordering" in the graphic interface.
  • Fixed Fatal error: Parameter Redefinition, when using field name Duplicate in autocomplete field edit lookup.
  • Fixed query pagination problem using Limit option.
  • Fixed issue when setting the NULL value in fields of type nVarchar in SQL SERVER in Forms.
  • Fixed issue in "Master Detail" application view in mobile applications.

New in ScriptCase 9.0.015 (Aug 11, 2017)

  • New functionalities:
  • Added support to third digit in version increment of the projects.
  • Specific correction:
  • Fixed issue in PDF export of query with group by and charts.
  • Fixed issue when using special characters "<" in automatic lookup of form applications.
  • Fixed problem in finding the page generated from the helpcase, using special characters.
  • Fixed issue in Multi upload fields using MSSQL Server Native SRV PDO and PDO_DBLIB driver.
  • Fixed PDF export issue in environments that only accept the https:// protocol.
  • Removed the fields with the data types: Date, Time, Timestamp, Clob, Blob, Bytea, Oid, Lo, Varbinary, Image and Xml of the Quick search interface.
  • Fixed issue in displaying button "OK" in the form of applications when the user dont have access to application. (Non-authorized user interface).
  • Fixed issue in updating disabled fields with N-N relation.
  • Fixed issue when saving Query filter in Double Select fields with Characters.
  • Fixed issue using quicksearch with% character in PostgreSQL connections.
  • Fixed issue in displaying the configuration images in the image manager. (It's necessary to clear the browser's cache.)
  • Performance improvement:
  • Added protection to download links of the generated applications files.
  • Improved visualization of the macros documentation. (It's necessary to clear the browser's cache.)
  • Bug:
  • Fixed issue while acessing the config.php file.
  • Fixed bug - invalid argument supplied foreach()-nm_gp_chart_hystogram.php 458 when configuring column-type chart in queries.
  • Fixed Fatal Error : Uncaught Error: Call to undefined method proc_teste_cat_grid :: totaliza_php () in the execution of the applications of type procedure.
  • Fixed bug Invalid argument supplied for foreach () | Script: devel class page nmPageMenu.class.php line: 1862 when creating a procedure application.
  • Fixed issue using macro sc_error_message and sc_error_exit.
  • Fixed issue when using totals in virtual fields of Query.
  • Fixed issue in the display of the "Quantity of records" option in the graphic interface.

New in ScriptCase 9.0.014 (Aug 7, 2017)

  • Fixed Fatal error: Uncaught Error: Call to undefined function nm_get_text_lang() when create or edit a connection in deployed project. ( Needs to update the production environment )

New in ScriptCase 9.0.013 (Aug 4, 2017)

  • New functionalities:
  • Added option to generate chart for windows in modal of export pdf. It will only be displayed if "Create Charts" is enabled at the .pdf export settings.
  • Specific correction:
  • Fixed issue when running "OnHeader" and "OnFooter" events in the chart application.
  • Fixed issue displaying events, in the Javascript on forms.
  • Fixed issue in digit limit for maximum value of decimal fields.
  • Fixed an issue when using a global variable with name that starts with underscores, eg: [_var]
  • Fixed issue in spin input when typing more than one character in field settings at ReportPDF.
  • Fixed issue causing the interface to rename applications in 1366 x 768 resolution.
  • Fixed issue displaying To-Do list buttons when "Who can change" is empty.
  • Fixed issue when updating the "Image (filename)" field while set as mandatory.
  • Fixed issue displaying the image manager menu in 1366 x 768 resolution.
  • Fixed issue that duplicates fields used in AJAX processing.
  • Fixed issue when running ReportPDF when SQL is modified.
  • Fixed problem when using the sc_ajax_message macro. (Its necessary to clear the browser cache)
  • Fixed issue to update records when select field is disabled.
  • Performance improvement:
  • Improved performance on Mac Installer. (It will be necessary to reinstall the environment)
  • Improved interface performance and scripts generation.
  • Bug:
  • Fixed Parse error: syntax error, unexpected 'public' (T_PUBLIC) at form applications when using lookup in the fields.
  • Fixed issue when describing the fields group by in the summary using lookup settings.
  • Fixed issue in the date field display using the advanced filter when its set in the dimension.
  • Fixed issue in the static group by grouping in the query.

New in ScriptCase 9.0.005 (Jul 22, 2017)

  • New functionalities:
  • Added support for chart application in helpcase.
  • Specific correction:
  • Fixed problem in setting horizontal alignment for summary dimensions.
  • Fixed problem when using field automatic lookup with SQL using schema (PostgreSQL).
  • Fixed problem using uppercase letters in dataset of sc_select macro.
  • Bug:
  • Fixed problem using label field as primary key.
  • Fixed problem when clicking image of the Image Manager.
  • Fixed problem in displaying the menu icons in the advanced themes editor.
  • Fixed problem in chart application interface and dimensions.
  • Fixed problem in form creation interface.
  • Fixed problem in generating subtotal charts when displaying on the same summary page.
  • Fixed problem in content of HTML editor in form on insert mode.
  • Fixed problem in the path of images on the same server when using HTML Editor.
  • Fixed problem on date/time field interface in grid filter.
  • Fixed image layout of the connections when accessing the Database Builder.
  • Fixed problem in scrolling tabs when opening multiple applications.
  • Fixed problem in the button layout of the Save Grid option.
  • Fixed problem in the layout of the Database Builder interface.
  • Fixed problem in the grid configuration interface.

New in ScriptCase 9.0.005 (May 26, 2017)

  • Specific correction:
  • Fixed problem when using buttons group in the Grid detail.
  • Fixed problem with capture links in the Control applications.
  • Fixed problem in the Charts PDF generation.
  • Fixed problem with fields display in the Grid detail. The fields were exicciding the Grid bottom toolbar.
  • Fixed problem in link naming in exporting applications.
  • Correction of the sending of langs feedback in the application language interface.
  • Bug:
  • Fixed problem using log module with different connections in the application.
  • Fixed sorting problem in the Grid Group by.
  • Fixed bug in the insertion of html "doctype, html, head, body" in the html editor field.
  • Fixed SQL error in including files and images in the multiupload field.
  • Fixed problem in Grid sql when using ORDER BY clause with Postgres connections.
  • Fixed problem when clicking to edit project theme.

New in ScriptCase 9.0.004 (May 21, 2017)

  • Specific correction:
  • Fixed duplicate label problem when using "Title on the same line" in the Nested Grids
  • Fixed error when running the Grids without items on the toolbar.
  • Fixed duplicate label problem when using other selected fields on the Group by line.
  • Fixed issue when using global variable in the Grid label.
  • Bug:
  • Fixed error supplied for foreach () when generating application created by the Log Module.
  • Fixed problem in totals list in numeric fields of the dashboard indexes using Access ODBC connection.
  • Fixed accessing problem when using option "Use database session" on the values of ScriptCase system.
  • Fixed issue in decimal values in virtual fields in the summary totals.
  • Fixed display problem on the background image in the Layout of the PDF Report.
  • Fixed problem of disabled button after import project.
  • Fixed issue in view of the amount of records on the toolbar using dynamic breaking
  • Fixed issue in fields types recovery using SQL with JOIN in SQL Server (Native Server)
  • Fixed problem in the displayed values in the summary search using WHERE in the SQL query.
  • Fixed problem in sorting date fields in dimensions with drilldown in chart application.
  • Fixed CHARSET problem in PDF export the grid application using the Arabic language with WINDOWS-1256.
  • Fixed issue in value display using the macro sc_date_dif_2
  • Fixed problem in check of the record criticized by the validation of field required in the multiple records forms.

New in ScriptCase 9.0.003 (May 12, 2017)

  • New functionality:
  • Improvements in the security module. From this version, when a new user is added using the "new user" application available within the login, the new user will be added to the group "default" available in the security module group type settings. The user will also become active automatically. However, if the option to "require activation by email" is selected during the security module creation, the user will not be active automatically.
  • Added the syntax N '' for the conversion of the string types Nchar, Nvarchar and Ntext.
  • Added option to display the amount of records in the summary's search.
  • Changed the "clear" button placement within the summary's search.
  • Specific correction:
  • Added validation on the backup/restore of files from version 8.
  • Fixed error of "Invalid argument supplied for foreach" devel/lib/php/database.inc.php 827 in the Grid lookups on Postgres connections.
  • Fixed issue when using SQL syntax index with MS Access connections.
  • FreeTDS path protection on shared servers.
  • Fixed problem in listing the total values of calculated field "percentage" on the Group by metrics.?
  • Fixed problem in totals list for numeric fields of the indexes in the dashboard using Access ODBC connection.
  • Bug:
  • Fixed error in deleting the master detail in connections with Firebird. (Bug from PHP 7.0).

New in ScriptCase 9.0.002 (May 5, 2017)

  • Fixed problem of SQL syntax when using more than one index with different connections inside the dashboard application.
  • Fixed issue in app_container.js file path in the application dashboard.
  • Fixed problem the dashboard widgets toolbar option within the chart application.
  • Fixed problem of encrypted files in the production environment.

New in ScriptCase 9.0.000 (May 3, 2017)

  • New SQL aggregate functions to chart metrics: Count, Distinct count, variance and standard deviation;
  • New dimension options for date fields, such as: Semester, Quarter, Trimester, Semester and others;
  • Individualization of metric and dimension fields so that they can be configured independently;
  • Reorganization of the chart creation interface with the option to drag the same field to chart dimension area (same field with different date period) or metric area (with different SQL aggregate functions);
  • Analytic (multiple series) and synthetic (single series) combination of different dimensions on the same chart, and it can be customized also by the end user at run time;
  • New type of Search (User search) so that the end user can dynamically filter dimension and metric fields within the chart. Different display options for the values according to the data type;
  • New LIMIT function that can be used to rank the values within the charts. For example: chart with the 10 best customers, 10 cities that have sold less in 2016, etc;
  • New interface for chart themes full customization. Chart themes can now can be configured to project level or individually within the application;
  • New chart themes already included within Scriptcase: pastel (based on google charts), flat (based on bootstrap charts), modern and dark;
  • New chart types available: Scatter, bubble, Semicircular and Linear Gauge, 2D Funnel and 2D Pyramid;
  • Option to add and customize the subtitles for the charts;
  • New customization options specifically to bar, column, pie and Gauge;
  • Possibility to export the charts to PNG, JPG, PDF, SVG and XLS.
  • New interface with drag and drop for setting up widgets dynamically. The widgets can now have different sizes and positions within the desktop;
  • Responsive widgets;
  • New index widget with field-specific settings and aggregate functions for presentation of KPIs (key performance indicators) within the dashboard;
  • New widgets configuration and customization options. For example: hide toolbar items from linked application within the widget, layout formatting, filter, values abbreviation, etc;
  • Integration of applications within the same Dashboard, e.g. Master detail between different queries;
  • Dashboard update without recharging the page;
  • New interface for the Grid creation with the option of selecting multiple tables and fields directly in the creation interface;
  • New interface using drag and drop for defining the grid and summary group by, with new configuration options for the summary with individual field settings;
  • New aggregate functions to chart metrics: count, distinct count, variance and standard deviation;
  • Possibility of dragging the same dimension (for different date period fields) or metric (with different SQL aggregate functions) more than once into the group by and summaries;
  • New type of Search (User search) so that the end user can dynamically filter dimension and metric fields within the summary. Different display options for the values according to the data type;
  • New LIMIT function that can be used to rank the values within the grid or summary. For example: summary with the 10 best customers, 10 cities that have sold less in 2016, etc;
  • New configuration options within the summary aggregation: display the count of rows in the summary, hover showing column values and display the value in the subtotal line;
  • New sorting settings for the summary fields;
  • New option to abbreviate the values to display in the summary.
  • New option within the Control application that will allow the integration of Scriptcase forms with customized HTML and CSS or importer from external libraries. This option gives total freedom for forms layout customization;
  • Body handling variables from HTML, visual can now be changed completely and adapted to the form with the proper Scriptcase markups;
  • Support to events, libraries, macros, images, and Scriptcase field types;
  • New templates provided by Scriptcase for login screens and contact forms;
  • Possibility of integration between the layouts created by the control application with the security module login screen.
  • New option of drawing with drag n drop and dynamic configuration of the fields within the same interface in Report Pdf applications.
  • New option "menu structure" for layout customization with the option to use external libraries, methods and dynamic variables;
  • Option to expand/collapse the menu to hide the items and expand the desktop within the application generated.
  • New themes for the generated applications (sc_rinno);
  • New CSS options for advanced themes customization (Application Layout).
  • PHP 7.0 Support;
  • PDO drivers update (SQL Server, MySQL);
  • Addition of the PDO Dlib drive for SQL Server;
  • Addition of the new MySQLi drive for MySQL connections;
  • SSL for secure connections with MySQL;
  • New Apache version 2.4.25;
  • 32 and 64-bit architecture for windows installers;
  • WKHTMLtoPDF library update;
  • Fusion Chart library update;
  • Automatic converters to projects developed in versions 7 and 8/8.1, i.e. projects of these version will be compatible with version 9;
  • Production environment for generated applications approved for PHP 5.6 and 7.
  • Social login option with Google, Facebook and Twitter generate automatically by Scriptcase security module;
  • New encryption options for login application password field (MD5, SHA1, SHA256, SHA512);
  • Security module integration with the new option of free-form control with templates responsive to login screen;
  • Component update for automatic generation of captcha function to the login screen generated by Scriptcase security module;
  • Option to assign more than one group for users created by Scriptcase security module;
  • Creation of a new "default group" in the security module group table (in that group will be added new users that enter through the new user form generated by the module or by social login option);
  • New option of integration with LDAP and groups creating on the Scriptcase users administration environment (development environment).
  • ER Diagram - New feature to improve the database management options, in addition to the SQL Builder and DATABASE Manager, was implemented support for creating ER Diagram for databases connected to Scriptcase;
  • Project Diagram - New tool for generation of the Project Diagram. With advanced viewing and printing options;
  • New Layout for Scriptcase documentation, more clean and intuitive for you to access the features of the development environment faster and easy.

New in ScriptCase 8.01.0066 (Mar 17, 2017)

  • New functionalities:
  • Increased the amount of characters in the "text between values" field, in the date type field settings' interface from Search.
  • Added langs support to the field "text between values" in the date type field settings' interface from Search
  • Specific correction:
  • Fixed issue in sc_connection_new macro. The dynamically connection created was not being assigned to the application.
  • Fixed issue when synchronizing the form containing the same name as an existing virtual field in the application.
  • Bug:
  • Fixed error in the button link type, when the value passed as parameter had a special character.

New in ScriptCase 8.01.0065 (Mar 17, 2017)

  • Specific correction:
  • Fixed issue in the fields help pages charset.

New in ScriptCase 8.01.0064 (Feb 8, 2017)

  • Specific correction:
  • Fixed issue when using the option "Allow empty value" within the autocomplete fields from Editable Grid Form.
  • Fixed validation problem with time fields type when using the Timepicker option set as required.

New in ScriptCase 8.01.0063 (Jan 27, 2017)

  • Bug:
  • Fixed error in the Grid SQL when using a "DATETIME"field type containing some code in the onvalidate event.
  • New functionalities:
  • Added macro sc_select_field support for summary fields. The macro must be used in the OnScriptInit event.
  • Specific correction:
  • Fixed issue in SPIN field with negative values. It was returning with the value zero when the field was being loaded in the application.
  • Fixed issue in the initial field focus, when the application was open in modal. Error happened only in the Firefox browser.
  • Fixed issue when using Infinite Scroll pagination within Slide orientation Grid.
  • Fixed issue when changing client_encoding from production environment connection.

New in ScriptCase 8.01.0062 (Jan 27, 2017)

  • Specific correction:
  • Fixed error Undefined offset: 1 adodb-postgres64.inc.php line: 571 in Postgres connections, when it was not using schema before the table.
  • Fixed problem in the tree menu sub levels. There was a problem when the parent level had no link, the sub level link was being opened if when the parent item was clicked.

New in ScriptCase 8.01.0061 (Jan 11, 2017)

  • Performance improvement:
  • Performance improvement in the recovery of tables and fields.

New in ScriptCase 8.01.0060 (Jan 11, 2017)

  • Specific correction:
  • Fixed Fatal error in function GetTag () when changing field type of applications.

New in ScriptCase 8.01.0059 (Jan 11, 2017)

  • New functionalities:
  • Added on URL field settings the options for maximum size and minimum size.
  • Specific correction:
  • Fixed problem when entering values in fields NULL with Oracle connection.
  • Fixed issue when using double quotes with Grid global variables.
  • Fixed issue in upload field validation, to configure the maximum size of the file.
  • Performance improvement:
  • Fixed problem of slowness when accessing the fields interface, if a database had more than 1000 tables.
  • Bugs:
  • Fixed Fatal error function setTime () in Excel import via database converter.
  • Fixed issue ​with ​​Grid SQL values display​ after changing the​ ​ fields​ definition using the same ALIAS.

New in ScriptCase 8.01.0058 (Dec 28, 2016)

  • Specific correction:
  • Fixed problem when pressing the enter key in the QuickSearch field, in case you were using a JavaScript burron type as image. The button's code was being executed.
  • Fixed problem when displaying the "detail" button, when using Alias in the Grid SQL.
  • Fixed problem creating automatic dependencies on Form Applications.
  • Fixed problem of line break in text fields with multiple rows from Grid Editable and Editable Grid View Form types.
  • Performance improvement:
  • Performance Improvement with dependencies recovering from PostgreSQL and MS SQL Server connections.

New in ScriptCase 8.01.0057 (Dec 28, 2016)

  • Specific correction:
  • Fixed issue in the sc_redir macro on Chrome and Safari browsers when using the parameter "_blank".
  • Fixed issue with filter special conditions, when using date and time fields as a string.

New in ScriptCase 8.01.0056 (Dec 19, 2016)

  • New functionalities:
  • Added Timeout option for the Blank application.
  • Added support for "ico" images in the image manager.
  • Specific correction:
  • Fixed layout issue within the Tree Menu.
  • Fixed issues with the Appointment Sample (It will be necessary to import the project again).

New in ScriptCase 8.01.0055 (Dec 14, 2016)

  • Specific correction:
  • Fixed problem when updating field type CLOB with empty value.
  • Fixed Fatal error: Call to undefined function perfil_lib () in the Menu application, if the session was closed and the menu item was clicked.
  • Fixed generation of source code in the Tree Menu Onload event. The codes were being included before the HTML.
  • Fixed problem when updating or navigating through the records using the field number auto complete. Rather than display the description, it was was displaying the code.
  • Performance improvement:
  • Added support for reading virtual fields inside the events, passed as variables from the filter to the summary.
  • Bug:
  • Fixed issue with macro "sc_field_style" on Grids with Slide and Vertical orientation. The colors were not being assigned to the cells.
  • Fixed problem in navigation of the records by using the Grid with free format orientation.

New in ScriptCase 8.01.0022 (Jan 18, 2016)

  • Specific correction:
  • Fixed Invalid Data problem using grid application with HTML Image field to tab application with normal organization.

New in ScriptCase 8.01.0021 (Jan 18, 2016)

  • Specific correction:
  • Fixed problem in the advanced search filter after accessing the Grid's summary or detail.
  • Fixed problem when synchronizing deployed security module applications.
  • Fixed problem in the weighted average display in the summary.
  • Fixed problem on the primary key columns display after navigating in the horizontal form.
  • Bug:
  • Fixed problem when auto-synchronize the From Application when using the Spanish installer.
  • Fixed problem when creating applications from tables named with special characters using SQL Server and PostgreSQL database.
  • Fixed problem when creating applications from tables named with numbers using SQL Server database.

New in ScriptCase 8.01.0020 (Dec 29, 2015)

  • New functionalities:
  • Adding new language Shuar (Ecuador).
  • Specific correction:
  • Fixed issue in the CSV file conversion during import.
  • Fixed problem when using field names starting with number in the Access database.
  • Fixed issue when creating query-based application View without using aliases.
  • Fixed issue when using table names and fields with special characters in Access database
  • Fixed problem when viewing WORD files exported from the grid application.
  • Performance improvement:
  • Added Oracle and Firebird extensions in the MAC installer
  • Added extensions DB2, Informix, Sybase, Interbase / Firebird, ODBC and Oracle in the Linux installer.
  • Bug:
  • Fixed issue in the fields connections in the Nested Grid

New in ScriptCase 8.01.0019 (Dec 18, 2015)

  • New functionalities:
  • Added support to search the buttons code, in the "Search Application" functionality.
  • Specific correction:
  • Fixed problem in the style settings exhibited in the Nested Grid.
  • Fixed the "file nonexistent" problem by downloading files, after inserting records in horizontal forms.
  • Bug:
  • Fixed problem when changing the field's style settings in Grid applications that are being generated as a link.
  • Fixed the CHARSET problem when displaying values in Charts configured as analytic using SQL Server connection.
  • Fixed the Grid's detail problem in the horizontal alignment style settings.
  • Fixed problem ordering the friendly URL exhibited in the inicial project screen.
  • Fixed problem in ZipArchive function, displayed during automatic update in Linux environments.

New in ScriptCase 8.01.0018 (Dec 10, 2015)

  • New functionalities:
  • Added support for hint and title customization for "New" button for links from Grid applications.
  • Added a new property to open forms in tabs, when linked to menu and set as open in tabs "yes" within Grid applications.
  • Specific correction:
  • Fixed problem when displaying applications within tabs, using French language.
  • Fixed issue with images resizing from upload fields.
  • Fixed issue on custom width behavior from Tab applications, in browsers Mozilla Firefox and Microsoft Edge.
  • Bug:
  • Fixed problem on inserting and updating records with NULL value in CIDR and INET fields in PostgreSQL.
  • Fixed issue when using colors for fields customization in Grids with slide orientation when using label above or below in the block configuration.
  • Fixed problem when synchronize users in the security module by using LDAP.
  • Fixed issue with Ajax events in fields time datatype.
  • Fixed issue with datatime fields within buttons PHP display.

New in ScriptCase 8.01.0017 (Dec 10, 2015)

  • New functionalities:
  • Added support for the English language, in the macros used on database variables.
  • Specific correction:
  • Fixed problem after changing default values of a project.
  • Fixed problem in image upload when named with multi-byte characters, spaces and symbols.
  • Fixed problem displaying unserialize error when to access a project.

New in ScriptCase 8.01.0016 (Nov 18, 2015)

  • New functionalities:
  • Added option to list all macros alongside the events that the macro runs.
  • Specific correction:
  • Fixed problem in the file directory when deploying projects via SFTP.
  • Fixed problem when generating applications, using external libraries with renamed files.
  • Fixed problem in the button display in report applications used as detail.
  • Fixed duplicate problem after accessing grid application starting with filter in iframes.
  • Fixed the problem in functionality to hide the sidebar using tabs in the tree menu application.
  • Fixed problem when closing menu tabs when using only images.
  • Fixed problem when creating scrolling to access the code editor in internal libraries.
  • Fixed problem interpreting Javascript arrays as global variables.
  • Fixed problem when using Ajax processing checkbox field with manual lookup.
  • Bug:
  • Fixed problem in the XLS conversion when importing spreadsheets using PRIMARY KEY, AI and NOT NULL options.
  • Fixed validation problem when deploy projects via SFTP.
  • Fixed problem when creating folders with the names of already existing folders in the project application area.
  • Fixed problem ordering of values ​​in date type of fields, written in capital letters.
  • Fixed problem when importing sample projects using MySQL with PDO connection.
  • Fixed problem accessing the filter using UNIQUEIDENTIFIER column as PRIMARY KEY.
  • Fixed problem displaying the number of lines in horizontal forms.
  • Fixed line display problem with color in the preview of menu items.
  • Fixed display problem after clearing all filter conditions using the Safari browser.
  • Fixed problem in the width of the side menu in menu applications with horizontal alignment set as "right".
  • Fixed problem in the interface to access the onValidadeSuccess event using Microsoft Edge browser.
  • Fixed problem in the preview display of templates in HTML Editor, to remove a row.
  • Fixed problem when creating buttons labeled with quotes.

New in ScriptCase 8.01.0015 (Nov 4, 2015)

  • New functionalities:
  • Improved interface for Oracle connections highlighting the creation of user's filters.
  • Added field for sequential display on editing fields' options for Oracle connection.
  • Added field for sequential display on editing fields' options for Firebird connection.
  • Specific correction:
  • Fixed display problem with external library buttons when accessed from different screen resolutions.
  • Fixed problem in creating connections named with special characters.
  • Fixed problem in recovering fields named in a lower case using Oracle connection.
  • Fixed problem in records displays with the Croatian language within PDFReport app.
  • Bug:
  • Fixed problems when creating folders named with numbers within the project applications area.
  • Fixed display problem when creating applications using Safari browser.

New in ScriptCase 8.01.0014 (Nov 4, 2015)

  • Specific correction:
  • Fixed problem in running horizontal forms using global variable defined in the original field value.

New in ScriptCase 8.01.0013 (Nov 4, 2015)

  • Specific correction:
  • Fixed display problem on the button label using lang in form and control applications.

New in ScriptCase 8.01.0012 (Nov 4, 2015)

  • Specific correction:
  • Fixed problem in running forms using global variable defined in the original field value.

New in ScriptCase 8.01.0011 (Oct 23, 2015)

  • New functionalities:
  • Added support to allow the use of global variables in the "path of the PDF file" via Server, in the Report PDF applications.
  • Added new option to keep the last status when accessing the tree-menu application.
  • Added support to recovery of UNIQUE KEYs when creating form applications with Firebird connection.
  • Added support to recovery of FOREIGN KEYs when creating form applications with Firebird connection.
  • Added support to recovery of COMPOSITE KEYs when creating form applications with Firebird connection.
  • Added support to recovery of UNIQUE KEYs when creating form applications Oracle connection.
  • Added support to recovery of FOREIGN KEYs when creating form applications with Oracle connection.
  • Added support to the recovery the DEFAULT values when creating form applications with Oracle connection.
  • Specific correction:
  • Fixed problem when doing a search using the "Quick Search" Form applications that have autocomplete fields.
  • Fixed problem in the interpretation of HTML fields in "Image HTML" type of field in Grid applications.
  • Fixed problem in "Google Maps" type of field when viewing into an "Editable Grid View" Form applications.
  • Fixed problem of server access after upgrading the Mac OS operating system to version El Capitan.
  • Fixed issue with the menu's toolbar buttons when calling the linked applications.
  • Bug:
  • Fixed problem in the exhibion of the side menu, after adding a picture in the HelpCase file.
  • Fixed problem when doing a search using the "Quick Search" of the Grid applications using a specific connection.
  • Fixed problem when using the "sc_block_display" macro on a Form loaded from Grid application link.
  • Fixed problem in viewing records that have HTML content, after navigating from an Editable Grid Form application.
  • Fixed problem when using a "manual increment" feature in text type fields in the Form application.
  • Fixed problem in subqueries viewing from Grids with the slide or vertical orientation.
  • Fixed problem updating and deleting records in double select fields in forms using CHARSET WINDOWS-1250.
  • Fixed problem on the record navigation in checkbox fields in forms using CHARSET WINDOWS-1250.
  • Fixed problem displaying records in autocomplete fields in forms using CHARSET WINDOWS-1250.

New in ScriptCase 8.01.0010 (Oct 15, 2015)

  • Specific correction:
  • Fixed problem color palette when used the Google Chrome browser, in the CSS field settings.
  • Fixed problem in horizontal alignment settings of the fields in the grid application.

New in ScriptCase 8.01.0009 (Oct 14, 2015)

  • New functionalities:
  • Added new sorting routine for the chart application allowing sorting by size and charts with more than one metric.
  • Added support for sub charts in combination types of chart.
  • Added responsiveness support in the chart application.
  • Added support to Simplified Chinese GB18030 and GB2312 CHARSET.
  • Added support to Greek WINDOWS-1253 CHARSET.
  • Added support to Turkish WINDOWS-1254 CHARSET.
  • Added support to Hebrew WINDOWS-1255 CHARSET.
  • Added support to Arab WINDOWS-1256 CHARSET.
  • Added support to Baltic WINDOWS-1257 CHARSET.
  • Specific correction:
  • Fixed problem when coping records in the horizontal forms with BIG5 CHARSET.
  • Fixed problem in the "New" button behavior in horizontal forms using the Turkish language.
  • Fixed problem in the HTML editor on Linux environments.
  • Fixed problem accessing a data dictionary that has a deleted connection.
  • Fixed support problem in the HTML Editor languages.
  • Fixed problem when using global variables named with accents in different projects using UTF-8 CHARSET.
  • Fixed problem connecting to DB2 database in the production environment.
  • Fixed problem when updating records after changing files on document (File Name) fields.
  • Fixed problem displaying values ​​in the project schedule using the Ukrainian language.
  • Fixed problem after generating a HelpCase.
  • Fixed problem when updating values ​​in forms using ISO 8859-6 CHARSET.
  • Fixed problem displaying the schema of buttons in grid application with "User Defined" orientation.
  • Bug:
  • Fixed problem when inserting records with values ​​that have the plus sign (+) in horizontal forms.
  • Fixed problem in PDF export in the chart application.
  • Fixed problem in the TreeView behavior when using Quick Search in the Grid applications.
  • Fixed problem in application synchronization in the security module.
  • Fixed problem on "Case Settings" option in fields using CHARSET WIN-1250.
  • Fixed CHARSET problem when updating records in the form application with WIN-1250 CHARSET.
  • Fixed problem in the "Close" Button Description of the summary in the chart applications.
  • Fixed problem when creating button schemas with named previously created.
  • Fixed problem creating a sub Chart with more than one value in charts: 3D, combination, Pizza, Radar and funnel.
  • Fixed problem in the sub Charts with more then one value.
  • Fixed problem when clicking in the dynamic filter after conducting research through the Advanced Filter with modal.
  • Fixed problem in descending order DATA fields with different formats locale in the refined search.
  • Fixed problem when execute an exported application from version 8.1.006.
  • Fixed problem when trying to restore an application with the same name as an existing application.
  • Fixed problem when using "Keep Values" in the filter starting with frame.
  • Fixed problem when setting sizes in height and width in image fields, with the active increment option in Grid applications.
  • Fixed problem when using change the language in the application that has special fields as a PRIMARY KEY.
  • Fixed problem in the parameter passing between global variables when using a link button in the form.
  • Fixed problem when making download in Document fields (database) in the Grid application.
  • Fixed problem after removing all lines from the HTML editor template.
  • Fixed problem in inserting records using SQL Server with the ISO 8859-1 CHARSET.
  • Fixed problem with the expansion of the items in the tree menu after recharging it.
  • Fixed problem with the "Back" button in the tab application accessed from a link.
  • Fixed problem when trying to copy record with new HTML Editor in horizontal forms.
  • Fixed problem when creating application using SCHEMA other than the default in SQL Server connection.
  • Fixed problem of losing values ​​in disabled fields when using CHECKBOX field with the "Reload form" option.
  • Fixed support problem in HelpCase ​​Editor languages.
  • Fixed crash problem when saving the theme button.
  • Fixed problem in "Top Menu" option in the HTML Editor template.
  • Fixed problem when editing a record in a master/detail that use the modal option for editing.
  • Fixed problem color palette when used the Internet Explorer browser, in the CSS field settings.
  • Fixed problem when selecting multiple images in the "extra images" option in the application settings.
  • Fixed problem when generating applications with no connection defined.

New in ScriptCase 8.01.0008 (Sep 12, 2015)

  • Specific correction:
  • Fixed problem in MBSTRING module after deployment.
  • Fixed problem in CHARSET function when running applications.
  • Bug:
  • Fixed problem on the limitation of characters allowed in the insertion of new records, in forms grid editable.

New in ScriptCase 8.01.0007 (Sep 10, 2015)

  • New functionalities:
  • The HTML Editor component was updated with the newest version available.
  • Added a new area for profile settings using the HTML Editor options (Layout menu > HTML Editor).
  • Added new HTML Editor options to the application's settings.
  • Added new HTML Editor options to the project's default values.
  • Specific correction:
  • Fixed problem in image display next to the menu items.
  • Fixed problem in inserting records starting with backslash within multiple lines text field.
  • Fixed problem deleting images after clicking more than once to update.
  • Fixed problem with upload fields after records' navigate and update.
  • Fixed problem with the Search TEXT width.
  • Fixed problem when inserting files named using symbols and spaces.
  • Fixed problem with numeric fields alignment within editable grid (view) form type applications.
  • Fixed problem in the folder created by ScriptCase to save libraries within public profile.
  • Fixed problem with content blocks display using the macro "sc_display_block" within Firefox browser.
  • Fixed problem with themes display in the customization and metric Chart application areas.
  • Fixed problem in the option checked/unchecked all on Checkbox fields with AJAX.
  • Fixed problem in the Maximum File Size option in the settings of applications.
  • Fixed problem when using regular expression in the grid SQL.
  • Fixed problem in PDF export Master/Detail using sc_change_connection.
  • Fixed problem when creating HelpCase appointed with pound sign(#).
  • Fixed problem when generating common libraries after deployment advanced.
  • Fixed problem in black and white export in the chart application.
  • Fixed problem in the context menu of the tabs used in the menu application.
  • Bug:
  • Fixed problem displaying values in the grid application charts.
  • Fixed problem in the paging within Forms application with select fields with multiple values.
  • Fixed problem in the fields view when using the initial block set as open tab.
  • Fixed problem with the dates sorting in the Chart application.
  • Fixed problem for downloading files options through within the Internet Explorer.
  • Fixed problem in the file insert button into multi-upload fields within the Internet Explorer.
  • Fixed problem with the Tab alignment options under Tabs application.
  • Fixed problem with tree menu preview through advanced themes' settings.
  • Fixed problem when using horizontal menu themes within project and user profiles.
  • Fixed problem with the macro "sc_ajax_message" when displaying double select field values.
  • Fixed problem when using macro "sc_field_disabled" with N-N fields.
  • Fixed problem CSV exporting in the Grids with more than one Group By.
  • Fixed problem when deleting an empty folder within the project.
  • Fixed problem in the application's directory, after deleting applications with friendly URL.
  • Fixed problem with the data visualization within Summaries using virtual fields.
  • Fixed problem within the "OnExecute" event in the Tree Menu when calling different projects' applications.
  • Fixed problem with the Administration tab when accessing other segments of the same screen.
  • Fixed problem with values conversion ​​into auto-complete fields.
  • Fixed problem in the vertical alignments description on project default values options.
  • Fixed problem when using applications starting with numbers in the details.
  • Fixed problem with cut images in the old HelpCase header.
  • Fixed spacing problem on the margin of HTML Editor.
  • Fixed problem after upload files started with accents and symbols in the Linux environment.
  • Fixed problem when using macro sc_field_disabled HTML Editor field.
  • Fixed problem in insert forms that have fields with default values ​​set in the database.
  • Fixed problem on the option to view HTML code in HTML Editor field through Internet Explorer.
  • Fixed problem in title during the restore procedure in ScriptCase.
  • Fixed problem when updating records with disabled SELECT fields.
  • Fixed problem after selecting values in auto complete fields.

New in ScriptCase 8.01.0006 (Sep 10, 2015)

  • Specific correction:
  • Fixed problem in inserting records using fields calculated by the database.
  • Fixed problem in inserting records that have upload fields without informing the file.

New in ScriptCase 8.01.0005 (Aug 20, 2015)

  • New functionalities:
  • Added a new option to insert titles on Chart application
  • Added option to increment the file name for existing files with the same name for fields Document (File Name) and Image (File Name) datatypes. (Need to update production environment!)
  • Added support the extension .ico images within the Image Manager
  • Added support InsertFile HTML editor when you have Moxie manager
  • Specific correction:
  • Fixed problem when using a Grid with Refined Search and application link to open in menu's iframe
  • Bug:
  • Fixed issue on Grid app when opening application as Chart using additional summarization fields
  • Fixed problem when renaming files or directories in the Libraries
  • Fixed issue on Advanced Search within the Grid application when starting by iframe
  • Fixed issue with initial sorting for date fields in the Chart app
  • Fixed issue in the Refined Search quantity exhibition when using a GROUP BY for the Grid SQL
  • Fixed problem with the header's filter condition display for date type fields
  • Fixed issue when synchronizing security module applications
  • Fixed issue when using checkbox field with the search condition "does not contain".
  • Fixed settings problem with values display and label positioning for Grid application's Charts
  • Fixed issue within blocks editing features
  • Fixed problem with special characters for select fields in the editable grid forms insert mode
  • Fixed problem with CSV files importing
  • Fixed issue on records sum using totals in a variable within the Grid application
  • Fixed issue with footer's field within the "User Defined" Grid orientation.
  • Fixed problem for underlined or scratched texts within text field type
  • Fixed issue on field's mask with lookup
  • Fixed problem with buttons grouping on the Search toolbar options
  • Fixed issue when using a JavaScript button with modal or new page targets
  • Fixed issue when using blocks set as starting closed for Grid app with slide orientation
  • Fixed issue in the Grid's chart display with the display options set as "Display on the same page" and "Display before the Summary" as yes
  • Fixed issue when using parentheses in the macro sc_alert
  • Fixed issue when using single quotes in the macro sc_exec_sql

New in ScriptCase 8.01.0004 (Jul 31, 2015)

  • Specific correction:
  • Fixed issue on the icons' directory display "scriptcase/icons/" in the image manager tool.
  • Fixed the problem with the zended files in the deployment.

New in ScriptCase 8.01.0003 (Jul 29, 2015)

  • Specific correction:
  • Fixed incompatibility issue with the Scriptcase encrypted files.

New in ScriptCase 8.01.0002 (Jul 27, 2015)

  • New functionalities:
  • Added support for dynamic search in the chart application.
  • Specific correction:
  • Fixed CHARSET problem in chart application.
  • Fixed problem in the dynamic tree menu with tab, opening in new tab browser.
  • Fixed letter-spacing problem in the label of horizontal forms. (You need to clear your browser cache.)
  • Bug:
  • Fixed problem with summary in the chart application.
  • Fixed problem in the menu application with Samples project.
  • Fixed problem in the validation of access to security module without maintaining logged in users.
  • Fixed problem to icon display in the menu toolbar with tabs.
  • Fixed problem to sub item display in the menu toolbar with tabs.
  • Fixed problem in the grid detail using image (Database) fields opening to the side or below.
  • Fixed problem while downloading files to perform automatic update.
  • Fixed incompatibility problem with the PHP version after update.

New in ScriptCase 8.01.0001 (Jul 27, 2015)

  • Specific correction:
  • Fixed problem in the form application update using CHARSET UTF-8.
  • Fixed problem in deploying a menu using a toolbar with tabs.
  • Fixed problem in display of the toolbar tab in the menu application.
  • Bug:
  • Fixed problem when importing the Samples project with MySQL database.

New in ScriptCase 8.01.0000 (Jul 27, 2015)

  • New functionalities:
  • Added new chart generator with support for multiple values ​​and reports.
  • Added new refined filter restricting values ​​according to the existing universe in the database.
  • Added new macro sc_webservice supporting soap services, curl, file_get_contents and sockets.
  • Added new navigation exhibition path in the application menu.
  • Added new library manager tool.
  • Added support the sc_url_library() macros and sc_include_library().
  • Added new HelpCase generator.
  • Added new total option for weighted mean.
  • Added new data type that enables accumulated field creation available for totals and summary.
  • Added new ajax button type (it allows you to create Ajax callback function).
  • Added new interface to control logged users and Brute Force Protection
  • Added new parameters in theme editor for Refined Filter.
  • Added new parameters in theme editor for Tabs Menu.
  • Added new parameters in theme editor to Menu Breadcrumb.
  • Added new group of buttons for the new charts toolbar buttons in the editor.
  • Specific correction:
  • Fixed image problem when performing the backup and export projects.
  • (You will need to update the ScriptCase for that correction to take effect.)
  • Performance improvement
  • Performance improvement using the PHP 5.6 environment.
  • Performance improvement in backup and restore generator.
  • Bug:
  • Fixed the problem in the allowed characters configuration in converted form applications.
  • Fixed the problem in text display configured in the nested grid application.
  • Fixed the problem in the parameter passing in tab applications.
  • Fixed the problem in the axis X positioning in the Report PDF application when using the option to "Show Contents".
  • Fixed the problem in the auto-complete field from the capture type of link.
  • Fixed the problem displaying negative values ​​in the Report PDF.
  • Fixed problem in CSS style used in buttons editor.

New in ScriptCase 8.00.0047 (May 23, 2015)

  • Specific correction:
  • Fixed problem when using global variable in event Ajax on the form.

New in ScriptCase 8.00.0046 (May 22, 2015)

  • New functionalities:
  • Added support for renaming applications that have link with sc_redir, sc_link macros and buttons with links.
  • Specific correction:
  • Fixed problem with Ajax event when editing with modal in the editable grid (view) form type.
  • Fixed an interface problem when deleting a Static Group By.
  • Fixed problem when using Ajax processing and the disable option in the field type SELECT.
  • Fixed problem in the PDF files generation using SSL environment.
  • Bug:
  • Fixed problem when using double select fields in the advanced search option with DB2 connection.
  • Fixed problem with string recognition when creating applications with Firebird connection.
  • Fixed problem when using ajax processing to a SELECT field with RADIO field type using manual lookup.
  • Fixed problem when using onChange event in the double select field type.
  • Fixed problem with the ReportPDF background image after conversion.
  • Fixed problem with limiting characters allowed in text field type adding accented characters.

New in ScriptCase 8.00.0045 (May 15, 2015)

  • New functionalities:
  • Added treatment to reserved words in Sybase database.
  • Specific correction:
  • Fixed horizontal alignment problem in the menu when using RTL languages.
  • Fixed problem when searching values of virtual fields in the Quick Search.
  • Fixed problem in the SELECT type of field when using the advanced search in the DB2 database.
  • Fixed problem in viewing records limiting the amount of auto complete fields.
  • Bug:
  • Fixed problem connecting to the Sybase database.
  • Fixed the display problem in the menu's toolbar.
  • Fixed the display problem when the saving the PHP method with no parameters.
  • Fixed problem in the blank's image directory.
  • Fixed problem in the lookup from the double select when used in the search.
  • Fixed problem in the log module creation with Sybase connection.

New in ScriptCase 8.00.0044 (May 8, 2015)

  • New functionalities:
  • Added PHPExcel - Need to update production environment! (For users that use the separate production environment for the publications, you need to update it. For the rest, just leave marked the "Update production environment" during automatic update ScriptCase.)
  • Added new project theme.
  • Added support for border radius in content of project themes.
  • Specific correction:
  • Fixed problem in generating XLSX files in the Grid application.
  • Fixed problem in the project version history view.
  • Bug:
  • Fixed problem in the conversion of Access databases using ADO connection.
  • Fixed problem in the lookup preview at charts.
  • Fixed problem in the conversion of Access databases to SQL Server.
  • Fixed problem in the application navigation when it has a multiple line field.
  • Fixed the CHARSET problem when using macro sc_exec_sql with specific connection.
  • Fixed problem in the changes validation in the Report PDF events.
  • Fixed problem when importing files named with special characters in document fields (File Name) in the form editable grid with Oracle.

New in ScriptCase 8.00.0043 (Apr 30, 2015)

  • Specific correction:
  • Fixed problem in sub-select field alignment of PDF Report.
  • Fixed problem in form applications using composite key in PostgreSQL.
  • Fixed problem in the display of dynamic filter on tabs and HTML editor fields.
  • Fixed problem when searching for accented fields disabling case-sensitive in Quick Search using UTF-8.

New in ScriptCase 8.00.0042 (Apr 28, 2015)

  • New functionalities:
  • Added image support at Excel exportation.
  • Specific correction:
  • Fixed issue in the positioning of background images in PDF Report with RTL languages ​​(right-to-left).
  • Fixed problem in "Clean" button behavior of the filter when used in special conditions.
  • Fixed issue in the search engine of the filter application, when you have more than one table.
  • Bug:
  • Fixed issue in the behavior of the macro sc_alert during navigation in the Grid application.
  • Fixed connection problem in the Log Module when application has different connection from the module one.
  • Fixed tabulation problem in the Grid application when it has only one field as Group By.
  • Fixed issue in the view content in the Grid applications when it start by the summary and it has a nested Grid enable.
  • Fixed issue in the menu application when there is a validation on the menu items.
  • Fixed problem accessing side menu settings in the PDF Report application.
  • Fixed problem when using the macro sc_error_message in master / detail application.
  • Fixed issue in display the main menu at lower resolutions.

New in ScriptCase 8.00.0041 (Apr 17, 2015)

  • New functionalities:
  • Added new themes and buttons layouts.
  • Specific correction:
  • Fixed problem in display of HTML content in grid application fields.
  • Bug:
  • Fixed problem in group by interface with DATETIME fields, when changing the SQL of application.
  • Fixed problem in Scriptcase interface, when loading the fields settings.
  • Fixed problem in initial positioning of PDF Report's fields.
  • Fixed problem in field conditions interface in form application.
  • Fixed apostrophe's problem in French language, when using LATIN1 CHARSET.

New in ScriptCase 8.00.0040 (Apr 17, 2015)

  • Specific correction:
  • Fixed problem deleting records using dependence with more than one field.
  • Fixed problem when we search words with double quote in the Quick Search.
  • Performance improvement:
  • Improved the project creation interface.
  • Bug:
  • Fixed problem using the macro sc_pdf_print_img reshaping the image of the cell.
  • Fixed problem when changing the label of a field for the value of a lang.
  • Fixed problem in the radio field behavior with manual lookup in form multiple records.

New in ScriptCase 8.00.0039 (Apr 3, 2015)

  • New functionalities:
  • Implemented option to detect the language automatically according with the with the language selected on the Scriptcase's login screen to be used on the project creation language and regional settings.

New in ScriptCase 8.00.0038 (Apr 1, 2015)

  • Specific correction:
  • Fixed problem on the Subselect field aligning in the Report PDF Application.
  • Fixed the validation on radio and select type of fields at interface to select manual lookup.

New in ScriptCase 8.00.0037 (Mar 31, 2015)

  • New functionalities:
  • The buttons from the project creation were improved.
  • Specific correction:
  • Fixed problem when using the option to completing with zero in decimal fields.
  • Fixed issue in the buttons behavior after using auto-complete fields with capture.
  • Fixed problem when using the function "TABLE (TestFunc([VAR])) AS A" in the DB2 database.
  • Fixed issue in the navigation behavior after a search on the "Quick Search" in multiple records Form.
  • Fixed issue in the "Show HTML" content of sub select fields in PDF Report.
  • Bug:
  • Fixed issue when generating applications that have a selection type of fields with a empty lookup.
  • Fixed issue when viewing the color palette in the Google Chrome browser.
  • Fixed issue in the tree menu preview on themes.
  • Fixed issue in the sort fields using free DBMSes.
  • Fixed issue in the search content in the HelpCase.
  • Fixed problem when using macro sc_concat in selection type of fields in the dynamic search.
  • Fixed problem in the interface to remove all fields of dynamic group by.

New in ScriptCase 8.00.0036 (Mar 21, 2015)

  • Specific correction:
  • Fixed problem in the behavior of PHP buttons in horizontal forms.

New in ScriptCase 8.00.0035 (Mar 20, 2015)

  • New functionalities:
  • Added support for Ajax processing in the dynamic filter.
  • Added support for using "all" with capital letters in the records per page option.
  • Specific correction:
  • Fixed problem in ordering of the CSV export in Grids with ORDER BY defined in the SQL settings.
  • Fixed the problem at the "onHeader" event behavior in the Report PDF applications.
  • Fixed problem with the message "Do you want to save?" when select a theme "Only horizontal" in the menu application.
  • Fixed problem in the profiles block when excluding created templates.
  • Fixed problem in the option behavior "Character quantity to display" to interpret HTML content.
  • Fixed problem in the onBlur event behavior when used in a field, then clicking a button.
  • Fixed problem in the behavior of numeric fields with calculator using onBlur event.
  • Fixed problem in the view to positioning the label to define the block with consecutive fields.
  • Fixed problem when clicking to add a record in a master / detail via mobile devices.
  • Bug:
  • Fixed the problem hint fields HTML image in control applications.
  • Fixed the problem when using the option to show "All" in the records per page.
  • Fixed problem in the description for number of cells in the header and footer of the PDF Report application.
  • Fixed problem when changing a block display, affecting the configuration of other blocks.
  • Fixed problem when creating calendar when we add all privileges to a new user.
  • Fixed the problem removing report columns design from the Application List.
  • Fixed the problem when removing Generation status column in the Application List report.
  • Fixed problem in the configuration of the blocks, when a block is deleted.
  • Fixed problem using global variables in the table name in the SQL settings.
  • Fixed problem when entering accented files with umlaut in document upload fields (database).
  • Fixed the problem changing decimal type of fields at the onBlur event.
  • Fixed problem in the exclusion of fields through the Database Builder.
  • Fixed problem in the fields of behavior with an initial focus using onChange event.
  • Fixed problem in the side menu behavior when creating a static break.
  • Fixed duplicate problem when editing links.
  • Fixed problem in the folder titles display in the tab application in Chrome and Opera browsers.
  • Fixed the problem with the back button behavior when there is a link in iframes.
  • Fixed PDF export problem of horizontal forms using custom label group.
  • Fixed problem to preview XLS export in the summary.
  • Fixed problem in the empty filter behavior with date fields in the advanced search.
  • Fixed problem when entering values in the footer of the applications.
  • Fixed problem in the behavior of the number of lines in horizontal forms.
  • Fixed issue in the creation of items in "My Toolbar".

New in ScriptCase 8.00.0034 (Mar 6, 2015)

  • New functionalities:
  • Added support to allow blank value in auto-complete fields.
  • Specific correction:
  • Fixed problem when using the lang in the group label in grid applications.
  • Fixed problem in text multiple lines field to insert records with double quotes.
  • Fixed problem in the format values in text fields.
  • Fixed problem in the images preview in the customize toolbar.
  • Fixed problem in the interface when changing a database without setting password.
  • Bug:
  • Fixed problem with lower resolutions in Edit Fields interface.
  • Fixed problem in the behavior of interface when saving templates.
  • Fixed problem with the copy button layout in detail.
  • Fixed problem in the tree menu CSS.
  • Fixed problem when using sub items with Arabic language on the menu.
  • Fixed problem in the behavior of interface when saving the menu orientation.
  • Fixed charset problem in the description of grid application rows with Hungarian language.
  • Fixed problem on the interface to apply Express Edition in multiples applications.

New in ScriptCase 8.00.0033 (Feb 27, 2015)

  • Specific correction:
  • Fixed Problem when using HTML buttons with JavaScript functions on label fields.
  • Fixed Problem when using the macro sc_date_dif in onApplicationInit events.
  • Fixed issue in the behavior of pages Resulting from the Report PDF using sub-select in the header.
  • Fixed issue of the Grid's QuickSearch when use a TEXT fields in PostgreSQL database.
  • Fixed bug in PDF export applications using labels groups.
  • Fixed PDF file corrupted Problem when downloaded via mobile devices.
  • Bug:
  • Fixed issue When changing the chart type after creating a theme.
  • Fixed issue in the description of the buttons used to create directories in HelpCase.
  • Fixed the checkbox fields behavior with manual lookup in editable grid (view) forms.
  • Fixed issue in the field selection behavior forms of multiple records using the macro sc_field_disabled_record.
  • Fixed problem with tabular ENTER on the first access to the form.
  • Fixed issue in display multiple tabs at lower resolutions.
  • Fixed issue in the preview days of the week on the calendar with Indonesian language.

New in ScriptCase 8.00.0032 (Feb 20, 2015)

  • Specific correction:
  • Fixed problem of duplicate by selecting a field in the dynamic search.

New in ScriptCase 8.00.0031 (Feb 19, 2015)

  • New functionalities:
  • Added horizontal and vertical support for the menu application.
  • Added time parameter option when creating charts in PDF's export configuration.
  • Specific correction:
  • Fixed problem when using apostrophe in the Quick Search.
  • Fixed issue when using multiple criteria values in the Dynamic Search.
  • Fixed problem importing XLS files on the database.
  • Performance improvement:
  • Charts Exportation performance improved.
  • Bug:
  • Fixed problem when using macro sc_error_exit in master/detail application.
  • Fixed problem when including tables with decimal fields in the Data Dictionary.
  • Fixed problem when using Ajax processing with double select.
  • Fixed bug in the PDF export's summary with multiple charts on the same page.
  • Fixed issue when editing the CHARSET while creating an application.

New in ScriptCase 8.00.0030 (Feb 6, 2015)

  • Specific correction:
  • Fixed problem in percentage fields display with negative values in the grid application.
  • Fixed problem when inserting multiple values for a double select fields in editable grid forms (view).
  • Fixed problem in the fields type when importing Excel spreadsheets for database conversion.
  • Fixed problem in select type of fields with multiple values in the filter.
  • Bug:
  • Fixed problem in the date field visualization to change the language via the toolbar in the grid application.
  • Fixed problem in the amount of characters for the user's e-mail in the ScriptCase administrative settings.
  • Fixed problem in the vertical alignment of the menu items with images.
  • Fixed problem in the behavior of disabled fields to score check box fields set to reload after changing the value.
  • Fixed problem when changing amount of bars in the standard HTML editor values in the project.
  • Fixed problem when generating a Grid application initiating as CSV.
  • Fixed auto complete problem in fields for capturing the filter.
  • Fixed problem when clicking on Google Maps fields configured as URL.

New in ScriptCase 8.00.0029 (Jan 30, 2015)

  • New functionalities:
  • Updated examples of projects Samples and Cash Flow. (Required import again)
  • Specific correction:
  • Fixed problem when using macro sc_btn_display in grouped buttons.
  • Fixed problem of invalid characters in the tittle display of chart on a PDF application.
  • Fixed problem when using global variables in procedures with Firebird.
  • Fixed problem date field values to change the language of the form.
  • Fixed data problem invalid in double select fields in grid view editable form.
  • Fixed problem after inserting multiple values in a editable grid view though checkbox fields.
  • Bug:
  • Fixed problem in "Do not Repeat Value" option in fields with lookup.
  • Fixed problem when using QRCODE in a sub-select of the PDF Report application.
  • Fixed problem in sub menu indicators in ScriptCase.
  • Fixed problem in search of HelpCase.
  • Fixed problem when using Ajax event with calculator.
  • Fixed problem in paging editable grids with log module.
  • Fixed problem when using PHP button after deleting details (master/detail).

New in ScriptCase 8.00.0028 (Jan 22, 2015)

  • Bug:
  • Fixed problem when using the preg_match function to validate amount of numeric digits.
  • Fixed problem when you click to add images on buttons.
  • Fixed problem in the distortion of images to be resized in the PDF Report application.
  • Fixed problem when using predefined texts in the cells of the PDF Report application.
  • Fixed problem validating the unique key when the form is configured to update link table.
  • Fixed problem of accentuation in HTML Editor fields when exported to Excel or Word.
  • Fixed problem when using Google Maps field in a grid application with INNER JOIN.
  • Fixed problem in the TO-DO's scroll bar.
  • Fixed problem in the nomenclature of the friendly URL of the menu application.
  • Fixed problem in the security module when there is different users using the same email.
  • Fixed problem when inserting files with the plus sign (+) in multi upload fields.
  • Fixed problem when exporting to Excel in the grid application using the macro sc_where_current.
  • Fixed duplicate header problem of the summary in grid applications.
  • Fixed SQL problem to add a record in multi upload fields using sequence in auto-increment.
  • Fixed problem when using Ajax events in fields with calculator.
  • Fixed problem in the symbol display (-) in negative fields.
  • Fixed double processing problem using Ajax processing.
  • Fixed problem in the charts display when it is set as black and white.
  • Fixed problem in the validation of the message "That the data have already been sent previously."
  • Fixed problem when using custom tables in the security module.
  • Fixed Javascript problem when using the Run button.
  • Fixed problem when using UNION in SQL's chart application.
  • Fixed problem when using the key of properties in the Firefox browser on text fields.
  • Fixed problem in "Do not repeat value" upload fields in the grid application.
  • Fixed problem in the field Document(database) in the editable grid form.
  • Fixed problem on upload fields in Editable Grid View, Editable Grid and Multiple Records types of form.
  • Fixed problem in view of the fields when using the free-form option.
  • Fixed problem when configuring Google Maps fields such as latitude and longitude without informing the fields.
  • Fixed problem with tabulate with Enter on upload fields.
  • Fixed problem saving filter profile that contains checkbox fields.
  • Fixed problem in the navigation of form after using Ajax event with Javascript function.
  • Fixed error "Undefined property" in the deployment of container applications.
  • Fixed problem in navigation on forms with editable grid with Log module.
  • Fixed problem when using Google Maps field modal in Firefox browser.

New in ScriptCase 8.00.0027 (Jan 3, 2015)

  • Specific correction:
  • Fixed problem insert and update files on multiupload fields.
  • Bug:
  • Fixed problem in the validation of required fields when using special conditions in the date field of the filter.

New in ScriptCase 8.00.0026 (Dec 27, 2014)

  • Specific correction:
  • Fixed issue for downloading files, with characteres multi bytes in upload fields.
  • Fixed issue in behavior of file type fields when disabled.
  • Fixed session issue when using the Database Builder.
  • Fixed issue when using grouping of buttons on control application.
  • Fixed issue in display of files in multiple uploads field on first access.
  • Bug:
  • Fixed issue in the indicators of submenu itens in Internet Explorer.
  • Fixed issue when executing commands saved in SQL Builder.
  • Fixed issue on the Google Maps fields in grid application.
  • Fixed interface issue on session data of application.
  • Fixed issue when using the Ctrl+Space shortcut in brackets in the code editor.
  • Fixed issue in the interface of Database Builder.
  • Fixed problem in navigation buttons to the Spanish language (United States).
  • Fixed issue when using methods in Ajax event in grid application.
  • Fixed issue of broken characteres in the language field in the toolbar.
  • Fixed edge issue in menu images using Internet Explorer 10.
  • Fixed issue when using tables named with dollar sign in SQL Server.
  • Fixed problem in entering data in fields of type ENUM.
  • Fixed issue when using the Ctrl+Space shortcut when preceded by spaces and tabs.
  • Fixed issue in master/detail navigation using query details.

New in ScriptCase 8.00.0025 (Dec 19, 2014)

  • Specific correction:
  • Fixed problem in image resolution in the converted PDF Report applications.
  • Fixed problem in view with double scroll bars in Internet Explorer using the menu application.
  • Bug:
  • Fixed problem to hide the detail in view of a form with several details.
  • Fixed problem when displaying the field value in Report PDF footer using the macro sc_pdf_output.
  • Fixed problem in view of the background to change the orientation of grid application.
  • Fixed problem in the back button configured with outbound URL in the grid application linked to the menu.
  • Fixed problem in the view of virtual fields in the configuration of grid application columns.
  • Fixed problem in the display for WORD export.

New in ScriptCase 8.00.0024 (Dec 16, 2014)

  • Specific correction:
  • Fixed problem when searching for DATETIME fields configured as type date in the filter.
  • Bug:
  • Fixed problem in the interface to create langs without content.
  • Fixed problem when creating applications with multi upload hidden fields.

New in ScriptCase 8.00.0023 (Dec 12, 2014)

  • New functionalities:
  • Created new macro to change the file name when exporting WORD. sc_set_word_name macro. This macro should be used in the event "onScriptInit".
  • Specific correction:
  • Fixed issue when using DISTINCT with INNER JOIN on totals.
  • Fixed problem when accessing the summary of a grid application using DISTINCT.
  • Fixed problem when using ENTER to tabular in double select fields.
  • Fixed issue in the grid application started by the filter when submitted by ENTER.
  • Fixed problem when using the macro sc_redir in grid Ajax events.
  • Fixed problem for date fields are disabled.
  • Fixed issue when clicking outside after selecting a value, in SELECT fields for multiple values.
  • Fixed issue when using initial focus in editable grid form (View).
  • Fixed issue on required field validation with multi upload fields.
  • Performance improvement:
  • Modified the layout of advanced filter in grid application.
  • Bug:
  • Fixed issue when clicking on folder "HelpCase" in Images Manager used on HelpCase.
  • Fixed issue in interface after link application at HelpCase.
  • Fixed issue when recreating tables with prefix through the security module.
  • Fixed issue in groups of Firebird connections in the data dictionary.
  • Fixed problem in navigation after adding records into a form connected to another form.
  • Fixed issue when using check box fields in forms with automatic lookup.
  • Fixed issue when using check box fields updating more of one value on the form.
  • Fixed issue when using the option to convert letter on Report PDF.
  • Fixed issue when using sc_appmenu_update_item macro.
  • Fixed issue when using sub select with a field in report PDF.
  • Fixed issue when using the Database Builder to modify the table.
  • Fixed problem in displaying the Finish connection button to create a new project.
  • Fixed display problem with global variables commented, in the interface.
  • Fixed problem when publishing an application with the French language.
  • Fixed issue of indexes in the production environment.
  • Fixed issue when using form with drop down in Internet Explorer or Firefox.
  • Fixed problem with alignment of blocks to enable tree view.

New in ScriptCase 8.00.0022 (Dec 3, 2014)

  • New functionalities:
  • Added option to display the month spelled out in fields date with combo box in the filter.
  • Specific correction:
  • Fixed problem with misalignment in the summary using several breaks, in XLS export.
  • Fixed problem in the script to criticize existing dependencies with 3 or more foreign keys.
  • Fixed problem when using initial focus in an auto-complete field.
  • Fixed problem in the fields of date format when used with multi upload in the form.
  • Fixed problem of invalid characters when using the characters allowed in the form.
  • Fixed problem in PDF report using text field multiple lines in the header.
  • Fixed problem when using onMouseOver and/or onMouseOut events on the form.
  • Bug:
  • Fixed problem in the label and hint configuration at HelpCase button form.
  • Fixed problem in applications count when done the decrement of a project.
  • Fixed problem with link type option on Google Maps field.
  • Fixed problem increase earlier version of a project.
  • Fixed problem in tab behavior with Enter in multiple line fields.
  • Fixed problem when using slide orientation with consecutive blocks in the grid application.
  • Fixed problem when inserting values in decimal fields with 16 or more characters.
  • Fixed problem when using JavaScript in label and/or HTML editor fields.
  • Fixed problem in tab behavior with Enter in SELECT fields.

New in ScriptCase 8.00.0021 (Nov 26, 2014)

  • Specific correction:
  • Fixed problem in the global variables untreated quotes in SQL.
  • Performance improvement:
  • Improved performance during installation ScriptCase.
  • Bug:
  • Fixed problem with values processed in onHeader event with XLS export.
  • Fixed problem at the interface of procedure applications.

New in ScriptCase 8.00.0020 (Nov 21, 2014)

  • Specific correction:
  • Fixed problem when generating container application.
  • Fixed problem when using Ajax processing in the filter in grid application.

New in ScriptCase 8.00.0019 (Nov 21, 2014)

  • New functionalities:
  • Added message for validation of SQL syntax in grid applications.
  • Specific correction:
  • Fixed problem in HelpCase search in Internet Explorer 11.
  • Fixed problem of PDF export in grid applications.
  • Fixed problem in Ajax processing option for search fields in form application.
  • Fixed problem in Quick Search after conversion in grid application with nested grid.
  • Fixed problem of NULL fields when importing or restoring applications and projects.
  • Changed font type in code editor to Courier.
  • Bug:
  • Fixed problem in macro sc_btn_display on navigation buttons.
  • Fixed problem in the itens for insert and update values of the database, in fields edition.
  • Fixed problem for close the application when opening several applications in project interface.
  • Fixed problem in visualization of SQL Server connections in Database Builder.
  • Fixed problem in lateral column of code editor to some themes.
  • Fixed problem using Google Maps API in blank application.
  • Fixed problem in source code view with Russian language.

New in ScriptCase 8.00.0018 (Nov 18, 2014)

  • Specific correction:
  • Fixed crash problem when accessing the menu application in Firefox. (Will be necessary to clear the browser cache)
  • Fixed crash problem when accessing the HelpCase.
  • Fixed problem using calculator in form application.
  • Fixed problem in theme of code editor in library.
  • Performance improvement:
  • Improvement in performance when creating menu application.

New in ScriptCase 8.00.0017 (Nov 15, 2014)

  • New functionalities:
  • Added option to group by per date or date/time in DATETIME and TIMESTAMP fields.
  • Added directory to see all tasks in TO-DO list.
  • Added tasks search in TO-DO list.
  • Added files list in "Include HelpCase" option in HelpCase.
  • Added treatment for save changes, when exiting of a modified file, in HelpCase.
  • Added themes option in events editor, templantes and libraries.
  • Added filename and file path above HelpCase editor
  • Specific correction:
  • Fixed problem in settings loss of group by and totalization when changing the application SQL.
  • Fixed problem in charset settings, in production environment, for MySQL PDO connection. (Need to update the production environment.)
  • Fixed problem in form applications when using field link type, with empty value in primary key.
  • Fixed problem when attributing a value to a datetime field and using the "Copy" button.
  • Fixed problem in mask of date field, in dynamic search with the chart module enabled.
  • Fixed problem in blocks exibition, with tabs, when are without fields.
  • Fixed problem when renaming applications that are referenced in several links.
  • Fixed problem in auto-complete of the search, of grid application.
  • Fixed problem in log module when incrementing projects.
  • Fixed problem when using variables as parameters, in sc_field_readonly macro.
  • Fixed problem in formatting of TIMESTAMP field in summary, using oracle connections.
  • Fixed problem when using search events of grid applications, inheriting for the grid application.
  • Fixed problem in auto-complete of dynamic search, when disabling the search module of grid application.
  • Fixed problem in number auto-comple fields in advanced search.
  • Performance improvement:
  • Improvement in HelpCase layout and performance.
  • Bug:
  • Fixed problem when updating a label field as filename, without being displayed in insert.
  • Fixed problem in drag n' drop of dynamic group by with a long text in the label of the field.
  • Fixed problem in icon of chart application when generating the sourcecode of application.
  • Fixed problem in resizing of the screen in Internet Explorer, with files editor of HelpCase.
  • Fixed problem when adding images inside menu's folders of HelpCase.
  • Fixed problem when linking a file to an application, in a project that hasn't applications, in HelpCase.
  • Fixed problem when using a lang along with a text in the label of dynamic group by.

New in ScriptCase 8.00.0016 (Nov 7, 2014)

  • Specific correction:
  • Fixed problem with Gantt charts HTML5 generated in flash.
  • Fixed problem in macros sc_connection_edit and sc_connection_new when used in a production environment.
  • Fixed problem when validating required fields not displayed in the update.
  • Fixed problem in aligning the sub-select field in reportPDF.
  • Fixed problem with file upload/image in editable grid applications.
  • Fixed language problem on the print button in the calendar application.
  • Fixed problem ScriptCase installation on different ports in the Mac OS environment.
  • Fixed problem behavior Youtube field.
  • Fixed problem in export formats in the toolbar of the summary.
  • Fixed problem when viewing the HTML template editor on smaller screens.
  • Fixed problem in PDF export in grid application on server with security certificate.
  • Performance improvement:
  • Enhance to proccss of improvement projects.
  • Bug:
  • Fixed problem when using value 0 in mathematical operations in Ajax event.
  • Fixed problem in grids using ORDER BY with single quotes in the CONCAT function.
  • Fixed problem with retrieve password in the security module.
  • Fixed problem with charts overlapping fields listed in the dynamic filter.
  • Fixed issue in charts icon when change the totals.
  • Fixed problem in alignment of fields in converted applications into PDF Report.
  • Fixed problem behavior fields upload applications returning to the mode of insert.
  • Fixed problem with multi-upload by using the digit grouping option.
  • Fixed issue in recognition of decimals to create new applications.
  • Fixed problem of outdated applications to terminate generation of source code.
  • Fixed problem date format for date and time fields in the chart application.
  • Fixed crash problem typing in fields of type decimal.

New in ScriptCase 8.00.0015 (Nov 4, 2014)

  • New functionalities:
  • Added Timezone configuration in the general settings on Scriptcase.
  • Added Timezone configuration in the Scriptcase's production environment.
  • Added Timezone configuration in the ScriptCase installation.
  • Specific correction:
  • Fixed issue using the macros sc_connection_edit and sc_connection_new when used in the production environment.
  • Fixed display issue of values ​​in DATETIME columns when there is a grid lookup.
  • Fixed issue in the char application when the searches results in records not found.
  • Fixed problem when using PROCEDURES on multiple records and editable grids Forms.
  • Fixed problem in macro sc_apl_conf when used on mobile devices.
  • Fixed problem in the alignment of the totalization when using dynamic Group By.
  • Fixed issue when generating a form with fields running position on the block, using the macro sc_field_display.
  • Fixed problem in back button to edit a record from a Grid of an express creation, accessed on mobile devices.
  • Fixed problem creating the log module using Firebird connection.
  • Bug:
  • Fixed problem inserting images into BLOB fields in Oracle ODBC connection.
  • Fixed problem on the button to display the INSERT commands in the list of project applications.
  • Fixed problem executing SQL on forms with fields named with numbers.
  • Fixed the display issue on the custom messages in the SQL configuration from Chart applications.
  • Fixed issue in the footer toolbar, when the form has the block with the calendar fields.
  • Fixed issue from date and time fields set to null when using the Copy button.
  • Fixed issue when clicking the "New button" in the Grid application initiated by the filter, which has a link to a form inside an iframe.
  • Fixed problem with cursor buttons disabled in the Scriptcase themes.
  • Fixed issue in the HTML editor field to limit the amount of characters to display.
  • Fixed problem when using an intreger field (bigint) in terms of grid applications using advanced search.
  • Fixed problem deleting old versions of the project.
  • Fixed issue on the "warning to save" after leaving the settings from header, footer and summary without saving changes.
  • Fixed issue in the language files in the conversion.
  • Fixed issue when returning values ​​in date fields in the search onScriptInit event.
  • Fixed problem displaying fields when the table is named with lower case in Firebird.

New in ScriptCase 8.00.0014 (Oct 17, 2014)

  • New functionalities:
  • Created the sc_connection_new macro. This macro allows the creation of new connections dynamically. The Macros definition is available in Scriptcase's documentation.
  • Created the sc_connection_edit macro. This macro will edit an existing connection at runtime. The Macros definition is available in Scriptcase's documentation.
  • Added Advanced filter and regular filter in the chart application.
  • Specific correction:
  • Fixed issues in the Helpcase's HTML editor on Linux environments.
  • Fix MSSQL PDO using "DISTINCT" in the sql command.
  • Bug:
  • Fixed problem when using the special condition "All Period" in DateTime types of field.
  • Fixed issues when creating a PHP method on Scriptcase interface without any attributes.
  • Adjustments in example projects.

New in ScriptCase 8.00.0013 (Oct 10, 2014)

  • New functionalities:
  • Added the version number in the name of backup file.
  • Added option to remove the schema before the tables in the data dictionary.
  • Specific correction:
  • Fixed on Windows installer, Oracle's problem to connect with the environment of instant client installed environment. (You will need to reinstall the environment).
  • Bug:
  • Fixed problem in blocks configured as tabs with master / detail.
  • Fixed problem in the size of ID field on Google+.
  • Fixed issue when starting an application as a chart.
  • Fixed issue when running the dynamic filter on the summary.
  • Fixed problem in condition between two values ​​of the filter.
  • Fixed issue when viewing the details of a grid with master / detail.
  • Fixed problem when browsing the grid of a master / detail.
  • Fixed problem in ODBC Oracle connection.
  • Fixed conflicts in ajax events.

New in ScriptCase 8.00.0012 (Oct 3, 2014)

  • Specific correction:
  • Fixed problem in the filter autocomplete when using the capture option.
  • Bug:
  • Fixed issue when saving settings in lookup applications.
  • Adjustments in example projects.
  • Fixed problem adding events on the calendar application on mobile devices.

New in ScriptCase 8.00.0011 (Sep 27, 2014)

  • Bug:
  • Fixed the problem on the exportation buttons visualization.

New in ScriptCase 8.00.0010 (Sep 26, 2014)

  • New functionalities:
  • Added support to TOP function for MS SQL Server databases.
  • Specific correction:
  • Fixed problem using DATETIME fields with special conditions in the filter.
  • Fixed problem when searching for DATE type virtual fields in the filter.
  • Bug:
  • Fixed problem when importing the samples projects on the MS Access database.
  • Fixed problem when using the macro sc_set_language in the onApplicationInit event.
  • Fixed problem when using the macro sc_set_regional in the onApplicationInit event.

New in ScriptCase 8.00.0009 (Sep 20, 2014)

  • New functionalities:
  • Added SSL support to recover ScriptCase password.
  • Added SFTP support for projects deployment.
  • Specific correction:
  • Fixed issue with the visualization of Views for MS Access connection.
  • Fixed issue in view of Google Maps on mobile devices.
  • Fixed issue in master/detail navigation when used grid as detail.
  • Bug:
  • Fixed issue when using floating menu with toolbar.
  • Fixed issue with visualization of abbreviated values in the charts.
  • Fixed issue in the search from the Grid QuickSearch using ENTER.
  • Fixed problem when generating source code from the sync tables screen in the forms.

New in ScriptCase 8.00.0008 (Sep 12, 2014)

  • New functionalities:
  • Added new option to hide or make the menu icon visible.
  • Added new option to positioning the floating menu. Whether to display the floating menu to the right of the icon or below the menu.
  • Performance improvement:
  • Added in the search application, the option to open the application in a direct search.
  • Bug:
  • Fixed problem positioning the toolbar in menu application when used with the floating option menu enable
  • Fixed the spacing of the header and/or toolbar in order to position the menu icon.
  • Fixed issue when using the TreeView option in Group bys on Grid applications.
  • Fixed problem saving the manual lookups dynamic filter fields on form application.
  • Fixed problem when add new buttons in the grouping buttons option on the toolbar.
  • Fixed problem in the samples project importation.

New in ScriptCase 8.00.0007 (Sep 5, 2014)

  • New functionalities:
  • Added a configuration option to sort the fields in the Grid application.
  • (Use the fields displayed in the query, Using columns defined in the Columns or Customize the definition of the fields)
  • Added option to hide the menu when you click on any menu item for desktop and mobile.
  • Added option to hide the menu on desktop and start the menu in mobile mode.
  • Added option to show the floating menu when the normal menu is hidden for desktop and mobile menu.
  • Specific correction:
  • Fixed problem when using lookup in onApplicationInit event.
  • Fixed issue when updating records in the form on mobile devices.
  • Fixed problem using Ajax events on mobile devices.
  • Fixed issue with auto complete fields in forms applications with format multiple record and editable grids.
  • Bug:
  • Fixed issue when cleaning the form's QuickSearch from a multiple records type.
  • Fixed problem in positioning the message "Processing .." when used in Ajax events.
  • Fixed problem when using the summary on every page of the Grid application.
  • Fixed issue when accessing a project with locked version.

New in ScriptCase 8.00.0006 (Sep 1, 2014)

  • New functionalities:
  • Added new auto complete component for forms, controls, dynamic searches and advanced searches.
  • Added new option for editor menu CSS for background images of the menu line.
  • Specific correction:
  • Fixed problem with the columns and sort buttons to start the grid by the filter.
  • Fixed problem importing Scriptcase 8 projects.
  • Fixed problem with error after accessing Scriptcase.
  • Fixed problem to list tables with MySQL PDO connection in publishing environment with PHP 5.5.
  • Fixed problem in grouping buttons after conversion.
  • Fixed problem on processing Ajax in form and control applications to access for mobile.
  • Fixed problem deleting a record in the application form when the filter resulted in a single record.
  • Bug:
  • Fixed problem setting the background image in the CSS editor menu.
  • Fixed problem with ENTER submit the advanced search.
  • Fixed problem with tabular ENTER in dynamic search and advanced search.
  • Fixed problem setting links in the HTML image fields.
  • Fixed problem in macro sc_master_value on event onApplicationInit into forms.

New in ScriptCase 8.00.0005 (Sep 1, 2014)

  • Specific correction:
  • Fixed problem of duplicate data entry form with the dynamic search.
  • Fixed problem to view the onRecord event in the Report PDF applications.
  • Bug:
  • Fixed problem with export in the chart application.
  • Fixed problem when restoring applications with specific connection.

New in ScriptCase 8.00.0004 (Aug 16, 2014)

  • Specific correction:
  • Fixed issue the "Internal Server Error" in Linux environments during automatic update. (Required reinstall Scriptcase on Linux environments)
  • Fixed issue when changing items in the menu tree application.
  • Bug:
  • Fixed issue with navigation buttons in Forms applications linked to Grids applications.
  • Fixed problem in SMTP configuration during the creation of the security module.
  • Fixed issue when generating Grid applications in PDF mode when starting by the filter.
  • Fixed problem when using "the use password" option in the security of grid application.

New in ScriptCase 8.00.0003 (Aug 14, 2014)

  • New functionalities:
  • Added option to use more than one field in the metric of option for chart applications.
  • Specific correction:
  • Fixed issue when using specific connection in a lookup in text type of fields.
  • Fixed problem displaying blocks on mobile devices.
  • Fixed problem when authenticating users accessing forms through mobile devices.
  • Bug:
  • Fixed issue when adding empty items in the tree menu.
  • Fixed issue in the menu's theme preview in the menu's settings.
  • Fixed issue displaying the sub groups buttons when the application was generated with charts.
  • Fixed issue when changing the format during the from generation.
  • Fixed issue on the chart's link when it has more than one dimension.
  • Fixed problem removing the "Number of Records" option in metric section on Chart applications.
  • Fixed issue when adding empty buttons on the menu's toolbar.
  • Fixed problem in using the macro sc_reset_global in the security module.
  • Fixed issue in the control application status after change the fields configuration.

New in ScriptCase 8.00.0002 (Aug 8, 2014)

  • New functionalities:
  • Added option to use SSL on SMTP in the creation of the security module.
  • Specific correction:
  • Fixed syntax error when clicking on the detail of the Grid.
  • Fixed accented words of the Report PDF in converted applications.
  • Bug:
  • Fixed SQL error using virtual fields in the search of the Grid.
  • Fixed display of images in the preview of the menu after conversion.
  • Fixed option to use layout (re-sizing) in the treemenu.
  • Fixed issue after changing values ​​in the format of the form.
  • Fixed error when restoring backup containing tasks on TO DO.
  • Fixed behavior on the menu application using macro sc_menu_disable on mobile devices.
  • Fixed security behavior in the menu items on mobile devices.
  • Fixed behavior of dynamic menu (using macros) on mobile devices.

New in ScriptCase 8.00.0001 (Aug 4, 2014)

  • New functionalities:
  • Added new options for alignment and positioning of the number of pages on pdf export. This option is available in the PDF export settings.
  • Specific correction:
  • Fixed issue in published applications when accessed on mobile devices. (You will need to generate the source from the applications and deploy it again).
  • Fixed issue in navigation and update from radio button, checkbox and select configured as a manual lookup.
  • Fixed issue when creating express applications with PostgreSQL connection.
  • Bug:
  • Fixed problem accessing the group by buttons, sorting and columns when running from the menu application.
  • Fixed problem with syntax error, unexpected '

New in ScriptCase 8.0.000 (Aug 4, 2014)

  • New functionalities:
  • Added a new option to group the toolbar buttons
  • Added a new feature to send/receive messages between users from the same Scriptcase installation
  • Implemented a new tool to manage all images from Scriptcase
  • Created a new tool that create TO-DO lists between users from the same Scriptcase installation
  • Now, the Form application adjusts itself automatically when accessed in a browser by a mobile device
  • Added a new configuration interface from Form and Grid applications
  • Implemented a new feature that allows the search, group by and filter to be set up dynamically by the end user.
  • Created a new chart application
  • Added a new tool to edit the char themes
  • Implemented improvements on the calendar application
  • Created a new tool to import ACCESS files, CSV and XLS to MySQL, SQLite, Postgres and MSSQL databases
  • Implemented a Dynamic Search on Form Applications
  • Added support for TCPDF class in Report PDF application and language Arabic .

New in ScriptCase 7.1.021 (Apr 29, 2014)

  • New functionalities:
  • Added new languages: Bulgarian, Danish, Estonian, Ukrainian and Belarusian
  • Bug:
  • Problem using an empty title in a Radio field with manual lookup.
  • Problem upon formatting Decimal fields in the criticize of ajax events.

New in ScriptCase 7.1.020 (Apr 16, 2014)

  • New functionalities:
  • Added new regional settings
  • Belarus (russia).
  • Kazakhstan (russia)
  • Botswana (English)
  • Cameroon (English)
  • Uganda (English)
  • Zambia (English)
  • Zimbabwe (English)
  • French (Cameroon)
  • Romanian (Moldavia)
  • Added new language Latvian (Latvia)
  • Bug:
  • Fixed problem in the value informed in the normal conditions of the filter. It was being replicated to the special conditions.
  • Fixed problem in the navigation of applications that were using Document (Database) field, charset UTF-8 and files named with: ç, ã, â, à, á and '.

New in ScriptCase 7.1.019 (Apr 8, 2014)

  • New functionalities:
  • Added a new sample system: Documents Library.
  • Bug:
  • Fixed issue in the multiupload field, when the form has a criticize of dependencies.

New in ScriptCase 7.1.018 (Mar 27, 2014)

  • New functionalities:
  • Added new language: Malay.
  • Bug:
  • Fixed the SQL Server scripts of samples projects.
  • Fixed the option "Return after inclusion", when the button "Lines" is enabled on the form.

New in ScriptCase 7.1.017 (Mar 14, 2014)

  • Specific correction:
  • Fixed SQL problems of example projects for Firebird database.
  • Bug:
  • Fixed error when using the connection parameters with global variables, the link button type, using the modal property.

New in ScriptCase 7.1.016 (Feb 20, 2014)

  • New functionalities:
  • Added background image position in the advanced settings of the theme.
  • Specific correction:
  • Fixed error in the "Return after insert" option of the Forms.

New in ScriptCase 7.1.015 (Feb 19, 2014)

  • New functionalities:
  • Added new sample project to recruitments tracker
  • Bug:
  • Fixed problem accessing an application that needs to inform the value of the variable.
  • Fixed problem recovering special characters in ajax events.
  • Fixed issue when using Turkish characters in ReportPDF.
  • Fixed bug in the filter conditions using TIMESTAMP in PostgreSQL.
  • Fixed problem with empty WHERE clause when searching for just the time in a TIMESTAMP field using the conditions Starting with, Contains and Does not contain.
  • Fixed problem with replicated values in the normal conditions when selecting special conditions.
  • Fixed problem in the date format in the events of PHP button.

New in ScriptCase 7.1.014 (Jan 9, 2014)

  • New functionalities:
  • Added support to PHP variables in the variable parameter of sc_link
  • Ej.: $var = name;
  • sc_link (field , $ var , company = [ cpny ] , "My name", " iframeR" );
  • Added support to choose which projects will be converted during the conversion.
  • Added support for output parameters to stored procedures with MySQL.
  • Bug:
  • Fixed problem when using the macro sc_getfield ( ) within a Javascript button.
  • Fixed issue when using the macro sc_lookup in the onApplicationInit of a Menu application.
  • Fixed problem when using copies of Scriptcase templates in the applications.
  • Fixed problem when using titles in radio fields with manual lookup.
  • Fixed problem when using background image in PDF Report application.
  • Fixed bug in navigation when using macro sc_redir in master / detail.
  • Fixed problem when using the macro sc_groupby_label in onGroupBy event.
  • Fixed issue when using the macro sc_field_display in fields of blocks with 2 or more columns.
  • Fixed issue on the " Check all " option of Checkbox fields of a Filter.
  • Fixed issue on the interface to use global variables in the onFinish event of a RUN button.

New in ScriptCase 7.1.013 (Dec 10, 2013)

  • New functionalities:
  • Added the search condition "Not Contains" for the Filter and QuickSearch.
  • Bug:
  • Fixed bug when using the GET method for global variables in the Blank application.
  • Fixed issue in the search conditions 'Starting with" and "Contains" in date fields when using the PostgreSQL connection.
  • Fixed issue in the search conditions 'Starting with" and "Contains" in date fields when using the Firebird connection.
  • Fixed issue in the search conditions 'Starting with" and "Contains" in date fields when using the Oracle connection.

New in ScriptCase 7.1.012 (Nov 29, 2013)

  • Bug:
  • Fixed problem when using \e in the date values of the header or footer with PHP 5.4.
  • Fixed problem when using Ajax processing in more than 3 fields in the filter.
  • Fixed bug to startup the Apache service after installing Scriptcase in Mac OS environments.
  • Fixed problem to hide the menu item when using the mobile menu option.
  • Fixed issue when deleting a virtual field with Totals and Group By.

New in ScriptCase 7.1.011 (Nov 23, 2013)

  • Bug:
  • Fixed problem in the application linking of the security module for fields named with Chinese characters.
  • Fixed issue in fields DATE / TIME of the filter in Report PDF application, when the regional settings are customized.
  • Fixed problem in the N-N Relations using the object as a radio.
  • Fixed problem generating the application with global variables commented.
  • Fixed problem displaying the settings for PDF exporting when using iframe in Tab applications.
  • Fixed problem upon changes in the master / detail form using a Grid application.
  • Fixed problem in the option "submitting in the onchange" for DATE / TIME fields of a Filter.
  • Fixed issue in the chart and line settings of virtual fields of the Grid.
  • Fixed problem in the Application Search feature.
  • Fixed problem in the parameter "field_readonly" of the macro "sc_apl_conf".
  • Fixed problem in the button "Chart settings" when we unselect the option "Horizontal Total".
  • Fixed problem in visibility of disabled buttons, creating buttons.

New in ScriptCase 7.1.010 (Nov 14, 2013)

  • New functionalities:
  • Added support for PHP 5.4 in Scriptcase.
  • Linux installer now supports RedHat and Ubuntu 13.
  • Display of file names after select them to upload.
  • Bug:
  • Fixed problem when displaying a background image into the blocks of the form.
  • Fixed issue when performing a search by using the "exactly equal" in the filter with PostgreSQL.
  • Fixed issue with the message "log scheme already exist" upon saving changes in the log module.
  • Fixed problem in the button to generate a preview of the bar code field.
  • Fixed problem in the limit of allowed extensions for file fields.
  • Fixed issue when saving changes in the summary settings using Group By with more than one field named with blank spaces.
  • Fixed issue when performing quick searches using PostgreSQL.
  • Fixed bug in validation of hidden fields in the update or insert , using the macro sc_error_message.
  • Fixed problem when exporting applications named with hyphen , comma or plus.
  • Fixed bug in the PDF exports of a Grid that is using Group By in Linux environments.

New in ScriptCase 7.1.009 (Oct 3, 2013)

  • New functionalities:
  • Added IP configuration for temporary PDF files external directory.
  • (Update of the production environment is needed)
  • Added display the QuickSearch in a master/detail's Grid.
  • Added name treatment of downloaded files on document fields with exclamation marks (!), Comma (,), period (.), Hyphen (-), plus (+), single quote (') and spaces.
  • Bug:
  • Fixed problem on the RUN button processing the when using the option to display GroupBy labels.
  • Fixed issue when navigating between charts when the option to display a summary of all the pages is enabled.
  • Fixed problem when exporting PDF of a editable grid (view) master/detail form.
  • Fixed problem in generating a form when using library classes.
  • Fixed problem in Ajax event while processing a field with display mask.
  • Fixed issue document fields when downloading files with plus signs (+) in the name.
  • Fixed problem in modal window size when exporting PDF with RTL language.
  • Fixed problem in the "records to display" button in a master/detail.
  • Fixed issue document fields when downloading files with spaces in the name.
  • Fixed issue document fields when downloading files with single quotation marks (') on the name.
  • Fixed problem displaying the Support page on Firefox when accessed from Scriptcase's menu.

New in ScriptCase 7.1.008 (Sep 21, 2013)

  • New functionalities:
  • Fixed problem displaying the QuickSearch in a master/detail's Grid.
  • Bug:
  • Fixed the duplicity problem of the and tags when using the macro sc_redir in a RUN button.
  • Fixed issue when using tabs with normal organization and menu orientation.
  • Fixed problem when using master / detail block starting collapsed on Firefox and Internet Explorer.
  • Fixed problem displaying date / time format for Chinese (Traditional, Hong Kong)
  • Fixed bug in calendar application, when naming the tables created by Scriptcase with reserved words.
  • Fixed problem when using the option to display the summary on the last page.
  • Fixed problem displaying a master/detail with pages and blocks.
  • Fixed spacing problem when concatenating curly brackets.

New in ScriptCase 7.1.007 (Sep 10, 2013)

  • Bug:
  • Changed the default JS execution time in PDF export settings.
  • Fixed problem when displaying a Master / Detail in a tab block.

New in ScriptCase 7.1.006 (Sep 6, 2013)

  • New functionalities:
  • Included new IIS integrated authentication variables for PDF export: [sc_iis_usr] and [sc_iis_pw]
  • Bug:
  • Fixed loss of files on required multiupload fields after the form validation fails.
  • Fixed problem with iframe height in a master-detail application on Google Chrome.
  • Fixed bug in on accentuation validation on a text field "allowed characters" settings.
  • Fixed issue after using PDF Export on a summary with charts on top of the same page.
  • Fixed issue when generating an form application without blocks to be displayed.
  • Fixed problem in GroupBy titles when using LTR languages​​.
  • Fixed problem when using help hint with LTR languages​​.
  • Fixed problem when using language variables on the label and request field labels on a CSV export.
  • Fixed problem when using language index, the label capture a field auto-complete.
  • Fixed undefined variable generating the source code of a renamed application with links.
  • Fixed button placement on the creation of projects, in "languages" step.
  • Fixed problem in the N-N relationship interface, on the "filter" step.
  • Fixed problem in the N-N relationship interface, on the "lookup display" step.
  • Fixed bug on navigation buttons while using LTR languages​​.

New in ScriptCase 7.1.005 (Aug 27, 2013)

  • New functionalities:
  • Added message to synchronize the charset of the project and database when it's incompatible, while creating a PostgreSQL or MySQL connection.
  • Bug:
  • Fixed issue in the description of the alignment options for the grid application fields. (project default values)
  • Fixed problem on an "User defined" grid application when using the subfolder option of an "image (file name)" field.
  • Fixed issue when using global variable in the SQL Statement of a N-N relationship if the "filter" option is enabled.
  • Fixed issue to show alignment fields for the project default values.
  • Fixed the problem when displaying fields' with accentuation using UTF-8 on the HTML Editor.
  • Fixed the problem on the the production environment path when deploying an editable grid form with modal.
  • Fixed the issue when using an empty GroupBy rule with a calculated field on the grid applications.

New in ScriptCase 7.1.004 (Aug 15, 2013)

  • New functionalities:
  • Added new option to show link to charts on pivot Summary.
  • Added port field in PostgreSQL connection properties on the production environment.
  • Bug:
  • Fixed issue when changing the SQL of a Grid application when there are columns with mathematical functions.
  • Fixed issue when changing the SQL query by concatenating fields.
  • Fixed problem accessing the PostgreSQL bases using username other than default.
  • Fixed problem when using Group Label in the Summary of a Grid Application.
  • Fixed issue on the Android/Blue Menu Theme.
  • Fixed problem when using apostrophe values with sc_link macro.
  • Fixed bug in application output URL when defined in the field link properties.
  • Fixed issue uppon clicking to export a query as Microsoft Word file in Google Chrome.
  • Fixed problem with preview pictures (File Name) with subdirectory on applications with more than a thousand records.
  • Fixed issue on Grid Applications with default GroupBy rule without group, when this Grid was configured to start by filter with Summary as initial module.
  • Fixed error when viewing a report of project applications per folder.
  • Fixed problem accessing Scriptcase with an user that has all privileges but Administration.
  • Fixed problem with friendly URL when copying an application into the same project.
  • Fixed issue when importing application with friendly URL on a project that already contains the same URL.
  • Fixed problem displaying blocks when changing a form from Editable Grid to Single Record.
  • Fixed problem when setting the option to use password once in Menu Applications.
  • Fixed issue when compiling new applications when they have a link just configured.

New in ScriptCase 7.1.003 (Aug 7, 2013)

  • Bug:
  • Fixed problem when deploying a Grid starting by the filter if it is using iframe.
  • Fixed problem in the RUN button after changing the quantity of records in a Grid with Ajax support.
  • Fixed bug in the Scriptcase session after compiling applications.
  • Fixed issue when deploying a project via FTP.
  • Fixed an interface problem when renaming a folder on the home screen of the project.
  • Fixed issue about the amount of characters in the user password of Scriptcase.
  • Fixed problem to convert applications after upgrade Scriptcase to version 7.1
  • Fixed problem in the languages of Scriptcase after install it.

New in ScriptCase 7.1.002 (Aug 2, 2013)

  • New functionalities:
  • Added SQL error handling for Oracle database when compiling the source code.
  • Bug:
  • Fixed problem with Ajax processing in the Filter of Grid applications.
  • Fixed problem when synchronizing applications with the data dictionary.
  • Fixed an interface problem after performing Express Creation on Google Chrome.
  • Fixed problem when displaying detail records in a master detail.
  • Fixed problem in the link of document (database and file name) fields in the Grid application.

New in ScriptCase 7.1.001 (Aug 1, 2013)

  • Specific correction:
  • Fixed issue in the generation of applications according to the type of license.
  • Fixed serialize error during access to Scriptcase.

New in ScriptCase 7.1.000 (Jul 31, 2013)

  • New functionalities:
  • Added option in general settings of Scriptcase administration, for applications’ quantity to be compiled at the same time. (Threads)
  • Added Ajax support for grid applications.
  • Added toolbar customization tool of tools by the user in the configuration menu of Scriptcase.
  • Added friendly URL option in the project's Home area of applications’ list.
  • Added friendly URL option in general settings.
  • Added an option to use index in the project’s properties.
  • Added an option to create links to do query or sub charts (more than one field by group) in the abstract’s graphic settings.
  • Added configurable graph option to end user in the graphics’ settings summary.
  • Added option to request the password only once on the application security settings.
  • Bug:
  • Fixed issue in creating applications using special fields with PostgreSQL PDO.
  • Fixed problem in recovering SQL type with special fields using JOIN in PostgreSQL with PDO.
  • Fixed handling for application names with special characters. (, . + -)
  • Fixed problem when editing project with very large image.
  • Fixed issue in amending validate mask after changing the field type.
  • Fixed the data dictionary issue to synchronize the header summary.
  • Fixed problem in the description of summary’s aggregation.
  • Fixed issue in the implementation of a security module Scriptcase installed with SQL Server ODBC.
  • Fixed issue when using JOIN on tables with space on the SQL Server.
  • Fixed issue in fields’ types recovery using JOIN with PostgreSQL.
  • Fixed problem when updating date and time to a field in the editable grid (view) form without editing by modal.
  • Fixed problem when editing a record in the Grid Editable form (View) added in the security module.
  • Fixed problem when editing the security module languages.
  • Fixed issue with image or document (File Name) after updating a record, other records overwritten when updated.
  • Fixed broken characters in the wrong path message during conversion.
  • Fixed issue in special fields with lookup Analyzer.
  • Fixed issue in QuickSearch of master detail using numeric field as the key.
  • Fixed issue for required field in the PDF Report filter.
  • Fixed issue in the detail for “QuickSearch” in the master detail application.
  • Fixed non-existent record message on the choose form's record source.
  • Fixed log module’s language when changed from the security module.
  • Fixed interface to edit a project's language charset.Corrigido interface ao editar charset dos idiomas de um projeto.
  • Fixed individual treatment to the bank in the filter and in the query.
  • Fixed Group Label option on the abstract in the reloading of a query.
  • Fixed problem with modules’ reloading of grid‘s general configuration.
  • Fixed problem in deleting a GroupBy rule after update interface.
  • Fixed issue in Scriptcase administration log.
  • Fixed error when manually installing Scriptcase for MySQL 5.6.12.

New in ScriptCase 7.0.018 (Jul 12, 2013)

  • Bug:
  • Fixed problem in the chart label with SQL using alias.
  • Fixed problem in recovering the labels of fields with "_" (underscore) when the modal editing of a record from a Editable Grid (view) is enabled and the data dictionary is used.
  • Fixed issue in the option abbreviated value in the Column chart.
  • Fixed issue in to retrieve data from the database to the fields Image(filename) and Document (filename)

New in ScriptCase 7.0.017 (Jul 4, 2013)

  • Fixed handling fields with spaces and accent on the filter lookup.
  • Fixing problems in the Form-Grid link settings "Close the form after update" and "Close form after insert."
  • Fixed problem while cleaning application filter, when using a manual lookup on Checkbox field.
  • Fixed problem saving the filter using select fields with an accent.
  • Fixed issue when configured the title alignment as centralized.
  • Fixed problem in navigation of Form-Filter links.
  • Fixed issue in the forms exit URL.
  • Fixed problem on "Close form after inserting" setting on Form-Filter link.
  • Fixed Fatal error: Call to a member function inicializa_array on Group By, when using total for a calculated field.
  • Fixed issue of not keeping search criteria when getting back to filter.

New in ScriptCase 7.0.016 (Jun 21, 2013)

  • New functionalities:
  • Updates for all sample projects.
  • Added new license type: Small Business Micro Edition(MySQL, PostgreSQL, SQLite, Interbase, Firebird, MS Access).
  • Added new project language management interface.
  • Bug:
  • Fixed display issue in PDF Report applications when using a background on the records per line mode.
  • Fixed problem when using the macro sc_concat in auto-complete fields.
  • Fixed issue on 'Search Option' of auto-complete fields.
  • Fixed problem when using CONCAT in SQL command of auto-complete fields.
  • Fixed problem when using the sc_date_conv macro on run buttons with onRecord event.
  • Fixed problem with macro sc_set_global on menu applications.
  • Fixed problem in the Multiple Records Forms, to remove the insert button.
  • Fixed problem in treatment for the schemas names of the Log Module.
  • Fixed bug in record events when creating a log schema.
  • Fixed problem in the file directory Log Module Application.
  • Fixed problem in the application interface used in Log Module.
  • Fixed problem in the toolbar displaying projects with long names.
  • Fixed problem on automatic lookup for virtual fields in form applications.
  • Fixed problem in the Data Dictionary header synchronization.
  • Fixed issue in File Fields on PHP 5.2.
  • Fixed problem in Date Fields validation messages on filters.
  • Fixed issue when defining the initial value on multiple records and editable grid forms as zero.
  • Fixed nested grid misplacement when the "detail" option is removed.

New in ScriptCase 7.0.015 (Jun 7, 2013)

  • New functionalities:
  • Implemented autofilling the fields label when not informed during blocks creation.
  • Specific correction:
  • Fixed GroupBy issues when using TIMESTAMP colunms on Firebird.
  • Bug:
  • Fixed problem when defining "output URL" of tab applications.
  • Fixed description issue in the settings export of tab applications.
  • Fixed problem saving changes on "More properties" in the data dictionary.
  • Fixed issue when changing the data dictionary connection.
  • Fixed problem in table variables of generated applications.
  • Fixed problem in print window when using Google Chrome.
  • Fixed problem in QuickSearch filter when using a WHERE clause in form applications.

New in ScriptCase 7.0.014 (May 31, 2013)

  • New functionalities:
  • Added English column to the language editor for reference while editing other languages.
  • Added new language suggestion e-mail in the properties of the project.
  • Added an option in the bar chart for the data to be displayed inside or outside the bars.
  • Added the option in the bar chart for the data to be displayed horizontally or vertically.
  • Added the option in the bar chart to change the width of the bars. (Value must be between 20 and 70 pixels)
  • Added options "Both - Starting with analytic" and "Both - Starting with synthetic" in the graphics start settings.
  • Added new icons for language and data dictionary in ScriptCase toolbar.
  • Bug:
  • Fixed problem in the "back" button of a GroupBy Sumary, initiated by filter.
  • Corrected the description of the 'Table Variables' in global variables settings.
  • Fixed title of the summary chart settings.
  • Fixed the language variable in session when accessing a new project without closing the previous one.
  • Fixed error in Google Maps applications on Samples project.
  • Fixed bug in production environment folder while including files.
  • Fixed layout issue when the last block was configured to display the next one as a tab.

New in ScriptCase 7.0.013 (May 22, 2013)

  • New functionalities:
  • Update the Google Maps fields to API v3, no need to inform the API anymore.
  • Interface improvements on Grid applications' GroupBy.
  • Bug:
  • Corrected display of SQL type as "LONGLONG" for numeric fields of a sub-select with PDO MySQL driver.
  • Fixed error when creating applications in databases with no schemas on SQL Server Native SRV driver.
  • Fixed images and documents path in security module applications.
  • Fixed description of the option "Show folder in home" at My ScriptCase.
  • Fixed error when importing project Samples ScriptCase on "latin1" charset databases.
  • Removed authentication buttons in applications forms.

New in ScriptCase 7.0.012 (May 14, 2013)

  • New functionalities:
  • Added independant option for Database Builder on the ScriptCase's user permission settings.
  • Bug:
  • Fixed problem with Date virtual fields on German language during the database insert.
  • Fixed link problem in the abstract using special fields (spaces, accents, bars and dashes), applications query.
  • Fixed problem using the link in the summary fields in SQL ALIAS, applications query.
  • Fixed duplicate WebHelp button on the form when used in the application settings (HelpCase) and the toolbar.
  • Fixed bug in generated grid application when displaying Gantt charts button without it being configured.
  • Fixed display progress while image is loaded on Internet Explorer 9.
  • Fixed error when exporting PDF from an application query starting with charts when the "export" and "PDF" buttons is removed from the toolbar.
  • Fixed error when clicking on columns or sorting on a grid application starting with graphics.
  • Fixed handling using repeated name for a virtual field.
  • Fixed bug to include files in production environment's folder.
  • Fixed issue while saving "ScriptCase's manual lookups" on Select fields.

New in ScriptCase 7.0.011 (May 1, 2013)

  • Bug:
  • Fixed error when deleting a button named with the character '&' in the Grid, Form and Control applications.
  • Fixed issue in the option to not process HTML in the detail of the Grid application.
  • Fixed issue with the option "target" from URL fields in the Grid.
  • Fixed issue with HTML image field using Ajax event in the Grid application with filter disabled.
  • Fixed problem viewing the PDF from a Grid when it is starting by the Chart.
  • Fixed problem with the export of a Grid when it is starting by the Chart.

New in ScriptCase 7.0.010 (Apr 26, 2013)

  • Specific correction:
  • Fixed Javascript treatment in the grid applications.
  • Bug:
  • Fixed error when updating just one application item in the data dictionary settings.
  • Fixed SQL type retrieval on MySQL PDO connection.
  • Fixed issue on the application status when a library is edited.
  • Fixed problem in summary and chart on the exported PDF pagination.

New in ScriptCase 7.0.009 (Apr 23, 2013)

  • Specific correction:
  • Fixed javascript error when deleting Virtual Fields.
  • Fixed error when using functions with the sc_redir macro on libraries in a blank application.
  • Fixed error when using the sc_vl_extenso macro in a blank application.
  • Bug:
  • Fixed misplacement of sub-items of a menu item when using application security.
  • Fixed incorrect descriptions on the default Scriptcase setting values.
  • Fixed interface error after inserting an invalid project name.
  • Fixed error while displaying connections in detail of the projects administration.
  • Fixed license description "Support - Copper" in the help menu.

New in ScriptCase 7.0.008 (Apr 11, 2013)

  • New functionalities:
  • Added an option to edit the connection for application fields on the Express Edition.
  • Performance improvement:
  • Improved SQL error handling on application's source code generation.
  • Bug:
  • Fixed bug when using LDAP total control without the option of users logged.
  • Fixed error when using a Grid Application without GroupBy when "chart" is the initial module.
  • Fixed problem with line breaks on multiple lines text fields in a PDF Report subselect.

New in ScriptCase 7.0.007 (Apr 4, 2013)

  • New functionalities:
  • Added error handling for SQL Lookups on events, writing a log during code generation.
  • Specific correction:
  • Fixed download filename on document fields (Filename and Database) on IE 8, 9 and 10.
  • Fixed GroupBy fields parsing during conversion.
  • Bug:
  • Fixed "Invalid Template Name" message when clicking return in the Advanced Deployment.
  • Fixed export of a specific GroupBy when selected in the summary of Grid applications.
  • Fixed macro sc_label on horizontal forms. (Multiple records and Editable Grid)
  • Fixed macro sc_apl_conf in applications with security features enabled.
  • Fixed error when generating application form (single record) with Scriptcase registered only for the Microsoft Access database.
  • Fixed validation when creating a methood whose name are found inside the name of another preexisting method.

New in ScriptCase 7.0.006 (Mar 26, 2013)

  • New functionalities:
  • Added default values to width and height on image fields with multi-upload. 100x100
  • Added new option to the multi-upload field's interface "Show upload status as text or image".
  • Added new option to the multi-upload field's interface "Position of the delete under or beside".
  • Added new option to the multi-upload field's interface "Position above or below on the upload area".
  • Added new option to the multi-upload field's interface "Amount of columns to be displayed".
  • Added recognition of global variables in multi-upload fields.
  • Added recognition of SQL type after informing the table fields on multi-upload fields.
  • Added "Drag and Drop" area on file fields.
  • Added "Drag and Drop" options to the theme editor.
  • Specific correction:
  • Fixed handling tables with spaces and special characters on multi-upload fields.
  • Performance improvement:
  • Reduced time to generate applications.
  • Reduced Scriptcase installers' installation time.
  • Bug:
  • Fixed primary key recognition during link, when the table has unique key with more than one field.
  • Removed "Cancel" button on the first step to create a N-to-N relationship.
  • Added handling when deleting a folder, when the folder contains applications that are still open on the editor.
  • Corrected behavior when using the macro sc_menu_delete when there is sub-menu items.
  • Fixed option "Display link only " on Image (Database) fields with multi-upload settings.
  • Fixed issue in the summary link using alias on the group by field.
  • Fixed Quick Search problem on horizontal forms (Editable Grid and Multiple Record).
  • Fixed issue in sc_concat macro on SQL Server PDO connection.

New in ScriptCase 7.0.005 (Mar 12, 2013)

  • New functionalities:
  • Added support for lang variables in the default value of a lookup of grid applications.
  • Added support for variable langs in macro sc_label.
  • Specific correction:
  • Added PDO connections in the production environment for the MySQL, PostgreSQL and SQL Server databases.
  • The Multiupload feature was removed from control applications.
  • Performance improvement:
  • Improvements in SQL settings in the security module when deleting existents tables.
  • Bug:
  • Fixed problem on CSS settings of fields inside blocks with labels defined above and below.
  • Fixed PDF generation in Grids with Group By in Linux environment.
  • (Note: After the upgrade, check if the directory "scriptcase / prod / third / wkhtmltopdf" has full permission to execute. )
  • Fixed PDF generation Grids using Ajax events.
  • Fixed problem displaying charts set as analytic on the same page.
  • Fixed issue for recognition of variables used only in the title of the header of Form applications.
  • Fixed error when generating PDF with master-detail
  • Fixed issue resizing of images in the Image fields (database and file name) when uploading an image with the height and width sizes defined in the application.
  • Fixed multiline text field in the Detail from an editable grid when navigating.
  • Fixed problem with links in the summary using 3 Group By in a Grid with tabulation.
  • Fixed the helpcase issue when it was being exhibited the file name on the title when generated.

New in ScriptCase 7.0.004 (Mar 1, 2013)

  • New functionalities:
  • Added global variables support in applications titles.
  • Created new macro: sc_get_groupby_rule(). It provides the name of the "group by" rule used at runtime.
  • Added new "Abbreviated Values" option on charts configuration.
  • Bug:
  • Fixed issue in the generation of analytic charts.
  • Fixed problem in upload fields on Internet Explorer.

New in ScriptCase 7.0.003 (Feb 22, 2013)

  • Bug:
  • Fixed issue with the sc_set_global macro.
  • Ixed issue in the Auto complete fields of Filter applications with the Debug mode enabled.
  • Fixed issue with the sc_redir macro in onApplicationInit events.
  • Fixed issue with the installer for Linux.
  • Fixed issue to connect with Oracle. (check the documentation)

New in ScriptCase 7.0.002 (Feb 20, 2013)

  • New functionalities:
  • Sc_redir supported in ajax events.
  • Specific correction:
  • Fixed issue when using the Enter character (\ n) in the events of Buttons, when scriptcase is installed in mysql database.
  • Fixed issue when using the slash character ( \ ) in the events of scriptcase when it is installed using any PDO connection.
  • Performance improvement:
  • Documentation improvements. LDAP included.
  • Bug:
  • Fixed issue in the margin settings of a pdf export.
  • Fixed issue when saving the code written on the events of PDF Report.
  • Fixed the alignment issue on the connection screen in the production environment.
  • Fixed issue to display HTML Editor fields in an Editable Grid (view) Form.
  • Fixed issue when using the Enter character ( ) in the events of Buttons, when scriptcase is installed in mysql database.
  • Fixed the problem when validating the maximum and minimum inside the security module settings.

New in ScriptCase 7.0.001 (Feb 5, 2013)

  • Specific correction:
  • The Calculated Percent field was removed from PDF Report application.
  • Adjustments to align the home screen of the production environment on IE browser.
  • Fixed problem when deploying an Editable Grid View with the option to edit on a modal Single Record form.
  • Bug:
  • Fixed problem in the Scriptcase Installer to save interface changes when editing applications.

New in ScriptCase 6.0.039 (Nov 29, 2012)

  • Fixed the bug in the date formatting in the header when using Spanish, Albanian, Urdu and Chinese (Republic of China) Languages.
  • Fixed the problem on the textbox size of the Spin type of field.
  • Fixed the issue in the macro sc_apl_conf when navigating between records.
  • Fixed the bug in the fields ordering on the Grid detail.
  • Fixed the problem when performing a logout from Scritpcase.

New in ScriptCase 6.0.038 (Nov 9, 2012)

  • Performance improvement
  • Ajusts made on the Chinese, Hebrew and French Langs.
  • Bug
  • Fixed the syntax error while using GS1-128(EAN-128) Barcode.
  • Fixed the character accentuation issue in UTF-8 on Report PDF applications.

New in ScriptCase 6.0.037 (Nov 1, 2012)

  • Fixes on "Interleaved 2 of 5" Barcode's image.
  • Fixed the issue in the special filter condition "All Period" when the date field is marked as required.
  • Fixed issue, on "Edit fields" option, while selecting the "DB Value (Update)" of the fields in the "Fields not shown" section.
  • Fixed the issue in the display of the selected values as checkbox, in Editable Grid View forms.
  • Fixed the issue in filter's special conditions, when using "mmyyyy" formated date fields.

New in ScriptCase 6.0.036 (Oct 29, 2012)

  • Specific correction:
  • Fixed the issue when configuring mask on detail with the value "F/Y" on the groupBy date fields.
  • Removed the records per page button when using a editable grid or multiple registers form with total pagination.
  • Bug:
  • Fixed the issue on the auto-incremented primary key results on de Log Module.
  • Fixed the issue when visualizing images using total pagination and subdirectories on editable grid or multiple registers forms.
  • Fixed the problem when closing the window from the field "Html Color" after clicking in the OK button.
  • Fixed the error when enable the Label option in a "Card Type" field.
  • Fixed the duplicated error message on minimum-charecters-configured fields' validation
  • Fixed the issue on the visualization of capture link fields marked as Read-Only.
  • Fixed the issue in languages charset in button editor.

New in ScriptCase 6.0.035 (Oct 19, 2012)

  • Specific correction:
  • Corrected some Chinese and Japanese interface translation.
  • Bug:
  • Fixed the issue when using a text containing double quotes in the field's help settings.
  • Fixed the issue showing the fields on the ordering button used in the vertical and slide orientation Grid.

New in ScriptCase 6.0.034 (Oct 10, 2012)

  • New functionalities:
  • Implemented AJAX processing for select fields using the "Title" option.
  • Added Chinese Language (Republic of China).
  • Added new themes for Chinese, Japanese and Korean languages.
  • Bug:
  • Fixed the problem displaying the images of the menu item in Internet Explorer browser.
  • Fixed the problem recovering the Grid fields created from Stored Procedure in the creation interface.
  • Fixed the error message when creating a Grid Stored Procedure without parameter.
  • Fixed the option "Numbor of Character showing" in Nested Grids.
  • Fixed the problem connecting to a container application using the button Type of link.
  • Fixed the issue with macro sc_set_focus in forms editable Grid and Grid editable (view).
  • Fixed the error "Call to a member function Close()" when using methods in a Menu application.
  • Fixed the problem with the "Use a specifc Connection" in "N-N Relation" settings.
  • Fixed the Data Dictionary Link in express creation.
  • Fixed the formatting loss from date type of fields when used as capture link.
  • Fixed the problem while sorting applications of on the project homepage.
  • Fixed the problem in "Save As" button in templates editor.
  • Fixed the problem of fields lookup when using more than one condition in where clause.

New in ScriptCase 6.0.033 (Sep 21, 2012)

  • New functionalities:
  • Added sample projects for Firebird databases.
  • Implemented the "Validation Image" in the Multiple Lines Text.
  • Implemented the option for Image Capture showing only the selected records in the forms grideditável view.
  • Implemented display of the filter button in the summary details.
  • Specific correction:
  • Improved error message when publishing via FTP, if the server is unavailable.
  • Bug:
  • Fixed the validation for Double Select fields defined as required in filter application.
  • Fixed the "required field" message in Date type of fields after the date is selected from the calendar.
  • Fixed the field and tables recovering with hyphen in Progress database.
  • Fixed the retrieval of primary key in Generic ODBC connections.
  • Fixed the problem with group bys and lookups with long numbers. The reason was the comparison methood, a bug found in PHP 5.2 and 5.3
  • Fixed the view issues with records containing the "br" tag in grid applications.
  • Fixed the layout problem when using more than one connection on the nested grid.
  • Fixed the problem in the grid navigation using the Informix database
  • Fixed the problem displaying detail using fields with uppercase in Master/Detail forms.

New in ScriptCase 6.0.032 (Sep 5, 2012)

  • New functionalities:
  • Implemented the option to set a primary key field as read-only when creating a form.
  • Added new attributes to the N-N configuration.
  • Added the examples in the Oracle database.
  • Added the MSSQL ADO connection to the win 7 and vista environment.
  • Added the automatic dependencies recovery and foreign keys to access database.
  • Specific correction:
  • Fixed the processing of fields configured with slash ("/") in Access Database.
  • Fixed the issue when applying the filter to perform a search on date fields in Informix database.
  • Fixed the issue with composite key using date fields in Informix database.
  • Added the option to add a new calendar to a date type of field in filter applications.
  • Adjustments in the Linux installer.
  • Fixed the issue with auto update and online registration on MAC operating system.
  • Fixed the file permission problem in the zendid on MAC operating system.
  • Bug:
  • Fixed the error when using the macro sc_field_disabled inside methods.
  • Fixed the bug when using the option to show the number of pages in the footer of Report PDF applications.
  • Fixed the issue when synchronizing the form whet it has N-N relationship configured as a number.
  • Fixed the error when using ajax processing in editable grids.
  • Fixed the bug when using N-N relationship configured as checkbox.

New in ScriptCase 6.0.031 (Aug 17, 2012)

  • New functionalities:
  • Added the Access database in Scriptcase examples.
  • Performance improvement:
  • Adjustments in the copy button response time when it is clicked on Editable Grid Forms
  • Removed the copy button from a new line in Editable Grid Forms.
  • Bug:
  • Fixed the error message that was shown when you save the navigation options (Application-> Navigation) in control applications.
  • Fixed the validation problem on fields with multiple mask.
  • Fixed the problem exhibiting the "New" button when it was removed from the navigation buttons in Editable Grid Forms.
  • Ixed the visualization problem of the help lines in forms in Editable Grid Forms in addition mode.
  • Fixed the visualization problem of images in the menu application preview.
  • Fixed the visualization problem of the buttons in the edit theme interface.
  • Fixed the error "Invalid argument supplied for foreach" when creating a Google Maps field.
  • Fixed the problem with mysql client_encoding that support transaction.

New in ScriptCase 6.0.030 (Aug 8, 2012)

  • Specific correction:
  • Fixed the problem creating the Security Module using Informix Databases.
  • Fixed the problem creating the Log Module using Informix Databases.
  • Fixed the problem creating the Security Module using Oracle Databases.
  • Fixed the problem creating the Log Module in Oracle Databases.
  • Fixed the problem including and editing the images in Access Databases.
  • Bug:
  • Fixed the issues when creating a lookup definition with accented characters.
  • Fixed the problem changing the Label from the "export" Module in the Toolbar.
  • Fixed the bug viewing the calendar in the Log settings from Scriptcase Administration.
  • Fixed the problem saving the option of the "Exit Url" in tab applications.
  • Fixed the display problem in the "New" button in detail forms.
  • Fixed the problem when entering a character with accent on the events in run button.
  • Fixed the problem validating text fields AutoComplete fields.

New in ScriptCase 6.0.029 (Aug 3, 2012)

  • New functionalities:
  • Added the ADO connection type in Windows Seven and Windows Vista Operating Systems.
  • Added new option under application > navigation to display a confirmation message on the insert and update buttons.
  • Specific correction:
  • Fixed the table recovery of fields with spaces and accent on Access Database.
  • Bug:
  • Fixed the formatting problem in the Date/Time field selected from the calendar.
  • Fixed the problem on the menu preview of the menu items in the Linux browsers.
  • Fixed the problem in the form tabulations of the editable grid in Chrome browser.
  • Fixed the error when generating a query with and without vertical guidance to display the titles.
  • Fixed the error when configuring the detail query.
  • Fixed the problem saving the font size in the Bar Code field.
  • Fixed the problem copying the record newly written in Editable Grid forms.
  • Fixed issue in view of the currency symbols to navigate between records.

New in ScriptCase 6.0.028 (Jul 26, 2012)

  • New functionalities:
  • New option to upload images in the menu application.
  • Specific correction:
  • Fixed the bug in the path when importing the systems using the SQLite database.

New in ScriptCase 6.0.027 (Jul 25, 2012)

  • New functionalities:
  • It was Added at the created project exportation the option to select which database we want to export the tables.
  • Bug:
  • Fixed the problem when using the macro sc_concat at the fields lookup filter.
  • Fixed the problem Inserting a null value in date types of field on the Infomix Database.

New in ScriptCase 6.0.026 (Jul 21, 2012)

  • Specific correction:
  • Retrieving the mysql's client encoding.

New in ScriptCase 6.0.025 (Jul 20, 2012)

  • New functionalities:
  • Created new macro on grid, sc_field_init_off used at the onApplicationInit event, with the aim of inhibiting grid fields in the initial charge, leaving the same option available to select columns.
  • Created new options in the Collapse of the blocks in the grid, form, and filter may determine if the blocks start open or closed.
  • Created new option for the validation of file extensions fields type Documents and Images.
  • Created a new option to create a link between a grid and a form that extends what was filtered in the grid to the form.
  • Bug:
  • Fixed the error "Fatal error: Can not redeclare form_apl :: $ sc_field_11" in forms applications.
  • Fixed the error "Parse error: syntax error, unexpected T_STRING" in filter lookups.
  • Fixed the problem recovering the SQL type in grids.
  • Fixed the problem with the links in buttons using space.
  • Fixed the Uploading Subdirectory fields written with capital letters.
  • Fixed the validating the hour in DataTime fields.
  • Fixed the formatting problem in DataTime fields.
  • Fixed the issue with captcha on the production environment.
  • Removed the encryption from scriptcase libraries.
  • Fixed the problem when creating a button link.
  • Fixed the problem in the tabulation in the code editor.
  • Fixed the problem with data type "bytea" in postgres version 9.1.
  • Fixed data types in Mssql Server.
  • Fixed problem of multiplication on the calculator.

New in ScriptCase 6.0.024 (Jul 6, 2012)

  • Performance improvement:
  • Improved Documentation Informix Pdo.
  • Bug:
  • Fixed the "Parse error: syntax error, unexpected T_STRING ' when using fields with spaces in the lookup.
  • Fixed the problem recovering SQL type query using a sql with more than two tables in the Mssql Server.
  • Fixed the Pie charts title.
  • Fixed the problem using Word type of exports.
  • Fixed the issue showing date types of DATE, configured as Varchar.
  • Fixed the problem recovering SQL queries.

New in ScriptCase 6.0.023 (Jun 29, 2012)

  • New functionalities:
  • A new option when creating a link between a grid and a form that extends what was filtered in the grid to the form.
  • Bug:
  • Fixed the problem when creating applications with tables and fields with spaces, accents or hyphen.
  • Fixed the problem when deleting a connection in the production environment.
  • Fixed the connection problem when using special characters in the database password.
  • Fixed the issue reordering parameters inside methods.
  • Fixed the problem in the menus themes.

New in ScriptCase 6.0.022 (Jun 22, 2012)

  • New functionalities:
  • Added new button to hide the codes in the sample events.
  • Bug:
  • Fixed the error in the Advanced Deployment.
  • Fixed the problem in the library code editor.
  • Fixed the problem in the option "Close after insert" in a Modal application links.
  • Fixed the Invalid argument supplied for foreach () error, when saving the connection in a control application.
  • Fixed the problem in the Security Module on User and Application access level.
  • Fixed the problem in the option "Requires an activation e-mail" in the Security Module.
  • Fixed the problem when using the Timepicker option in time fields.
  • Fixed the button link through global variables.
  • Fixed the problem uploading an image in the Advanced Themes Settings.

New in ScriptCase 6.0.021 (Jun 14, 2012)

  • Bug:
  • Fixed problem when using field Image (File Name) in the application PDF Report.
  • Fixed problem in the CSS styles of buttons created.
  • Fixed problem in the items Double Select field the filter in the polls.
  • Fixed issue in view of the tag fields of type double and Select Checkbox GridEditavel in the forms.
  • Fixed problem when using buttons created with spaces.
  • Fixed problem in the documentation of macros.
  • Fixed the problem in the buttons layout.
  • Fixed the issue on the buttons exhibition when created with uppercase text.

New in ScriptCase 6.0.020 (Jun 6, 2012)

  • New functionalities:
  • Added support for multi-byte set of interface.
  • Specific correction:
  • Fixed problem in the extension of the Oracle installer.
  • Bug:
  • Fixed problem in automatic creation of the calendar application of the database Firebird.
  • Fixed problem in printing Html to open in more than one browser window.
  • Fixed problem displaying the description Autocomplete fields.
  • Fixed error when clicking on the links of the login application in the security module.
  • Fixed problem in fields Image / Document file name when using auto-increment fields to create the subdirectory.
  • Fixed problem of slowness in the creation of application in Postgres Database.

New in ScriptCase 6.0.019 (May 23, 2012)

  • New functionalities:
  • Added new filter conditions (18 and 24 months).
  • Specific correction:
  • Fixed problem in PDF export with java higher than 1.6.
  • Bug:
  • Fixed problem in Chrome browser to delete the directories of lang in languages​​.
  • Fixed problem in macro sc_add_line_tit.
  • Fixed when printing when using html fields onGroupByAll totalization.
  • Fixed problem Databases list the connections with other users on Mssql Server.
  • Fixed problem in applications generated using multibyte charset.
  • Fixed problem in view of the published captcha environments.

New in ScriptCase 6.0.018 (May 11, 2012)

  • New functionalities:
  • Added Onblur event in the Javascripts events.
  • Bug:
  • Fixed Error Undefined offset in lookup forms.
  • Fixed error in option Required in the filter on Report PDF application.
  • Fixed problem using single quotes in SQL special.
  • Fixed problem in aggregation values ​​in the Summary.
  • Fixed bug in Google Maps using two fields in the Geocode
  • Fixed problem when creating a new method from any event.

New in ScriptCase 6.0.017 (May 8, 2012)

  • New functionalities:
  • Added integrity in the security module for MySQL and Postgres databases.
  • Bug:
  • Fixed the problem when using the "All Day" in the calendar application.
  • Fixed the problem when using the sc_field_readonly macro.
  • Fixed the problem when using the sc_label and sc_field_readonly macro with accent.
  • Fixed the calendar lang component to other languages ​​in the filter.
  • Fixed the problem when adding or removing fields in grid application.
  • Fixed the problem when using the V5 and V6 prod in the same environment.

New in ScriptCase 6.0.016 (Apr 30, 2012)

  • New functionalities:
  • Included the option "Exit Application" in the navigation interface.
  • Bug:
  • Fixed problem when using the macro sc_appmenu_add_item target _parent.
  • Fixed bug in lookup of grids using orientation free format.
  • Fixed problem of Scroll Bar Menu applications.
  • Fixed error "Undefined offset" when exporting project.
  • Fixed Option to select the theme in the menu application.
  • Fixed problem in the lookup in the events in the menu application.
  • Fixed problem in vertical accent in the forms.

New in ScriptCase 6.0.015 (Apr 30, 2012)

  • Bug:
  • Fixed problem in the menu icons.

New in ScriptCase 6.0.014 (Apr 19, 2012)

  • New functionalities:
  • Added special conditions for the Date and time fields in Filter.
  • Created new option to use the background of the theme on menu.
  • Creating automatic application to view the Report of Log.
  • Bug:
  • Fixed problem Retrieve Password in the Security Module.
  • Fixed problem on the button New on the links.
  • Fixed problem in Insert Code in Editors using the Internet Explorer browser.
  • Fixed problem in creating log using other languages ​​in the interface.
  • Fixed problem in creating the Security Module and Log Module using the Firebird database.
  • Fixed problem in creating the Log Module using Oracle Database.
  • Fixed problem when using the macro sc_mail_send lang.
  • Fixed problem in view with the New button in the connections of application.
  • Fixed lang in the calendar component.
  • Fixed problem in the hint button created using Lang.
  • Fixed problem when using the sc_redir macro in the OnAplicationInit event in Menu.
  • Fixed problem when changing the order of menu items.
  • Fixed problem in Log Module for Databases that do not have transactions, ex.: Access.
  • Fixed problem in the menu title in WebHelp.

New in ScriptCase 6.0.013 (Apr 19, 2012)

  • Bug:
  • Fixed error in_array () expects parameter 2 to be array to perform backup

New in ScriptCase 6.0.012 (Apr 5, 2012)

  • New functionalities:
  • Added fields of application in the autocomplete of Editor.
  • Performance improvement
  • Improvement in the scriptcase Code Editor.
  • Bug:
  • Fixed problem when using langs in the Hint Menus.
  • Fixed problem in the alignment of treemenu items.
  • Fixed problem when using the field Update Link Table as Read-Only.

New in ScriptCase 6.0.011 (Apr 3, 2012)

  • New functionalities:
  • Added a New Project: sc_security.
  • Bug:
  • Fixed the error "Undefined variable: campos_analise" when creating control application.
  • Added the Backup/Restore option to the Log Module.

New in ScriptCase 6.0.010 (Mar 30, 2012)

  • Performance improvement:
  • From this release, the newly created projects will come with the language selected on ScriptCase login as default.
  • Bug:
  • Fixed issue when trying to to remove Required Fields on Filter.
  • Fixed issue with visualization of QuickSearch fields that have been removed from SQL.

New in ScriptCase 6.0.009 (Mar 30, 2012)

  • Fixed the problem accessing projects using the internet explorer.

New in ScriptCase 6.0.008 (Mar 28, 2012)

  • Performance improvement:
  • Improvement in the scrptcase Code Editor.
  • Bug:
  • Fixed the issue when changing the application's SQl Query.
  • Fixed the problem when adding any lang in the language configuration.
  • Fixed the problem in the control application when removing a field from the interface.
  • Fixed problem when using html editor field as readonly.
  • Fixed the incerface langs that was displayed as undefined.

New in ScriptCase 6.0.007 (Mar 28, 2012)

  • Fixed the problem with global variables in the application's footer

New in ScriptCase 6.0.006 (Mar 23, 2012)

  • Specific correction:
  • Fixed the incompatibility problem with Firefox version 11.
  • Performance improvement:
  • Improvement in the scrptcase Code Editor

New in ScriptCase 6.0.005 (Mar 22, 2012)

  • Specific correction:
  • Fixed the problem with the Firebird extension with PHP 5.3.
  • Bug:
  • Fixed the lang calendar component to other languages.
  • Fixed the problem of not showing the COPY button on the iframe property using an application links.
  • Fixed the sc_redir macro being used on the OnApplicationInit event.
  • Fixed the issue with the block's high.
  • Fixed the usage of fields with blank space with ajax events.
  • Fixed the grid problem when we have only a google maps on the application.
  • Fixed problem with menu in Internet Explorer when used events Javascript events.

New in ScriptCase 6.0.004 (Mar 22, 2012)

  • Bug:
  • Menu application, fixed item 'Show items even when there' when the applications are using security.
  • Fixed error when trying to view the application's global variables.
  • Security module, fixed problem when using pre-existing tables.

New in ScriptCase 6.0.003 (Feb 16, 2012)

  • Bug:
  • Fixed the problem when using events in the fields with blank spaces.
  • Fixed the problem with navigation when we remove some toolbar buttons.
  • Fixed the formatting problem in the calendar using other languages​​.
  • Fixed the problem generatiing the Security Module when the Log module is selected.
  • Fixed the problem on ajax event in date type of field.
  • Fixed the problem on displaying records using N-N relations.

New in ScriptCase 6.0.002 (Feb 10, 2012)

  • Specific correction:
  • Fixed problem in the Security Module languages.
  • Bug:
  • Fixed crash in the Report PDF Orientation.
  • Fixed error when saving the codes inside the event on the Run button.
  • Fixed Default Values ​​Screen Directors bug.
  • Fixed global variables treatment.

New in ScriptCase 6.0.001 (Feb 7, 2012)

  • Database Builder:
  • Web based database management tool that allows to create, update and remove sql tables for the following databases: MySQL, PostgreSQL, SQLite, MS SQL, Oracle.
  • New log modulo:
  • The log module stores in the database all actions done by the end-user in the developed applications, it can be used in the following levels:
  • Access level, it will store on the database each time someone access the application.
  • Stores the form functions: Insert, update and delete.
  • Stores the following information: User, IP, date and time, and the updated data.
  • Scriptcase will create the log tables automatically.
  • More complete security module:
  • The security module can be created in three different levels: User; User and application; User group and application.
  • It will create automatically a few applications together with the database tables.
  • The module will also control if the user can insert, update and/or delete records in the selected forms.
  • The module will control the access, exports and print of all applications of the project.
  • It will allow the users to access through a pre-registration form unlocking the login only through e-mail.
  • Automatic password recovery.
  • New Options and Features Form:
  • Quick search option available in the toolbar.
  • Option to sort columns by clicking on it.
  • Display summary with the amount of records and displayed records.
  • Display number of pages making the navigation easier.
  • "Go to" option. It allows to go straight to a specific record or page.
  • Option to specify the number of records per page using a dropdown list (combobox).
  • Option to create grouped labels for the fields.
  • Option to determine the fields that will be displayed in inclusion and / or update mode.
  • The copy button. Now there is an option to clone records of a form.
  • Automatic identification in the forms:
  • Recognition of unique indexes - Creating automatic validation if the field is required in the form.
  • Recognition of foreign key - It will create the validation automatically and the automatic lookup on the field
  • Recognition of "not null" fields by assigning it as required automatically.
  • Grid/Filters and Charts:
  • New field type: QR Code (barcode on 2D).
  • Display number of pages making the navigation easier.
  • "Go to" option. It allows to go straight to a specific record or page.
  • Option to specify the number of records per page using a dropdown list (combobox).
  • Gantt chart configured directly in the application interface.
  • New option to export the Grid records in DOC extension type.
  • Validation of required fields in the filter.
  • New interface to configure the charts.
  • New chart types: Pyramid, Cone, Funnel, Gauge, Radar, and Polar.
  • New Fields and updates in the form:
  • New field type: Spin.
  • Combobox with multiple-choice (checkbox).
  • Editable combobox.
  • jQuery calendar.
  • jQuery calculator running in normal and scientific mode.
  • New palette color.
  • Horizontal Menu:
  • Refurbished menu using CSS and no javascript.
  • New interface to select the applications that will be in the menu.
  • New images to use as icons.
  • TREE MENU:
  • New component using more CSS and less javascript.
  • New interface view settinbgs
  • New theme editor, working in two modes: simple and advanced.
  • New buttons editor, it allows you to merge text with CSS images.
  • New interface to view and edit the header, the footer and free format (templates).
  • General Implementations:
  • Now scriptcase will accept table names and fields with spaces, cedillas, accents and special caracters. These names can be manipulated in the scriptcase events.
  • Support for multi-byte characters (UTF-8, Chinese, Japanese, etc.) in tables names and fields, these names can be manipulated in the events.
  • Changes in the generated applications toolbar migrating all buttons to CSS.
  • New option to "group buttons" in a single button, working as a menu.
  • New events editor with a better performance and Macros autocomplete.
  • Changes in the production environment libraries.
  • New exclusive themes.
  • New Environment Scriptcase:
  • Full support for PHP 5.3 and above.
  • Scriptcase - Performance:
  • Speed enhancement at the simple application creation and batch express creation.
  • Significant improvements at the source code generation time.
  • New interface Scriptcase:
  • Create application screen got unified becoming more intuitive and simple.
  • New option to display projects more detailed.
  • New application interface display more intuitive and practical.
  • Stylisation of the toolbar buttons improving usability.
  • Option to deploy an application when we are editing it.

New in ScriptCase 5.2.041 (Nov 22, 2011)

  • Performance improvement:
  • Improved the Documentation.
  • Bug:
  • Fixed the failure when Generate the HelpCase.
  • Fixed the Sorting problem in Forms with orientation: Multiple record, Editable Grid, Editable Grid(View).

New in ScriptCase 5.2.040 (Oct 20, 2011)

  • New functionalities:
  • Added support to keywords of databases MySQL, Postgres, Mssql Server and SQLite
  • Specific correction:
  • Improved Documentation
  • Bug:
  • Fixed the problem when Editing the SQL of Report PDF.
  • Fixed the problem of detail in a Grid App when using the Language option.

New in ScriptCase 5.2.039 (Sep 15, 2011)

  • Specific correction:
  • Fixed error in the creation of applications to use the language Switzerland.
  • Bug:
  • Fixed problem in link field using the property Iframe.
  • Fixed problem when using the expression in the SQL UNION in Grid.
  • Fixed bug when using fields created, document or image file name, in the forms.

New in ScriptCase 5.2.038 (Sep 2, 2011)

  • New functionalities:
  • Add new system "Training Sample".
  • Specific correction:
  • Fixed the problem when using the Auto-Complete in Internet Explorer 9 Browser.
  • Bug:
  • Fixed the problem when Editing the SQL of the Grid Application
  • Fixed the problem in Security Module when using tables with Upper Case.

New in ScriptCase 5.2.037 (Aug 19, 2011)

  • Performance improvement:
  • Improved the performace connections in production environments where it has more than one connection. From this version and so on you must update the production environment.
  • Bug:
  • Fixes in a PDF Report using Slovak characters.
  • Fixed error when the expression is used CONCAT (REPEAT ("0", 20 - LENGTH (field)), field) in the MySQL database.

New in ScriptCase 5.2.036 (Aug 18, 2011)

  • Bug:
  • Fixed the problem with macro sc_link, when using the parameters Target iframe.
  • Fixed the problem in database Oracle and Postgres, when the input year of the Date field in the Filter wasn't informed.

New in ScriptCase 5.2.035 (Aug 18, 2011)

  • Specific correction:
  • Improvements in the Languages English(US), Italian and French.
  • Bug:
  • Fixed the problem in Security Module, when using the encryption Md5 in Update of the form "form_tb_users".

New in ScriptCase 5.2.034 (Aug 18, 2011)

  • Bug:
  • Fixed the problem when using the value NEWID for MS SQL Server database.

New in ScriptCase 5.2.033 (Aug 18, 2011)

  • Bug:
  • Fixed problem in encrypting files.

New in ScriptCase 5.2.032 (Aug 18, 2011)

  • Specific correction:
  • Improvements in the Languages German, English(US), Spanish, Italian, French and Indonesian.
  • Bug:
  • Fixed the problem in Links field type in the Summary.
  • Fixed the problem in field type Document(Database), in grid app for MS SQL Server Database.

New in ScriptCase 5.2.031 (Aug 18, 2011)

  • Bug:
  • Fixed the problem with Group By when using Date in databases MS SQL Server, Postgres and Sybase.
  • Fixed the problem in Grid detail, when the same has one link with iframe to a form.
  • Fixed the lost problem of navigation of the button print, when choose the option Complete Report.

New in ScriptCase 5.2.030 (Aug 18, 2011)

  • Bug:
  • Fixed the Sorting of the fields when used the CONCAT in the SQL Statement of grid apps.
  • Fixed the error in the Field Documents for database Ms Sql Server.
  • Fixed the Error undefined constant NM_APP_TYPE URL with the Links to the application Container.
  • Fixed the failure in the Summary, when using the condition WHERE in the Grid Lookup.
  • Fixed the Menu of a grid app created from one Stored Procedure in MS SQL Server.

New in ScriptCase 5.2.029 (Aug 18, 2011)

  • Specific correction:
  • Improvements in the Languages German, English(US), Spanish, Italian and French
  • Fixed the problem with Systems HelpDesk and Online Shopping the Examples.
  • Bug:
  • Fixed the visualization problem of the negative symbol in Summary totalization, when using the Regional Settings to "No".
  • Fixed the visualization problem of the Records, when using the Total pagination with Group By.

New in ScriptCase 5.2.028 (Jun 30, 2011)

  • Specific correction:
  • Improvements in Languages French and German.
  • Bug:
  • Fixed the problem of project's charset, when select the languages.
  • Fixed the problem in visualize the Image of an app.

New in ScriptCase 5.2.027 (Jun 30, 2011)

  • Specific correction:
  • Improvements in Languages French and Russian.
  • Bug:
  • Fixed the password problem in Security Module in apps with link.
  • Fixed the problem with Google Maps in grid apps with User Defined orientation.
  • Fixed the problem when using Schemas and Languages buttons in the Toolbar in Filter app, configuring from the iframe.

New in ScriptCase 5.2.026 (Jun 30, 2011)

  • Specific correction:
  • Improvements in Languages, Italian and German. Added new languages Punjabi.
  • Bug:
  • Fixed the proble when using Modal link type on the Internet Explorer browser when the registers had accent.
  • Fixed the line break problem in Multiple Lines Text Field.

New in ScriptCase 5.2.025 (Jun 30, 2011)

  • Specific correction:
  • Added new languages Marathi, Telugu and Kannada.
  • Added the option in Interface Size Maximo Email fields.
  • Bug:
  • Fixed the problem when using the Google Maps in Form(Multiple Record, Editable Grid and Editable Grid(View)).
  • Fixed the problem when using messages in Languages in field "Menu Links"
  • Fixed the problem of losing Code in the Methods, by ordering the parameters of the method in the interface.

New in ScriptCase 5.2.024 (Jun 30, 2011)

  • Specific correction:
  • Improvements in Languages, Italian, Japanese , German and Turkish.

New in ScriptCase 5.2.023 (Jun 30, 2011)

  • Specific correction:
  • Improvements in Languages German, English (US), Japanese and Hindi.
  • Added new languages Urdu and Bengali.
  • Bug:
  • Fixed the exhibition problem in Field type Document and Image, in Form Editable Grid and Editable Grid(View).
  • Fixed the error exhibition problem when using the sc_error_message macro in Filter application, configured from the iframe.

New in ScriptCase 5.2.022 (Jun 30, 2011)

  • New functionalities:
  • Improvements in Languages, Italian, Japanese , Spanish and Turkish. Created a new Flag "Edit database as combobox" in Settings screen.
  • Specific correction:
  • Improvements in Languages, Italian, Japanese , Spanish and Turkish.
  • Bug:
  • Fixed the sc_btn_display macro with created buttons.

New in ScriptCase 5.2.021 (Jun 30, 2011)

  • Specific correction:
  • Improvements in the Languages English, Spanish, French, Thai and Indonesian.
  • Fixed the label problem in the Graph, when the table fields were in Upper Case.
  • Fixed the Test Connection problem when the database have several tables.

New in ScriptCase 5.2.020 (Jun 30, 2011)

  • Specific correction:
  • Fixed the data type Blob problem in Access database connection.
  • Fixed the problem when using the Ajax Events in created fields, when take off the primary key from the Interface.
  • Fixed the exhibition problem in Group By with some Linux environment.

New in ScriptCase 5.2.019 (Jun 30, 2011)

  • New functionalities:
  • Added the recovery in automatic way of the Auto-Increment field in Access database.
  • Added the recovery in automatic way of the Decimal field in Access database.
  • Added the recovery in automatic way of the Decimal field in Oracle database.
  • Bug:
  • Fixed the problem in Typing the field Multiple Lines Text in Internet Explorer

New in ScriptCase 5.2.018 (May 20, 2011)

  • New functionalities:
  • Added the recovery of the fields Date selected as Not Null in Access database. From this version the fields will come as Required.
  • Improvement the values automation of the Unique Indexes (Unique Key). From this version the Indexes will recovery in automatic way for Access database.
  • Specific correction:
  • Fixed the failure in the recovery of the Primary Key in Access ODBC connection.
  • Fixed the problem in Application creation, if the user informed doesn't have the privilege as Admin in Oracle connection.
  • Fixed the problem retrieving the Sequential in Firebird version 1.5
  • Bug:
  • Fixed the error: Fatal error: Call to undefined function nm_error_handler() in \scriptcase\devel\lib\php\database.inc.php grid application.

New in ScriptCase 5.2.017 (May 20, 2011)

  • Bug:
  • Fixed "XML - UTF-8" error when using the special characters in the grid lookup of the Grid Applicaton.
  • Fixed the error in Recovering the Charset of the Project.

New in ScriptCase 5.2.016 (May 20, 2011)

  • New functionalities:
  • Added the recovery of fields Date selected as Not Null in Sybase. From this version the fields Date will come as Required.
  • Improved automation of values ​​Unique Indexes (Unique Key), from this version the Indexes will be retrieved automatically for the Sybase database.
  • Added the recovery in automatic way, of the fields auto-increment in Sybase database.
  • Specific correction:
  • Fixed the visualization of the field "Title", in a calendar application, if use the lookup.
  • Fixed the problem in Exit Button of the calendar application, when the application was called from the tab application the button wasn't appeared.
  • Fixed the problem with field UNIQUEIDENTIFIER , when used as Primary Key.
  • Bug:
  • Fixed the upload problem in field type Document(File Name)
  • Fixed the problem in Ajax events, when using the macro sc_lookup.
  • Fixed the the connection failed in SQLite database.
  • Fixed the ERROR "Invalid argument supplied for foreach()" in a grid applications.
  • Fixed the problem with recovery of fields in DB2 database.

New in ScriptCase 5.2.015 (Apr 29, 2011)

  • New functionalities:
  • Added the recovery of the Date field selected as Not Null in Oracle. From this version the Date fields will come as Required
  • Performance improvement:
  • Improvements in values automatization Unique Indexes(Unique Key), from this version the indexes will be recovered in automatic way for Oracle Database
  • Improvements in Error Messages in SQL Statments
  • Bug:
  • Fixed the problem when testing the connection using the MySQL 4.0

New in ScriptCase 5.2.014 (Apr 22, 2011)

  • Fixed problem in data dictionary when using schemes (Postgres connection).
  • Fixed bug when using a table from a schema existing one table with the same name in another schema (SQL Server).

New in ScriptCase 5.00.0007 (Mar 12, 2010)

  • New functionalities:
  • Implemented client encoding on Oracle connection.
  • Implemented sorting and Positioning Summary
  • Specific correction:
  • Fixed problem of internal format on different fields DateTime (Datetime2 and SmallDateTime) with the Driver SQL Server Native (SRV)
  • Fixed validation issue on datetime and smalldatetime dates types on SQL Server 2008
  • Fixed Output Window display problem on Editable Grid and Editable Grid (View) Forms.
  • Adjusted Capture button display when the field is ReadOnly.
  • Fixed problem with formatting of date fields in the headers.
  • Corrected button image display in the Links.
  • Corrected global variables in grids' header and Form.
  • Fixed CSS in the grids blocks.
  • Removed Chart Configure button displayed in generated chart.
  • Fixed problem in language in Spanish.
  • Bug:
  • Fixed macro sc_redir events on Editable Grid Form
  • Fixed macro sc_master_value in master-detail forms.

New in ScriptCase 5.00.0006 (Mar 12, 2010)

  • Specific correction:
  • Adjustments in the data types recovery and SQL Server 2008 properties
  • Fixed field type subselect creation ReportPDF aplications with sensitive tables
  • Fixed problem in the link, with closing the form after update option
  • Fixed problem with macro sc_btn_display in created buttons type image
  • Correction of characters coding in forms labels of relationship NxN
  • Correction of macro sc_label operation in grid aplications using languages
  • Fixed option Text between values in fields type currency in search forms
  • Fixed creating link in autocomplete fields problem
  • Fixed marking checkbox after ajax processing in multiple record forms problem
  • Correction of search from a menu not reseting the previous condition "WHERE"
  • Correction of Treeview Button display in grids
  • Correction of test connection message in the Chrome browser
  • Fixed the issue with quotes in Text field
  • Correction of session in database in development and published applications problem
  • Bug:
  • Fixed the encoding problem when installing ScriptCase on PostgreSQL
  • Fixed deploying using FTP

New in ScriptCase 5.00.0005 (Mar 12, 2010)

  • New functionalities:
  • Implemented option for forms of multiple records, change and delete records together. (similar to Scriptcase V4).
  • Implemented the option to link the capture, the format modal, for filter applications.
  • Implemented client encoding on Postgres connection.
  • Specific correction:
  • Fixed Wizard to create applications with Stored Procedure
  • Fixed Control applications OnValidate event execution for ScriptCase validation
  • Fixed DateTime field as primary key
  • Fixed grid applications font size in CSS message "No records to display"
  • Fixed modal link capture search fields
  • Fixed grids´ details positioning
  • Fixed double select manual - select all button
  • Fixed CEP with accents using caps
  • Fixed Editable Grid (view) form checkbox fields values retrieval
  • Fixed "Close the form after an update" modal link on search application with form application
  • Fixed control applications OK button shortcut key
  • Fixed macro sc_btn_display, user-created and applications´ buttons
  • Fixed URL fields enabled as label
  • Fixed select command field sum (SUM) and groupby SQL Server Native Driver ( SRV)

New in ScriptCase 5.00.0004 (Mar 12, 2010)

  • Specific correction:
  • Fixed required data entry issue displaying asterisk and message in single form
  • Fixed macro sc_btn_display not working with the OK button for control
  • Fixed required data entry for double select problem
  • Fixed the macros to create dynamic menus
  • Adjusted building applications issue

New in ScriptCase 5.00.0003 (Mar 12, 2010)

  • New functionalities:
  • Icon for numeric fields in applications´ edition (implementation)
  • Specific correction:
  • Macro sc_btn_display for created buttons correction
  • Fixed cancel connection to the database message
  • Fixed the form source code generation in JavaScript edition
  • Fixed created buttons display mode (inclusion and edition)
  • Fixed dependency on form with file (database) data type
  • Fixed imported project, where it was not associated with logged in user
  • Fixed text with multiple lines field icon used in application edition
  • Fixed the auto-complete fields with where clause in query
  • Correction in assigning null value in the option Assign Values
  • Fixed words´ display in Select Fields, Required fields in Chrome browser
  • Fixed Summary configuration when lines number was set and it did not break down
  • Correction on the forms that used the image being called within an application menu, where a picture is deleted but was still displayed
  • Correction on the scroll bar displayed at multiple applications generation
  • Incorrect navigation correction when adding a new method in application being edited