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

ScriptCase v9.0.030 2017-12-13 23:01

Nuevas funcionalidades

  • Added macro support "sc_format_num" in the onrecord event of the grid.

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

  • 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

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

  • 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

Nuevas funcionalidades

  • Improved responsiveness of the calendar application toolbar.

Corrección específica

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

Mejora de rendimiento

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

Bug

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

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

Nuevas funcionalidades

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

Corrección específica

  • 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

Corrección específica

  • Fixed mkdir() error in generating applications.

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

Nuevas funcionalidades

  • 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

Mejora de rendimiento

  • 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

Nuevas funcionalidades

  • 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

Corrección específica

  • 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

Corrección específica

  • 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

Nuevas funcionalidades

  • 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

Nuevas funcionalidades

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

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

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

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

Nuevas funcionalidades

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

Corrección específica

  • Fixed issue in displaying the field type Youtube configured as modal.
  • Fixed recording of the "File name (only to store in the database)" option in the multi upload fields.
  • Fixed chart display when using filter in chart applications.
  • Fixed issue in totalization variables in onGroupBy when not using groupby.
  • Fixed negative format display for Decimal fields of groupby totalization in the query application.
  • Fixed image upload selector display in HTML Templates.
  • Fixed issue when listing internal libraries in the project default values.
  • Fixed issue using global uppercase variables in the dashboard filter.
  • Fixed issue in the HINT view of the sc_link macro in URL fields.
  • Fixed issue using sc_field_read only macro in Ajax Events.
  • Fixed issue in button display when using sc_btn_display macro.
  • FIxed issue in horizontal scrolling of the side menu of applications.(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.

Mejora de rendimiento

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

Bug

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

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

Nuevas funcionalidades

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

Corrección específica

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

Mejora de rendimiento

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

Bug

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

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

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

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

Mejora de rendimiento

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

Bug

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

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

Nuevas funcionalidades

  • Added support for chart application in helpcase.

Corrección específica

  • 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

Nuevas funcionalidades

  • 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

Corrección específica

  • 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

Corrección específica

  • 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

Nuevas funcionalidades

  • Added the Helpcase button on the summary toolbar.

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

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

Mejora de rendimiento

  • 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

Corrección específica

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

Bug

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

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

Corrección específica

  • 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

Nuevas funcionalidades

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

Corrección específica

  • 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

Corrección específica

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

Mejora de rendimiento

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

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

Corrección específica

  • 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

Nuevas funcionalidades

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