Krita

What's new in this version:

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

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


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

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


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


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


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


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


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

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


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


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


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


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

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


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

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


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

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


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

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

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


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

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


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


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

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


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

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


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

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


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


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


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


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


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


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

Fixed:
- Fixed problem with the "Save in session" option in the "Persist State" button
- Fixed problem with "language" field of applications, after creating batch applications, and project with only one language selected
- Fixed problem with loss of default values, in manual lookup of radio and checkbox type fields, when clearing state of advanced grid search
- Fixed problem when defining font size and tab color of form pages
- Fixed problem when performing column ordering in forms with horizontal orientations
- Fixed problem in the visualization of themes during project creation
- Fixed problem when canceling duplicate files in the internal library


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

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


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


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


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


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

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

Fixed:
- Fixed problem with corrupted file when downloading in document fields (file name) in the query
- Fixed problem when entering the value 0 in decimal field and the currency configured to display three characters
- Fixed problem in the inclusion of a comma in values ​​beginning with zero, in decimal and currency fields
- Fixed problem in displaying records after using a PHP button in a form editable grid view
- Fixed problem with the "Exit" button when defining the initial menu application using a global variable


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


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


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

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


ScriptCase 9.6.001 (64-bit)
- Added reload button on the dashboard toolbar
- Added SweetAlert option in the HTML control application interface
- Note: SweetAlert will only work if the scDisplayUserError() Javascript function is not being used
- Added new security options in the HTML control application

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

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

Fixed:
- Fixed problem when returning to the current record after redirection using the sc_redir macro
- Fixed problem when using Image type field (file name) in multiple record and editable grid forms
- Fixed "Undefined" error when expanding or collapsing events in the calendar application
- Fixed "Undefined" error when changing time of calendar events in the display by day
- Fixed problem in the "submit" of the HTML control application in Chrome browser. The form was submitted twice, causing an error in the validation of the login, with the message "Unauthorized user"
- Fixed problem with character validation when naming new themes for charts
- Fixed problem with the use of fields in horizontal forms after the toast of Sweet Alert was displayed
- Fixed problem when saving changes to the summary, in the project's default values
- Fixed problem when saving changes to the summary, in the project's default values
- Fixed problem when using Checkbox in dropdown with editable grid (view) orientation
- Fixed error when using dynamic filter in chart applications
- Fixed column alignment problem in summary breaks in the grid application
- Fixed problem when saving grid summary using fixed columns
- Fixed fopen error "(_lib / lib / js / GoJS.js): failed to open stream: No such file or directory" in menu applications


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

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

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


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

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


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

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


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


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


ScriptCase 9.4.032 (64-bit)
- Documentation improvements


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

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


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

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


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


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

Improved:
- Improved interface for creating projects

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


ScriptCase 9.4.000 (64-bit)

New functionalities:
- 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


ScriptCase 9.3.012 (64-bit)

New functionalities:
- 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


ScriptCase 9.3.011 (64-bit)

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


ScriptCase 9.3.010 (64-bit)

New functionalities:
- 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


ScriptCase 9.3.009 (64-bit)

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


ScriptCase 9.3.008 (64-bit)

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


ScriptCase 9.3.007 (64-bit)

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


ScriptCase 9.3.006 (64-bit)

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


ScriptCase 9.3.005 (64-bit)

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


ScriptCase 9.3.004 (64-bit)

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


ScriptCase 9.3.003 (64-bit)
- 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


ScriptCase 9.3.002 (64-bit)
- Fixed problem when saving fields in the interface, using the Spanish language


ScriptCase 9.3.000 (64-bit)

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


ScriptCase 9.2.016 (64-bit)

New functionalities:
- Added support for Jsmind, JKanban, and Orgchart components in the sc_i