UltraEdit (64-bit)

What's new in this version:

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_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


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


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


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


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


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


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


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


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


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


ScriptCase 9.2.006 (64-bit)

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

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


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


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


ScriptCase 9.2.003 (64-bit)

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


ScriptCase 9.2.002 (64-bit)

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


ScriptCase 9.2.001 (64-bit)

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


ScriptCase 9.2.000 (64-bit)

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


ScriptCase 9.1.009 (64-bit)
- Fixed issue using special conditions in date fields, in filter


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


ScriptCase 9.1.007 (64-bit)
- Fixed problem when using sc_redir macro in blank applications


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


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


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


ScriptCase 9.1.002 (64-bit)

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

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


ScriptCase 9.1.001 (64-bit)

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


ScriptCase 9.1.000 (64-bit)

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


ScriptCase 9.0.043 (64-bit)

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


ScriptCase 9.0.042 (64-bit)

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


ScriptCase 9.0.041 (64-bit)

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


ScriptCase 9.0.040 (64-bit)

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 Progres