Windows PowerShell (64-bit)

What's new in this version:

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 Progress

Bug:
- Fixed issue using the CONCAT command in the Grid lookup
- Fixed bug when using the "Arial" font in the Reportpdf application
- Fixed issue in Chart filter view when exporting to pdf


ScriptCase 9.0.039 (64-bit)

Specific correction:
- Fixed issue in updating the values in the lookup type of multiple binary values
- Fixed issue in the field tab "date" in the Filter using the range condition
- Fixed issue when using SQL UNION in autocomplete fields

Performance improvement:
- Improved performance in the "date" field searches on MSSQL Server connections

Bug:
- Fixed issue with “Filter Saving” using "double select" field type
- Corrected issue with "Filter Saving", when the Grid had Group by using data type fields
- Fixed issue when saving theme in Charts, in Scriptcase versions that were installed with Mysql
- Fixed issue in ajax events of the Grid when using full pagination. Before that, the event was only created in the first 10 records
- Fixed issue in Filter search with negative values
- Fixed issue in character display in Summary Filter using charset windows-1255 (Hebrew)
- Fixed issue using the CONCAT command in the Grid lookup


ScriptCase 9.0.038 (64-bit)

- Adjustments in the display of the Chart application and Summary Filter buttons

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


ScriptCase 9.0.037 (64-bit)
Specific correction:
- Fixed issue when using parentheses at the "hint" parameter in the sc_link macro
- Fixed issue when using the "sc_label" macro in fields that use language variables, generated by the data dictionary in Grid applications
- Fixed issue in the display of the "docx" extension icon, when using the "Display the file type icon" option in the document fields of the Grid application
- Corrected height in the checkbox by clicking multiselect of the refined filter

Performance improvement:
- Improved performance in Summary applications
- Improved performance in field data searches on Postgres connections


ScriptCase 9.0.036 (64-bit)

New functionalities:
- Added support for global variables through the new macro "sc_make_link"
- Added new options under summary and charts filters

Specific correction:
- Fixed problem in the table creator interface for calendar applications with an Access connection
- Fixed problem with the format of time values in the backup filenames
- When using an Editable Grid (View) form, File Upload fields now can only be downloaded on lines that are in editing mode

Performance improvement:
- Improvement of performance of autocomplete fields on a filter

Bug:
- Fixed problem with the images and templates copied while migrating from version 7 to 9
- Fixed problem with the images and templates copied while migrating from version 6 to 9
- Fixed problem that could corrupt GroupBy data while migrating from version 6 to 9
- Fixed issue in version 5 to 9 migration
- Fixed problem when using sc_redir in a PHP method called from a PHP button


ScriptCase 9.0.035 (64-bit)
Specific correction:
- Fixed issue in returning a connection when we use the sc_select (where) macro in the source application
- Fixed issue when running the application "Dashboard" in the interface's initial mode
- Fixed issue in view of field view lookup when condition had dot
- Fixed problem of accentuation in the label of the macro button "sc_ajax_message", when using charset other than UTF-8
- Corrected spacing of the navigation buttons being displayed below

Bug:
- Corrected issue in displaying the values of the field "Data" in the interface of the Group By. You will need to clear your browser's cache
- Fixed special SQL error in Grid Application
- Fixed anchor of the menu link in the documentation


ScriptCase 9.0.034 (64-bit)
New functionalities:
- Added lang support in the sc_alert macro. Ex: sc_alert ({lang_btns_ajax})
- Enabled the image and document database fields in the Grid columns interface
- Enabled the examples in the onScriptInit event of the Grid

Specific correction:
- Fixed validation of values in the interface of version incrementation
- Fixed issue in the events help link
- Fixed issue in searching for Dynamic Search with data type "TIMESTAMP WITH LOCAL TIMEZONE"
- Corrected issue in viewing the refined filter values, after returning from Summary Group by links
- Fixed issue in hint viewing on field links using Sc7_Black theme

Bug:
- Fixed issue Tab_lig_apls is not defined in Grid links called through the Menu
- Fixed issue in the display of the "delete" button when canceling the edition of record in the Grid view editable Form
- Fixed "Array to string conversion" error when using the sc_mail_send macro
- Fixed issue when generating a free format Grid without the toolbar buttons


ScriptCase 9.0.033 (64-bit)
New functionalities:
- Added RTL language support in the Summary filter

Specific correction:
- Fixed Grid export issue when using macros "sc_seq_register" and "count_ger" in the OnRecord event
- Fixed macro help link in events

Bug:
- Fixed issue in Chart display in pdf export
- Fixed issue in NestedGrid type links


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


ScriptCase 9.0.031 (64-bit)
New functionalities:
- Added new values ​​in the "negative currency format" option in the total fields of the summary
- Added grid navigation configuration support from master / detail
- Added support for YEAR fields
- Added support for Nested Grids in Grid details
- Implemented support to macro "sc_format_num" in the onrecord event of the grid, using summary fields
- Added "port" option in SFTP publishing settings
- Added port data entry for DB2 connection

Specific correction:
- Fixed issue when converting Access tables that have images
- Fixed issue in the initial execution of pyramid and 2D funnel charts
- Fixed issue when using subselect command in field lookup
- Fixed issue when running operations directly in the application's SQL
- Fixed issue using "Use ENTER to Submit" option in dynamic filter settings
- Adjustments in the Nested Grid css when using the title option on the same row
- Fixed issue in view of the buttons size on the iframe type connections

Bug:
- Fixed issue in viewing the records in the calendar by checking the option "all day". The schedule showed less 1 day
- Fixed issue in formatting millisecond fields
- Fixed duplicate data insertion problem with dynamic search
- Fixed issue when using the database session option in the post
- Fixed issue in viewing calendar time on Oracle connections
- Fixed issue in the Themes view of the tree menu. The tree menu was not inheriting the Themes css
- Fixed Fatal error: Uncaught Error: Call a member function Execute () when using the sc_lookup macro in the ReportPdf application onHeader event
- Fixed issue in the informed value of the negative field of manual lookup of the multiple selection fields
- Fixed issue in viewing calendar records on Access database connections
- Fixed issue when using the menu toolbar with image type buttons
- Fixed issue when using link button in Editable Grid Form (view)
- Fixed issue in pdf export when printing mode was configured for economic


ScriptCase 9.0.030 (64-bit)
New functionalities:
- Added macro support "sc_format_num" in the onrecord event of the grid

Specific correction:
- Adjustment in error display when editing multi-upload fields
- Fixed issue in gantt chart view with other date formats
- CSS settings in the editing of the menu toolbar and editing of menu items

Bug:
- Fixed issue in macro "sc_field_disabled" in fields select multiple values in single record form
- Fixed issue in connection of subquery type in firebird connections
- Fixed issue in express creation of applications
- Fixed bug with sc_ajax_message macro