Scriptcase V8 Changelog. To see the last changes of previous version, click here.

ScriptCase v9.2.008 2018-09-14 06:19

Bug

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

ScriptCase v9.2.007 2018-09-06 05:44

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 control 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 v9.2.006 2018-08-29 22:43

New functionalities

  • Added support to schema in Oracle connection settings.
  • Added support to schema in PostgreSQL connection settings.
  • Added support to initial database in creating PostgreSQL connections.

Bug

  • Fixed problem in title when renaming helpcase files.
  • Fixed problem when using 'date' fields not displayed in form application.
  • Fixed problem in the positioning of the records when using the option 'Records per line' in the PDF report.
  • Fixed problem using format 1- for negative numbers.
  • Fixed problem when generating full report option in exporting HTML print.

ScriptCase v9.2.005 2018-08-24 05:59

Bug

  • Fixed problem when using Oracle PDO connection without schemas enabled.
    You must update the production environment
  • 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 v9.2.004 2018-08-15 22:48

Bug

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

ScriptCase v9.2.003 2018-08-08 05:00

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 v9.2.002 2018-08-06 21:24

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 v9.2.001 2018-07-30 22:27

New functionalities

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

ScriptCase v9.2.000 2018-07-23 00:03

New functionalitiesUPGRADE REQUIRED

  • 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 v9.1.009 2018-06-19 19:44

Specific correction

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

ScriptCase v9.1.008 2018-06-19 09:18

Bug

  • 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 v9.1.007 2018-06-13 21:50

Specific correction

  • Fixed problem when using sc_redir macro in blank applications.

ScriptCase v9.1.006 2018-06-10 17:21

Bug

  • 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 v9.1.005 2018-06-06 00:15

Bug

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

ScriptCase v9.1.004 2018-05-25 13:00

New functionalities

  • Added style support for CSS, LESS, SCSS, JS, HTML, XML and PHP code from the file extension used in the external library.
  • Added shortcut CTRL(CMD) + ALT + I for automatic indentation of selected code. You will need to clear your browser's cache.
  • Added functionality to expand/collapse code blocks in the editor.

Bug

  • Fixed problem in floating vertical menu, using toolbar.
  • Fixed problem in displaying the "Positive currency format" option in summary numeric fields.
  • Fixed problem in incrementing days in sc_date macro.
  • Fixed problem when viewing the image field in the form grid editable(View), shortly after a search in the QuickSearch filter.
  • Fixed problem in the application view procedure, when there were other connections other than the MS SQL Server connection.
  • Fixed problem saving chart themes.
  • Fixed problem when selecting value in capture link, in editable grid forms.
  • Fixed problem while clearing a QuickSearch search.
  • Fixed problem in form's onChange Ajax event. The event was being processed 2 times.
  • Fixed problem in label filter when using fields with Ajax processing.

ScriptCase v9.1.003 2018-05-18 20:16

Bug

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

ScriptCase v9.1.002 2018-05-17 22:06

New functionalities

  • Added support for global variables in reCaptcha and Captcha fields.
  • Added capture link in tags filter.
  • Updated new component of the SPIN option of the Form.

Bug

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

ScriptCase v9.1.001 2018-05-09 23:52

New functionalitiesUPGRADE REQUIRED

  • Enabled the email export buttons in the Grid's detail.

Bug

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

ScriptCase v9.1.000 2018-05-07 06:59

New functionalitiesUPGRADE REQUIRED

  • 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.
    Documentation: sc_call_api
    Documentation: sc_send_mail_api
  • 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. Sample
  • For Chart applications where added new settings to export to formats: XLS, XML, CSV, RTF, WORD and image; Sample
  • 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. Sample
  • 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. Sample
  • New configurations options that allows, for example, to add buttons within the Advanced Search form body. Sample
  • 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. Sample
  • 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

Bug

  • 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.
  • Fixed issue when pressing the enter key in multi-line text field.
  • Fixed issue in CSS tabs in static and dynamic Groupby in Grid application.
  • Fixed issue in the "Maximum Size" option in the multi-line text field.
  • Fixed issue when importing a spreadsheet where the name contained numbers.
  • Fixed issue when inserting an image with link in the field EditorHTML.
  • Fixed issue in the Google Maps field view in the Editable Grid form (View).
  • Fixed issue in processing the "Exit" button of the Control application, when the application was executed within the menu.
  • Fixed problem in passing parameters in the field link of the Grid, when the Form had composite key.
  • Fixed JavaScript error in the "Save Grid" button of the Grid application.
  • Fixed issue in displaying the Summary on the same page of the Grid, after navigation of records.
  • Fixed issue in Internet Explorer, by keeping focus on text area fields while the values ​​is being filled.

ScriptCase v9.0.043 2018-03-22 23:25

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 v9.0.042 2018-03-15 23:50

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 v9.0.041 2018-03-15 08:10

New functionalitiesUPGRADE REQUIRED

  • Added new healthcare sample system. UPGRADE REQUIRED View Example

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 v9.0.040 2018-03-08 00:17

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 v9.0.039 2018-02-28 23:03

New functionalities

  • Added new Progress connection module.

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.
  • Corrected option to Convert Letters of the field in Filter applications.

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 v9.0.038 2018-02-21 22:46

Specific correction

  • 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 v9.0.037 2018-02-16 00:13

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 v9.0.036 2018-02-05 14:25

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 v9.0.035 2018-01-24 21:12

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 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 v9.0.034 2018-01-18 23:27

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 v9.0.033 2018-01-11 14:33

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 Nested Grid type links.

ScriptCase v9.0.032 2018-01-10 15:30

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.

Specific correction

  • Fixed issue in the "Group Label" view in the forms, when there was a hidden field in the application.
  • Fixed issue in sorting's layout configuration of Summary when changing order of fields from Group by.
  • Fixed issue in the menu layout when using the "hide menu" option in the Edge and I.E 11 browsers.
  • Fixed issue generating a Subselect field in pdf report application in php 7.1 environments
  • Fixed issue when cleaning refined filter search in fields named as length.
  • Fixed issue in PDF export support using grids with custom layout from events.
  • Fixed issue in color views of the negative values ​​of the Summary.
  • Fixed issue in viewing the size of the buttons in the bindings of the iframe Grid type.

Bug

  • Adjustments in the fields verification condition in the multiupload option.
  • Fixed issue using empty paragraph tag in HTML editor.
  • Fixed JS issue when clicking on links from image fields in Grid.
  • Fixed issue using function keys in Firefox.
  • Fixed issue when using color html field with color palette on horizontal forms.
  • Fixed issue in exporting Excel from array Summary.
  • Fixed issue in XLS and XML export when referencing some field of type "date" in onGroupByAll events.
  • Fixed line break issue in "multi line" fields in PDF Report application, when using the convert letter option.
  • Fixed bug when using link button in editable Grid form (view).

ScriptCase v9.0.031 2017-12-26 14:48

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 v9.0.030 2017-12-13 23:01

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.

ScriptCase v9.0.029 2017-12-11 20:59

New functionalities

  • Addition of new sources from the Report PDF application.
  • Added option for title break in calendar view.

Specific correction

  • Fixed issue in the display of the "filter conditions" in the "double select" field in the generated filter applications. From this version onwards, the filter will support the conditions: equal, contains, different, does not contain, empty content, non-empty content.
  • Implemented the option to use the "FORCE ORDER" command in grids using the MSSQL Server connection.
  • Fixed issue using the sc_ajax_message macro in the html control application.
  • Fixed issue in assigning the fields in the onLoad event in the html control application.
  • Added macro support "sc_btn_display" in editable grid forms and editable grid view. Note: The code must be used in the onLoadRecord event, where it will be executed with each record in the record. If done on onLoad, it will run only once.
  • Fixed issue when using submit option in onChange and Ajax processing in grid filter.

Bug

  • Fixed issue in displaying the characters when being informed in the quicksearch field. The error occurred in Chrome and Safari browsers.
  • Fixed "Undefined offset" error when using the sc_date_dif_2 macro.
  • Fixed issue when creating a Subselect field in the Reportpdf application on Firebird connections.
  • Fixed issue in displaying the fields of the breaks in the matrix summary selection interface.
  • Fixed issue in viewing recurrence fields in calendar application. The fields were not being hidden in the Firebird and Oracle connections.
  • Fixed issue in the 'Display values' option of the generated application not being inherited from the interface.
  • Fixed issue when using macro "sc_field_disabled_record" in select fields of type multiple values.

ScriptCase v9.0.028 2017-11-30 23:21

Specific correction

  • Fixed issue when running the sc_error_message macro in the onValid event on mobile devices.
  • Fixed issue when using the high box setting of text type fields on mobile devices.
  • Fixed issue in time view in calendar events using SQL Server connection.

Bug

  • Fixed issue in grid export containing hour type fields.
  • Fixed issue when informing the path of the data source in the interface Import of Access.
  • Fixed error of Undefined variable: str_tog_help when clicking on the relationship item N x N.

ScriptCase v9.0.027 2017-11-28 08:28

New functionalities

  • Added new values for the "uncategorized" option in the "category" field in the calendar application.

Specific correction

  • Fixed issue when using the "Database session" option with the MariaDB SGDB.
  • Fixed bug in field view when application was created containing the hyphen character in application name.
  • Fixed issue in creating calendar table in Oracle connections.

Bug

  • Fixed issue in the "where" clause of the grid filter, when the main SQL had a clause "where".
  • Fixed bug in the creation of the field "Subselect" in the connections of type Access.
  • Fixed issue in viewing the records in the calendar when using the category filter option.

ScriptCase v9.0.026 2017-11-22 07:38

New functionalities

  • Added new options for border "color" and "width" in the form blocks' CSS
  • Automatic Recovery of ' auto increment ' value in the DB2 type connections
  • Added support for "tab" key for autocomplete fields for the first record add.
  • Added new options for border "color" and "width" in the form fields' CSS
  • Added support to ajax events creation for the "category" field in the calendar application.

Specific correction

  • Fixed Fatal error: Invalid handle returned, MSSQL SERVER connections.
  • Fixed issue in Grid SQL when using the character * (asterisk) within a case statement.
  • Fixed issue when creating the calendar table using Firebird connection.
  • Fixed issue in the amendment and updating of the indexes in the data dictionary.
  • Fixed issue when synchronizing the field size in the data dictionary.
  • Fixed issue in Grid SQL when using the character "hyphen" within a case statement.
  • Fixed issue when creating a button and choosing that it only appears when edditing a Editable Form (Grid view) format.
  • Fixed issue in aligning radio and checkbox fields.

Bug

  • Fixed formatting problem of the fields "currency" and "decimal precision" in the Advanced Search.
  • Fixed issue with scrollbar when changing menu's tab.
  • Fixed issue when creating Grid application using JOIN in Access connections.
  • Fixed issue when using the macro "sc_date_conv" at the OnHeader event from ReportPDF application.
  • Fixed an issue in the Editable Form (Grid view), when the primary key field was not displayed in the application.

ScriptCase v9.0.025 2017-11-17 00:30

New functionalities

  • Improved responsiveness of the calendar application toolbar.

Specific correction

  • Adjustments made in the "Characters Allowed" field alignment in the field settings of type "Text".
  • Fixed issue using global variables in sc_exec_sql macro.
  • Fixed issue in retrieving data types when importing an excel file.
  • Fixed issue when editing the field that updates the application connection table "app_form_edit_users" generated by the security module.
  • Fixed issue when incrementing the version of a project, when there was a log module configured to the project.
  • Fixed issue when automatically identifying the unique keys of the SQlite connections in the form.
  • Fixed issue using the sc_changed macro in the DATETIME field in the MSSQL SERVER connections.
  • Fixed issue when updating zip code in the onChange event, using autocomplete fields in assignments.

Performance improvement

  • Adjustments in the application creation interface when the table and field names exceed the input preview limits.
  • Removed white space in the html code generated by the form when there was a capture link.

Bug

  • Fixed issue when using refined filter in field with alias in Grid with GROUP BY.
  • Fixed issue when using a field containing a capture link and an ajax event on mobile devices.
  • Fixed issue using the sc_set_language macro in the onScriptInit and onApplicationInit events.
  • Fixed issue using the sc_error_exit () macro in the onValidate event of the filter.
  • Fixed issue in the calendar's exit button display in deployed environments.
  • Fixed issue in visualizing the fields of the dynamic breaks in the totals of the grid.
  • Fixed issue in link of dynamic breaks using SQL with JOIN and fields using capital letters.
  • Fixed bug when adding another display field in summary filter lookup. You will need to clear your browser's cache.
  • Corrected issue in the option "Create link in chart" of Grid chart.
  • Fixed issue in XLS and XML export when referencing some field of type "date" in onGroupByAll events.
  • Corrected issue in aligning the fields of the pdf report using the "record per line" type.
  • Fixed issue with line break in HTML editor fields with fields of type LONGBLOB.

ScriptCase v9.0.024 2017-11-13 08:47

New functionalities

  • Added option to hide caption in chart. Option is now available in the chart settings.
  • Inclusion of the 'BETWEEN TWO VALUES' condition for the 'TEXT', 'VALUE' (currency) and 'DECIMAL' field types under the filter conditions.
  • Added option to select initial values ​​in the dynamic break interface.
  • Added the value of "Dynamic Break" in the "Break Initial" option in the break settings.
  • Added option to display or not the "new record" button of the grid in the Dashboard toolbar.
  • Adjustments in the layout of breaks.

Specific correction

  • Fixed issue of downloading files in the Multi-upload form in mobile mode.
  • Fixed issue in option 'Display values' and 'Short values' in multi-series graphics.
  • Fixed issue in event display while hiding calendar categories filter.
  • Fixed issue when setting the maximum file size. The application allowed to send a file of a larger size than the one that was configured.
  • Fixed issue when copying html files in Helpcase tool. The title of the page was not being replaced.
  • Fixed issue in displaying project name after accessing Scriptcase.
  • Fixed issue in time display in events with no time and / or end date in the calendar.
  • Fixed issue using the sc_changed macro in the date and time field in the MSSQL SERVER connections.
  • Fixed issue in the "Display Mask" option in the settings of the break fields.

Bug

  • Fixed issue in the preview of the default values ​​in the summary filter.
  • Fixed error in the pdf layout by the registry option per line in the interface.
  • Fixed the Grand Total option of chart applications.
  • Fixed issue when changing the grid SQL in grid and graphical applications. The "Number of records" field was being removed from the total.
  • Fixed issue sending file with extension that are not allowed. Invalid file message was not being displayed.
  • Fixed unserialize () error: Error at offset 625 of 774 bytes | Script: nmField.class.php line: 4114, when entering more than one lookup field in the summary filter.
  • Fixed issue in the summary link generated through dynamic breaks using SQL with JOIN.
  • Fixed issue in Gauge chart generation.
  • Fixed error: Invalid argument supplied for foreach () - 2707 nm_gp_consulta_cons.php when using the empty "break" option.

ScriptCase v9.0.023 2017-11-03 20:36

Specific correction

  • Fixed mkdir() error in generating applications.

ScriptCase v9.0.022 2017-11-03 14:09

New functionalities

  • Added option to display events without filter categories within the calendar.
  • Added support to add multiple categories in the calendar filter.
  • Added option to hide the filter categories field within calendar.
  • Added option to export calendar events to Google Calendar.
  • Updating the FusionCharts Chart Library, now supports FusionMaps(Need to upgrade your production environment)
  • Added support for the FusionCharts library in the sc_include_lib macro.
    Video

Performance improvement

  • Improvement of Scriptcase projects converter.

Bug

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

ScriptCase v9.0.021 2017-10-19 22:45

New functionalities

  • Added new example project Personal Finances.
  • Added new events in the calendar application: onCalendarApplicationInit and onCalendarScriptInit.
  • Added DB2 support in sample projects.
  • Added support for .tgz formats in the deploy generation.
  • Added support for the GoJS library in the sc_include_lib macro. Check the documentation

Specific correction

  • Fixed bug in reCAPTCHA SSL certificate in Mac OS. For environments already installed, see the tutorial
  • Fixed problem when dragging multi-day events into calendar.
  • Improvement in the layout of the Calendar Categories field in the form of calendar application.
  • Fixed preview problem on calendars buttons called from dashboards.
  • Fixed problem in multi-day event viewing in calendar.
  • Fixed problem in viewing times at events marked 'full day' in the calendar.

Bug

  • Fixed error "file_get_contents() failed to open stream: No such file or directory" when viewing the layout in the application settings.
  • Fixed problem when saving theme name of the menu using the "/" character.
  • Fixed problem viewing the HTML code of a header template copied in Helpcase.
  • Fixed problem creating header template in Helpcase.
  • Fixed problem in the analysis of comments by blocks and line with global variables.
  • Fixed problem navigating forms, when using option "Use Checkbox in drop down" in select fields.
  • Fixed problem using global variable in lookup field with group by in the grid.
  • Fixed problem using the connection parameter, being created dynamically through the macro sc_connection_new.
  • Fixed problem with displaying language/regional settings in application settings.
  • Fixed problem in the options saved in the security module profile.
  • Fixed problem displaying the date field using other formats in the chart application.
  • Improved text in the interface for uploading external libraries.
  • Fixed problem in link of type application, when the key field had dot.
  • Fixed problem in grid totals when using Group by syntax in main SQL.
  • Fixed problem when entering values ​​with accent in the option "Text between values" in the settings of the date field in the search.
  • Fixed problem when inserting date type fields, disabled in the interface and assigned through events.
  • Fixed problem in "Save Filter" option in generated applications, using select fields with Ajax processing.

ScriptCase v9.0.020 2017-10-06 16:44

Specific correction

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

ScriptCase v9.0.019 2017-10-06 02:32

New functionalities

  • Inclusion of new configuration options in the calendar application.
    Video
  • Integration with Google Calendar.
    Video
  • Added new field for calendar categories.
  • Added category filter in calendar sidebar
  • Added Google reCAPTCHA v2 integration in creating the security module.
  • Added Google reCAPTCHA v2 integration in form, control, and calendar application security.
  • Added option for color palette in the Color HTML fields.
  • Added option to hide recurrence fields in calendar application.
  • Configuration of the width and size of the calendar.
  • Added option to hide time fields when scoring all day in calendar application.

Bug

  • Fixed problem in "Empty Content" condition of checkbox fields in search.
  • Fixed problem when using the "Select the fields that will be displayed in the Group By line" option when the field was not being used in the Group By.
  • Fixed issue when running menu application without setting up a connection.
  • Fixed problem in analysis of comments by lines and blocks.
  • Fixed issue when using sc_field_style macro on links created by the sc_link macro.
  • Fixed problem when displaying date type values ​​when using the sc_log_split macro.
  • Fixed problem in later records behavior when using sc_field_style macro.
  • Fixed problem in reloading dashboard indexes.
  • Fixed problem in the use of virtual fields in the grid Group By.
  • Fixed issue of footer display in PDF export of Chart.
  • Fixed issue when using special characters fields in grid Group By using MSSQL Server connections.
  • Fixed problem using field variable on Group By label.
  • Fixed problem in totalization display when Group By field has value 0.

ScriptCase v9.0.018 2017-09-05 23:00

New functionalities

  • Added new application theme, "Sc9_Meadow".
  • Added new values ​​to the "Relative Period" option in the summary search.
  • Added support for default values ​​in chart and summary search.
    Video
  • Added option to sort values ​​in chart with drill down navigation.
  • Improved display of filtered field for chart and summary.

Specific correction

  • Fixed problem in PDF export of chart application.
  • Fixed execution problem in checkbox fields configured with manual lookup and Ajax event.
  • Fixed problem when accessing dynamic group by in summary: At least one field should be related to the Y axis.

Bug

  • Fixed problem uploading files to HTML templates.
  • Fixed problem with 'copy' button for Helpcase HTML template.
  • Fixed problem when creating a Helpcase header template.
  • Fixed problem in "Create Select" interface in lookup settings.
  • Fixed problem using "Relative Period" with "Multiple Values" option in summary and chart search.
  • Fixed interface problem when renaming the application.
  • Fixed problem when saving "Negative number format" option in fields and regional settings.
  • Fixed problem when copying images through image manager.
  • Fixed problem in viewing the connection icons in XLS, CSV and Access import.
  • Fixed display problem in dimension numeric field settings.
  • Fixed problem in langs view in the calendar of data type fields.

ScriptCase v9.0.017 2017-08-18 12:59

New functionalities

  • Added button to print in the export of the detail of the print type query.

Specific correction

  • Fixed issue in the visualization of the buttons using the sc_btn_display macro.

ScriptCase v9.0.016 2017-08-18 01:36

New functionalities

  • Added option to start by the filter in chart applications. Option available in settings interface.
  • Improved display of the "Export Chart" option in the chart interface. Option available in chart settings.
  • Improved the look of the "Filter Conditions" item of the filter menu in the interface.
  • Added the control application in the "Connection Widget" of the dashboard.
  • Added sc_text_style macro for Grid application. View documentation
  • Added button to print in the Print Grid export.
  • Added option " between two values " in filter conditions for numeric fields.

Specific correction

  • Fixed issue in displaying the field type Youtube configured as modal.
  • Fixed recording of the "File name (only to store in the database)" option in the multi upload fields.
  • Fixed chart display when using filter in chart applications.
  • Fixed issue in totalization variables in onGroupBy when not using groupby.
  • Fixed negative format display for Decimal fields of groupby totalization in the Grid application.
  • Fixed image upload selector display in HTML Templates.
  • Fixed issue when listing internal libraries in the project default values.
  • Fixed issue using global uppercase variables in the dashboard filter.
  • Fixed issue in the HINT view of the sc_link macro in URL fields.
  • Fixed issue using sc_field_read only macro in Ajax Events.
  • Fixed issue in button display when using sc_btn_display macro.
  • FIxed issue in horizontal scrolling of the side menu of applications.(You will need to clear your browser cache)
  • Fixed issue in displaying " Filter Settings " and " Special Conditions " options in "date" and "datetime" virtual fields of the filter.

Performance improvement

  • Improved performance in advanced search of date fields using PostgreSQL connections.

Bug

  • Fixed issue in the visualization of the field options "Initial ordering" in the graphic interface.
  • Fixed Fatal error: Parameter Redefinition, when using field name Duplicate in autocomplete field edit lookup.
  • Fixed grid pagination problem using Limit option.
  • Fixed issue when setting the NULL value in fields of type nVarchar in SQL SERVER in Forms.
  • Fixed issue in "Master Detail" application view in mobile applications.

ScriptCase v9.0.015 2017-08-11 07:00

New functionalities

  • Added support to third digit in version increment of the projects.

Specific correction

  • Fixed issue in PDF export of query with group by and charts.
  • Fixed issue when using special characters "<" in automatic lookup of form applications.
  • Fixed problem in finding the page generated from the helpcase, using special characters.
  • Fixed issue in Multi upload fields using MSSQL Server Native SRV PDO and PDO_DBLIB driver.
  • Fixed PDF export issue in environments that only accept the https:// protocol.
  • Removed the fields with the data types: Date, Time, Timestamp, Clob, Blob, Bytea, Oid, Lo, Varbinary, Image and Xml of the Quick search interface.
  • Fixed issue in displaying button "OK" in the form of applications when the user dont have access to application. (Non-authorized user interface).
  • Fixed issue in updating disabled fields with N-N relation.
  • Fixed issue when saving Query filter in Double Select fields with Characters.
  • Fixed issue using quicksearch with% character in PostgreSQL connections.
  • Fixed issue in displaying the configuration images in the image manager. (It's necessary to clear the browser's cache.)

Performance improvement

  • Added protection to download links of the generated applications files.
  • Improved visualization of the macros documentation. (It's necessary to clear the browser's cache.)

Bug

  • Fixed issue while accessing the config.php file.
  • Fixed bug - invalid argument supplied foreach()-nm_gp_chart_hystogram.php 458 when configuring column-type chart in Girds.
  • Fixed Fatal Error : Uncaught Error: Call to undefined method proc_teste_cat_grid :: totaliza_php () in the execution of the applications of type procedure.
  • Fixed bug Invalid argument supplied for foreach () | Script: devel \ class \ page \ nmPageMenu.class.php line: 1862 when creating a procedure application.
  • Fixed issue using macro sc_error_message and sc_error_exit.
  • Fixed issue when using totals in virtual fields of a Grid.
  • Fixed issue in the display of the "Quantity of records" option in the graphic interface.

ScriptCase v9.0.014 2017-08-04 20:31

Specific correction

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

ScriptCase v9.0.013 2017-08-03 18:18

New functionalities

  • Added option to generate chart for windows in modal of export pdf. It will only be displayed if "Create Charts" is enabled at the .pdf export settings.

Specific correction

  • Fixed issue when running "OnHeader" and "OnFooter" events in the chart application.
  • Fixed issue displaying events, in the Javascript on forms.
  • Fixed issue in digit limit for maximum value of decimal fields.
  • Fixed an issue when using a global variable with name that starts with underscores, eg: [_var]
  • Fixed issue in spin input when typing more than one character in field settings at ReportPDF.
  • Fixed issue causing the interface to rename applications in 1366 x 768 resolution.
  • Fixed issue displaying To-Do list buttons when "Who can change" is empty.
  • Fixed issue when updating the "Image (filename)" field while set as mandatory.
  • Fixed issue displaying the image manager menu in 1366 x 768 resolution.
  • Fixed issue that duplicates fields used in AJAX processing.
  • Fixed issue when running ReportPDF when SQL is modified.
  • Fixed problem when using the sc_ajax_message macro. (Its necessary to clear the browser cache)
  • Fixed issue to update records when select field is disabled.

Performance improvement

  • Improved performance on Mac Installer. (It will be necessary to reinstall the environment)
  • Improved interface performance and scripts generation.

Bug

  • Fixed Parse error: syntax error, unexpected 'public' (T_PUBLIC) at form applications when using lookup in the fields.
  • Fixed issue when describing the fields group by in the summary using lookup settings.
  • Fixed issue in the date field display using the advanced filter when its set in the dimension.
  • Fixed issue in the static group by grouping in the grid.

ScriptCase v9.0.012 2017-07-21 00:27

New functionalities

  • Added support for chart application in helpcase.

Specific correction

  • Fixed problem in setting horizontal alignment for summary dimensions.
  • Fixed problem when using field automatic lookup with SQL using schema (PostgreSQL).
  • Fixed problem using uppercase letters in dataset of sc_select macro.

Bug

  • Fixed problem using label field as primary key.
  • Fixed problem when clicking image of the Image Manager.
  • Fixed problem in displaying the menu icons in the advanced themes editor.
  • Fixed problem in chart application interface and dimensions.
  • Fixed problem in form creation interface.
  • Fixed problem in generating subtotal charts when displaying on the same summary page.
  • Fixed problem in content of HTML editor in form on insert mode.
  • Fixed problem in the path of images on the same server when using HTML Editor.
  • Fixed problem on date/time field interface in grid filter.
  • Fixed image layout of the connections when accessing the Database Builder.
  • Fixed problem in scrolling tabs when opening multiple applications.
  • Fixed problem in the button layout of the Save Grid option.
  • Fixed problem in the layout of the Database Builder interface.
  • Fixed problem in the grid configuration interface.

ScriptCase v9.0.011 2017-07-12 19:52

New functionalities

  • Added InsertCode in Form php methods
  • Added a new template system for creation of virtual learning environments (EAD). Designed to assist in content management and administration of courses online.

Bug

  • Fixed issue when dragging events from calendar application.
  • Fixed problem in charts PDF export in HTTPS environments.
  • Fixed error in devel\lib\ php\ database.inc.php line: 838 in font generation with PostgreSQL connections.
  • Fixed problem when starting chart with semi-circular gauge.
  • Fixed problem in generating internal libraries when using classes and objects.
  • Fixed issue in charset of fields label in dynamic group by.
  • Fixed SQL error when executing field in filter containing IF in SQL.
  • Fixed issue when using the sc_make_link macro when using variable in the application name parameter.
  • Fixed problem in the inclusion and automatic change of date fields. If the validation of required fields was performed, the date fields were losing the value.
  • Fixed fields creation and retrieval in the calendar application interface under PostgreSQL connections.
  • Fixed issue when importing RTL images into CSS buttons.
  • Fixed problem when saving the definition in manual lookup. It's necessary to clear the browser's cache.

ScriptCase v9.0.010 2017-06-29 18:50

Specific correction

  • Fixed issue when using ODBC name with Access connections.
  • Fixed issue when changing quantity of records in horizontal forms.

Bug

  • Fixed charset problem in the groups button type link.
  • Fixed issue in the field update table link using fields in uppercase.
  • Fixed PHP 7.0 protection in numeric fields starting with zero.
  • Fixed fatal error: Redefinition of parameter $tabela in the field lookup.
  • Fixed Fatal error: Cannot use [] for reading the summary group by when using the percent field.
  • Fixed error with charset in the field help description of the filter.
  • Fixed error with Undefined variable: obj_attr1 in converted applications.

ScriptCase v9.0.009 2017-06-23 18:58

Specific correction

  • Fixed Parse error: syntax error, unexpected ' public ' (T_PUBLIC) in the fields of relationship N x N.
  • Fixed error on viewing the calendar fields in the configuration "Calendar".
  • Fixed problem within form multiple records navigation after registry update.

ScriptCase v9.0.008 2017-06-22 17:05

New functionalities

  • Added the Helpcase button on the summary toolbar.

Specific correction

  • Fixed issue in implementing the macro "sc_select_where(add)" after processing the php button using the macro sc_exit(sel).
  • Fixed issue in the submit page to change the option to view the mobile version.
  • Fixed issue in dashboard by using zero-dimensional index filter.

Bug

  • Fixed issue when using duplicate fields in the lookup.
  • Fixed error in return the lookup by using the checkbox field in the Grid filter.
  • Fixed problem when updating the image on the interface of the project properties.
  • Fixed problem in viewing the print button in the calendar application.

ScriptCase v9.0.007 2017-06-12 08:49

Bug

  • Fixed problem when using the sc_field_style macro in linked fields, in grid application using slide orientation.
  • Fixed problem with maps generation (Google Maps) on mobile devices.
  • Fixed problem sorting values displayed in the chart of summary.
  • Fixed problem displaying background images in Report PDF.
  • Fixed problem in chart loading when changing between static group by.

ScriptCase v9.0.006 2017-06-02 01:27

New functionalities

  • Added option "Save as" to external libraries available to Scriptcase level.

Specific correction

  • Fixed SQL error in the log application generation with DB2 connections.
  • Fixed SQL error in dashboard indices with DB2 connections.
  • Fixed issue when creating the log table with DB2 connections.
  • Fixed error when creating the security module tables using the DB2 connection.
  • Fixed issue when creating the table in the calendar application with DB2 connections.

Performance improvement

  • Improved "active" field display in the application "grid_sec_users_groups" of the security module

Bug

  • ​Fixed issue in connections when entering the database name.
  • Fixed issue in the placement of fields in the pdf report headers images.
  • Fixed Undefined variable error "NM_tmp_del" when using the macro sc_menu_delete in the menu events.
  • Fixed issue in "lines" button display when the Summary, Charts and Details modules were disabled within the Grid.
  • Fixed javascript error when using "Save Grid" option.

ScriptCase v9.0.005 2017-05-25 20:13

Specific correction

  • Fixed problem when using buttons group in the Grid detail.
  • Fixed problem with capture links in the Control applications.
  • Fixed problem in the Charts PDF generation.
  • Fixed problem with fields display in the Grid detail. The fields were exicciding the Grid bottom toolbar.
  • Fixed problem in link naming in exporting applications.
  • Correction of the sending of lang feedback in the application language interface.

Bug

  • Fixed problem using log module with different connections in the application.
  • Fixed sorting problem in the Grid Group by.
  • Fixed bug in the insertion of html "doctype, html, head, body" in the html editor field.
  • Fixed SQL error in including files and images in the multiupload field.
  • Fixed problem in Grid sql when using ORDER BY clause with Postgres connections.
  • Fixed problem when clicking to edit project theme.

ScriptCase v9.0.004 2017-05-19 01:03

Specific correction

  • Fixed duplicate label problem when using "Title on the same line" in the Nested Grids
  • Fixed error when running the Grids without items on the toolbar.
  • Fixed duplicate label problem when using other selected fields on the Group by line.
  • Fixed issue when using global variable in the Grid label.

Bug

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

ScriptCase v9.0.003 2017-05-11 16:56

New functionalities

  • Improvements in the security module. From this version, when a new user is added using the "new user" application available within the login, the new user will be added to the group "default" available in the security module group type settings. The user will also become active automatically. However, if the option to "require activation by email" is selected during the security module creation, the user will not be active automatically.
  • Added the syntax N '' for the conversion of the string types Nchar, Nvarchar and Ntext in the Mssql Server databases.
  • Added option to display or not the amount of records in the select object in the summary filter.
  • Changed the "clear" button placement within the summary's search.
  • Improvement in the summary layout.

Specific correction

  • Added validation on the backup/restore of files from version 8.
  • Fixed error of "Invalid argument supplied for foreach" devel/lib/php/database.inc.php 827 in the Grid lookups on Postgres connections.
  • ​Fixed issue when using SQL syntax index with MS Access connections.
  • FreeTDS path protection on shared servers.
  • Fixed problem in listing the total values of calculated field "percentage" on the Group by metrics.​
  • Fixed problem in totals list for numeric fields of the indexes in the dashboard using Access ODBC connection.
  • Fixed error in ordering the field "Number of records".
  • Fixed error in the sorting selection in the dimension when the group by was changed.
  • Fixed display error in the field "Number of records" in the summary sorting settings for inicial sorting.
  • Fixed alignment of the field "Number of records" in the summary.

Bug

  • Fixed error in deleting the master detail in connections with Firebird. (Bug from PHP 7.0).
  • Fixed SQL error in the summary, after converting queries using DISTINCT and quantity of records.

ScriptCase v9.0.002 2017-05-04 17:58

Specific correction

  • Fixed problem of SQL syntax when using more than one index with different connections inside the dashboard application.
  • Fixed issue in app_container.js file path in the application dashboard.
  • Fixed problem the dashboard widgets toolbar option within the chart application.
  • Fixed problem of encrypted files in the production environment.
  • Fixed problem in the CAPTCHA display on Linux 64-bit Installer environment.
    (You will need to reinstall)

Performance improvement

  • Performance improvement in the Mac installer.
    (just available for new installations)

ScriptCase v9.0.001 2017-05-03 09:12

Specific correction

  • Fixed problem in importing the sample Business Intelligence project using the database Mysql.
    Before update, clear your browser cache.

ScriptCase v9.0.000 2017-04-28 13:44

New functionalities

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