ASPRunner Professional Changelog

What's new in ASPRunner Professional 10.9 Build 40608

Feb 12, 2023
  • Resolved Spreadsheet mode problem where slow connection or additional features caused adding of extra records;
  • Details preview in popup sometimes did not hide when needed;
  • Updated international messages;
  • Made reCaptcha work for users in China;
  • Fixed Datepicker, Timepicker problems in Spreadsheet mode;
  • Fixed Edit page not processing key field changs properly;

New in ASPRunner Professional 10.9 Build 40463 (Jan 17, 2023)

  • Fixed View as Video - added VideoJS player;
  • Fixed Edit HTML feature on Style Editor;
  • Multiselect Lookup wizard didn't work on mobile devices;
  • Field filter button was not visible in some styles;
  • Fixed Dashboard - search element not showing current parameters;

New in ASPRunner Professional 10.5 Build 37251 (Aug 25, 2021)

  • Fixed Advanced Search page, search on Dashboard and other pages;
  • PHP: fixed import page errors;
  • Fixed upgrade of AD-security based projects;
  • Updated national language messages;
  • Session Expired popup - sometimes was not shown;

New in ASPRunner Professional 10.5 Build 37167 (May 11, 2021)

  • Added support gor Postgres SQL 13;
  • Advanced report grids can now handle 'show summary only' option;
  • Removed extra icon on the collapsible left bar on mobile devices;
  • Copy layout feature in Designer now works with Menu page;
  • Fixed comments font in the Events Editor;
  • Fixed crash when importing multilanguage labels from CSV;
  • Fixed Demo Account uploading of Time fields with default values;
  • TinyMCE Rich text editor - fixed event handling when using non-keyboard input methods;
  • Autofill now respects regional settings in number fields;
  • Fixed JS error in master-details when there were Date or Time fields 'always on search panel';
  • Fixed PDF View for Block reports and Advanced grid;
  • Fixed date-text field handling in Dialog API;
  • Active Directory login - permissions didn't apply when used username in non-original case;
  • Classic ASP only - fixed Add page with details when there is an After Add event;

New in ASPRunner Professional 10.5 Build 37031 (Apr 16, 2021)

  • fixed field totals in PDF mode on the Print page;
  • masked input in text fields didn't work on Android phones;
  • fixed appearance issues with datepicker control in Dialog API;
  • fixed 'prevent duplicate values' feature in the spreadsheet mode;
  • fixed SQL view issues when used as lookup table;
  • fixed a few small PDF generation problems;
  • details on the Edit page didn't work well when in spreadsheet mode;

New in ASPRunner Professional 10.5 Build 36929 (Mar 29, 2021)

  • Fixed search suggest not respecting active master-details and filters;
  • Fixed lookup wizard - Edit box with AJAX control;
  • Search now works in detail preview ( on the details table list page drag simple search control to the cell with Add button, see the screenshot below );
  • PHP - multiple projects on same server sharing the same session ID. Add/Edit didnt' work in projects without explicit login;
  • Custom labels with line breaks prevented PDF from working;
  • Fixed support Unix-style line breaks on Import page;
  • Permissions page didn't work in Sybase and other less popular databases;
  • Fixed minor checkbox issue in details preview;
  • Labels::setPlaceholder - language parameter is now optional;

New in ASPRunner Professional 10.5 Build 36520 (Jan 18, 2021)

  • fixed Export page

New in ASPRunner Professional 10.5 Build 36478 (Jan 10, 2021)

  • fixed ASP version + dynamic permissions;
  • fixed AJAX search, pagination feature compatibility with WHERE tabs;

New in ASPRunner Professional 10.4 Build 35858 (Oct 9, 2020)

  • Fixed search by Display field in lookups when lookup table is SQL View;
  • Projects based on ODBC connections could crash while uploading to the Demo Account;
  • Fixed dependent filters;
  • .NET - import errors didn't make it to the log;
  • Depenedent dropdowns didn't work on Search page in dashboards;
  • Fixed List page with AJAX + pagination issues;
  • - .NET apps didn't work with '-' symbol in web path;
  • Fixed Signature pad plugin Reset behavior;
  • Fixed View as Percent in SQL Server;
  • Fixed left bar scrolling with 'List page with AJAX' option;
  • Improved Oracle db info fetching;
  • Fixed minor glitch in PHP - Desktop application styling;
  • Fixed Search suggest issue in SQL View + List page with search lookup;

New in ASPRunner Professional 10.4 Build 35672 (Aug 31, 2020)

  • fixed searching in lookup fields with different field types in lookup and main tables;
  • fixed crash when uploading BLOB fields to Demo Account;
  • updated master value recalling rule on the Add page;

New in ASPRunner Professional 10.4 Build 35647 (Aug 31, 2020)

  • Fixed delete operation in REST views;
  • Fixed List of values filter in Oracle database;
  • Fixed search by display field in Lookups in Oracle database;
  • REST API didn't work with encrypted passwords;
  • GetCurrentRecord function in button code didn't work in REST/SQL views;
  • Removed 'Back to Master' link from add/edit/view pages;
  • Added TLS 1.3 support to .NET reCaptcha;

New in ASPRunner Professional 10.4 Build 35536 (Aug 4, 2020)

  • Fixed search by date fields

New in ASPRunner Professional 10.4 Build 35525 (Aug 1, 2020)

  • REST API didn't work when 2factor autorization was turned on;
  • Added innovaeditor to the main program;
  • Fixed custom.css and other files caching errors;
  • Fixed removeValidaton API function;
  • Fixed dashboard map appearance on mobile devices;
  • Filters were not applied on Printer page;
  • :{search...} in SQL or REST Views didn't work on Print page;
  • Some button copies didn't work on Add/Edit/View pages;
  • .NET only - Content-Type headers didn't work in REST views
  • Fixed auto-generated code ( Generate C# or PHP code ) in SQL Views

New in ASPRunner Professional 10.4 Build 35387 (Jul 16, 2020)

  • Added Button::getMasterRecord() function;
  • Added default code for custom REST and SQL View operations - Generate PHP/C# code;
  • Fixed reports in MS Access;
  • Improved support for stored procedures in MySQL;
  • Fixed Search API setSearchSQL function usage;
  • Added search and pagination to REST API;
  • Fixed search panel initial show/hide problems;
  • Fixed MSSQL GUID type issues;
  • Fixed maps based on REST View;
  • Fixed quirks with Date control default values and toggleWeekDay function;
  • Added support for font, border styles for HTML snippets in PDF;
  • Implemented AJAX pagination, search etc feature;
  • Added searchStarted function to Search API;
  • Fixed CSRF vulnerability;
  • Fixed possible SQL injection vulnerability in filters;
  • Fixed partial download - improved View as Video for large files;
  • Large BLOB fields could lead to crashes in the wizard;
  • REST View - added support for Accept header in .NET;
  • Added API function - sendEmailTemplate
  • Fixed search in multi-select fields with an apostrophe;

New in ASPRunner Professional 10.4 Build 35079 (May 22, 2020)

  • Added new REST API Authentication types - OAUTH 2.0 - App and Custom;
  • Fixed Export to PDF in Crosstab reports;
  • Added custom .NET code generation in REST Views;
  • Improved Date and Datetime fields searching;
  • Updated builtin PHP to verson 5.6
  • .NET - email From parameter can now be chjanged from custom code;
  • Added support for SQL queries with MySQL GROUP_CONCAT function;
  • Fixed master-details filter disappearing after going back from View page;
  • Fixed visual issues on Datasource screen on small displays;
  • Added :filter macro to Datasource screen;
  • Added advanced REST results handling - can now process object instead of arrays and multiple arrays;
  • Fixed old projects sometimes failing using Lookup wizards;
  • Headers.htm file changes on Editor screen were not applied to generated pages;
  • Added LIMIT macro variables to Datasource screen;
  • Fixed Lookup wizards not displaying values deleted from the Lookup table;
  • SQL queries with two * symbols were not processed properly;
  • Fixed .NET - View as File - Custom expression issue;
  • Added support for DESC sorting in crosstab reports; just add ORDER BY FIELDNAME DESC to SQL to make it sorted backward in the report;
  • ORDER BY clause now also applies to charts with totals;
  • .NET only - fixed login with Google;
  • Search highlighting didn't respect 'case-insensitive saerching' option;
  • Fixed compatibility issues in 'Connect using PHP' for MySQL;
  • Made Security::currentUserData compatible with Active Directory login;
  • Fixed LDAPS support in .NET;

New in ASPRunner Professional 10.4 Build 35002 (Apr 30, 2020)

  • fixed Activre Directory + Dynamic Permissions - Add group popup;
  • Fixed issues with crosstab reports;
  • REST View didn't work with URLs ending in ? or &;
  • ASPRunner.NET didn't work with GROUP BY queries;
  • Reports didn't work with some complex SQL queries;
  • Ampersand(&) symbol didn't show properly in Lookup fields in PDFs and Export results;
  • WHERE tabs didn't work properly in details preview on Edit/View pages;
  • Update Selected feature didn't work with Edit events and Audit;
  • Edit as Date + Time didn't work properly with Chinese language;
  • Demo Account and Project Export didn't work in directories with "Archive" attribute;
  • HTTP headers were not being sent with REST View reuqests;
  • - 'Hide data until search' feature didn't work with reports;
  • All fields search in REST view didn't return results;
  • Any condition option in Search panel didn't work properly;
  • Link to Edit page didn't work on View page;
  • View as Image didn't work on mobile devices with "resize columns" feature turned on;

New in ASPRunner Professional 10.4 Build 34917 (Apr 22, 2020)

  • Boolean filters didn't work with complex SQL queries;
  • Performance issues on Search, Import. Certain types of queries didn't use database indices;
  • ASPRunner.NET fixed error reporting on Import page;
  • Better support for Facebook or Google users in Dynamic permissions;
  • Fixed issues with multiple database connections, sometimes returned 'table can not be found' error;
  • Fixed Text control - input mask on mobile phones;
  • Fixed Prevent duplicate values feature;
  • PHP only. Pages didn't work on PHP 5.3 and earlier.
  • Fixed report ordering and grouping with multiple groups and complex SQL queries;
  • View as Barcode now works in PDF mode as well;
  • Fixed Advanced security - users can see their own records only;
  • Fixed map filtering in dashboards;
  • Fixed Interval - week in reports;
  • Fixed various crosstab report issues;
  • Lookup-list page with search didn't work as dependent dropdown;
  • Google maps tried to load twice in .NET;
  • Charts inserted into List pages didn't work properly in details preview;
  • Export page didn't export data when there were no Edit permissions;
  • Improved search by Datetime fields to include whole days;
  • View button didn't work on the Edit page after saving;

New in ASPRunner Professional 10.4 Build 34835 (Apr 11, 2020)

  • Fixed ordering in reports;
  • Fixed Advanced security in projects without permissions;

New in ASPRunner Professional 10.3 Build 34822 (Apr 11, 2020)

  • Fixed ORDER BY not being applied in reports;
  • Lookup wizard fields showed HTML-tags in page titles, charts and export results;
  • Prevent duplicate values feature didn't work in some cases;
  • Lookup wizard - Autofill feature didn't work in some cases;
  • Dynamic permissions didn't work with permission tables in the secondary database connection;
  • Fixed search in Lookup wizard fields;
  • Fixed details preview + WHERE tabs
  • Fixed admin_memebers page;
  • Lookup wizards didn't work when the user had no permissions on lookup table;
  • 'Show Next/Prev buttons' feature didn't work with some SQL queries;
  • Added support for non-English decimal separators in search;
  • Fixed 'hide data until search' feature;

New in ASPRunner Professional 10.3 Build 34656 (Mar 26, 2020)

  • Fixed filters and crosstab reports with non-default intervals in .NET;
  • Fixed values align in reports and PDF;
  • Fixed export buttons in reports;
  • Multiselect dropdown didn't work in inline mode in scrollable grid;
  • Fixed image dimensions on List page on mobile devices;
  • Added LDAPS support to .NET;
  • Grid labels could not be hidden on mobile devices;
  • Fixed date format problem with Import from Excel;
  • MySQL secure connection didn't work with some servers. Updated mySQL drivers;
  • Added scrollbar to the Chart Series screen;
  • Add in popup didn't save values in fields that weren't added to the List page;
  • .NET - number formatting didn't work properly with some databases and field types;
  • Fixed FTP upload directory selection with SFTP;
  • Fixed drag & drop quirk on Page Designer;
  • Fixed links to other projects that share the same JWT secret key;

New in ASPRunner Professional 10.3 Build 34513 (Feb 24, 2020)

  • Colors were wrong in dark styles 'scroll table data' option was on;
  • Padding property in Page Designer didn't work well with multiple selection;
  • Added some formatting support for 'View as HTML' fields to PDF.
  • Fixed data alignment on Report Print pages;
  • Fixed Update Selected page;
  • Added touchscreen support to SignaturePad plugin;
  • Fixed filter and crosstab report grouping in .NET;

New in ASPRunner Professional 10.3 Build 34222 (Dec 14, 2019)

  • Fixed dependent lookups as checkboxes with Add new on the fly feature

New in ASPRunner Professional 10.3 Build 34219 (Dec 11, 2019)

  • AddPDF function from PDF API didn't work properly in .NET;
  • Export to CSV - Lookup wizard fields weren't exported properly;
  • Added support for MySQL over SSL connection to MS Azure;
  • Reports - long text values didn't work properly in group fields;
  • Added new functions to WhereTabs API: WhereTabs::setTabShowCount, WhereTabs::setTabHideEmpty;
  • Various Search API fixes;
  • Added support for proxy server/CDN in emails sent after registration, password reset etc;
  • GIF and BMP files can now be added to PDF;
  • Implemented Master - details, hide details preview if empty feature.
  • Fixed error in Custom CSS popup in Page Designer;
  • Fixed DB::PrepareSQL function with numeric parameters;
  • Labels::setFieldTooltip API function didn't work in single language mode;
  • Unnecessary menu appeared on the Lookup wizard - List page with search popup;
  • Custom styles weren't applied to menu page;
  • Fixed saving of very long text fields in .NET;
  • Fixed uploading of multiple files on iOS devices;
  • Fixed minor error in basic RTE control;
  • Added support for FTP servers with self-signed certificates;
  • Updated empty search behavior;

New in ASPRunner Professional 10.3 Build 34106 (Nov 19, 2019)

  • Fixed critical security vulnerability. Every production application built with PHPRunner/ASPRunner.NET/ASPRunnerPro 10.3 should be rebuilt with the latest build.
  • .NET - logout, when selected from Admin Area, opened the wrong page;
  • .NET - made QRCode plugin work in PDF;
  • GetCurrentRecord() didn't work in field events;
  • Some projects showed errors on the Login page in Page Designer
  • Improved error reporting fro buttons, field events;
  • Field labels in Dashboards were reset with Sync Database;
  • Cell orientation property didn't work on the Menu page

New in ASPRunner Professional 10.3 Build 33876 (Oct 11, 2019)

  • Added cell padding and height properties support to PDF builder.
  • Added Domain option to Login with Google.
  • Remember me option on Login page didn't work in .NET;
  • Fixed Upload folder - as PHP/C# code;
  • Fixed left bar layout in admin pages;
  • Export page didn't work in details tables;
  • Images didn't show in report group fields;
  • Fixed images upload in Inline Add/Edit;
  • "Loading..." box appeared where not needed;
  • Fixed Dynamic Permissions page appearance on mobile screens;
  • Fixed Login with Google in .NET;
  • Fixed field events and grid row click handlers;

New in ASPRunner Professional 10.3 Build 33761 (Sep 26, 2019)

  • Customers who purchased less than twelve months ago can download this update via the control panel.
  • Customers who purchased more than twelve months ago can renew their maintenance using links below:

New in ASPRunner Professional 10.2 Build 33576 (Aug 23, 2019)

  • Added new SMS providers (1s2u.com, easysendsms.com, gatewayapi.com, messagebird.com).
  • How to use those providers? Proceed to the <installation folder>sourceinclude folder. From that folder copy SMS provider file to sourceincludesms.php file, replacing existing one. In ASPRunner.NET file name is sms.cs, in ASPRunerPro it is sms.asp.
  • Go to the respective website of the chosen SMS provider and create an account there. Edit sms.php file placing your API credentials there. Build your project.
  • Now all SMS messages will go through selected SMS provider. Applies to two-factor authentication and all calls of runner_sms function calls.
  • View as Image didn't work in the details on the Print page;
  • Landing page didn't work with non-default pages;
  • Fixed wrong text-align in PDF for some View as types;
  • Custom files starting with . were not saved;
  • Add in popup didn't add to grid calculated fields;
  • PDF creation with images didn't work with Internet Explorer;
  • Totals did not appear after inline add into the empty table;
  • JS onload event didn't work on the Login page;
  • Images didn't show up in Master preview if those fields were not added to the master's List page;
  • Breadcrumb didn't work properly with two master-details tables not added to the menu;
  • Fixed message in the charts with no data;
  • Images with spaces in the name weren't shown in PDF;
  • Added projectBuildNumber variable to keep track of project builds;

New in ASPRunner Professional 10.2 Build 33460 (Jul 29, 2019)

  • New 'View as' type: PDF. Allows to view uploaded PDF files online
  • Finished Real Estate and Knowledge Base templates
  • Fixed Time fields on reports in PDF mode;
  • Fixed email sending issues having appeared on some servers;
  • Fixed SQL Server DATE field issues;
  • Updated code samples in Events - Predefined actions;
  • Grid row background color specified in events was wrongly applied to details preview in popup;
  • Fixed dependent dropdowns behavior on searching;
  • Added support for HTML in field tooltips;
  • Fixed Lookup wizard - Radio buttons appearance;
  • HideItem method didn't work with images in PDF mode;

New in ASPRunner Professional 10.2 Build 33375 (Jul 23, 2019)

  • Fixed in this update:
  • fixed Javascript error in page events
  • fixed editing in HTML mode in Editor
  • new feature 'hide field if empty' on the List page. In a horizontal grid, this option hides the field column if all field values on the page are empty. In vertical and columns grid this option hides the field label in those records where this field is empty.

New in ASPRunner Professional 10.2 Build 33357 (Jul 15, 2019)

  • Fixed error in Page Designer when there are no pages in the table;
  • Copy layout + multistep didn't copy step names;
  • Hide empty fields feature didn't work in PDF on the Print page
  • Changes in XML syntax in the project file for better integration with source-control systems like SVN
  • Cancel ( inline edit ) button wasn't translated
  • Details preview + inline Edit didn't work with Section 508 enabled;
  • Files changed in Visual Editor in 9.x versions sometimes were not built in 10.x
  • Fixed Innova Editor control width;

New in ASPRunner Professional 10.2 Build 33230 (Jun 25, 2019)

  • Fixed ext_security_id column issue
  • Fixed "grid_column undefined" build error
  • Fixed reverse order of elements in the top bar

New in ASPRunner Professional 9.8 Build 30772 (Jul 16, 2018)

  • Fixed PostgreSQL support in ASPRunner.NET
  • Added PHP 7.2 compatibility to PHPRunner (fixes charts not displaying issue under PHP 7.2)
  • Fixed XSS vulnerability on Change Password page

New in ASPRunner Professional 10.0 Build 30701 Beta (Jun 5, 2018)

  • Changes in the wizard:
  • Style Editor page is gone. You can now choose scheme and edit Custom CSS on Visual Editor screen.
  • 'Fields order and totals' screen is gone. Now you can change fields order and add totals on Page Designer screen as well as add sections and tabs.
  • Page Designer:
  • This is where you modify visual appearance of all pages in your app. Drag-n-drop everything, insert buttons, code snippets, fields, tabs, sections etc.
  • Visual Editor screen functionality:
  • We are keeping Visual Editor for now but it's functionality is limited to the following:
  • you can change 'View as' and 'Edit as' settings of any field there.
  • existing projects - Visual and HTML mode available. Visual mode is for compatibility purposes only.
  • new projects - you can use HTML mode only. Most of editing should be happening in Page Designer anyway but if you ever need to modify HTML code directly you still can do that in HTML mode in Visual Editor.
  • change Bootstrap themes and edit Custom CSS here. Choose between regular and condensed themes. Previously lots of people mentioned they are delaying their switch to Bootstrap because Bootstrap layouts require a lot of screen space. To address this we added an option to choose regular or small font size, margins etc.

New in ASPRunner Professional 9.8 Build 29967 (Dec 16, 2017)

  • fixed DESC ordering for fields witch spaces in their name.
  • fixed 'abnormal termination' error on closing the application
  • improved Twilio error reporting in ASPRunner.NET
  • fixed Lookup wizard - Radio buttons containing HTML tags.
  • Improved datepicker. 'Now' button sets current time.
  • fixed Lookup - horizontal radio buttons appearance.
  • fixed SQL variables on details preview pages.
  • fixed crash on Events screen after adding business template to project
  • fixed Oracle issue with schemas that do not contain any tables
  • 'Allow fields reordering' + details preview. The reorder feature doesn't affect order of fields on Master's print page anymore.
  • updated SignaturePad plugin (background image support)
  • fixed password encryption in ASPRunner.NET wizard. Generated app functionality is not affected.

New in ASPRunner Professional 9.8 Build 29725 (Dec 14, 2017)

  • fixed DESC ordering for fields witch spaces in their name.
  • fixed 'abnormal termination' error on closing the application
  • improved Twilio error reporting in ASPRunner.NET
  • fixed Lookup wizard - Radio buttons containing HTML tags.
  • Improved datepicker. 'Now' button sets current time.
  • fixed Lookup - horizontal radio buttons appearance.
  • fixed SQL variables on details preview pages.
  • fixed crash on Events screen after adding business template to project
  • fixed Oracle issue with schemas that do not contain any tables
  • 'Allow fields reordering' + details preview. The reorder feature doesn't affect order of fields on Master's print page anymore.

New in ASPRunner Professional 9.8 Build 29520 (Sep 13, 2017)

  • Fixed in this update:
  • fixed multiselection dropdown control
  • fixed sorting In GROUP BY queries

New in ASPRunner Professional 9.8 Build 29465 (Sep 5, 2017)

  • fixed import errors handling in ASPRunner.NET
  • fixed Add master with details when Inline Add is turned off
  • fixed issues with Lookup wizard - Test it button
  • fixed Admin Area pages in Active Directory
  • fixed setProxyValue function inj Inline Edit mode
  • fixed Edit box with AJAX popup in details in popup
  • fixed 'Custom Display field' with 'List page with search' in Lookup wizard
  • improved 'Data source tables' screen performance with Oracle database
  • fixed Login with reCaptcha
  • fixed relogin after the session has expired
  • improved complex dependent lookup wizards performance
  • fixed Guest user Active directory
  • fixed Block Account after unsuccessful login attempts feature
  • fixed MS Access - OLE Object fields handling in ASPRunner.NET
  • fixed geCurrentRecord function in field event in inline mode
  • improved Oracle SQL error reporting

New in ASPRunner Professional 9.8 Build 29213 (Jul 26, 2017)

  • Fixed import errors handling in ASPRunner.NET
  • Fixed Add master with details when Inline Add is turned off
  • Fixed issues with Lookup wizard - Test it button
  • Fixed Admin Area pages in Active Directory
  • Fixed setProxyValue function inj Inline Edit mode
  • Fixed Edit box with AJAX popup in details in popup
  • Fixed 'Custom Display field' with 'List page with search' in Lookup wizard
  • Improved 'Data source tables' screen performance with Oracle database
  • Fixed Login with reCaptcha
  • Fixed relogin after the session has expired
  • Improved complex dependent lookup wizards performance
  • Fixed Guest user + Active directory
  • Fixed Block Account after unsuccessful login attempts feature
  • Fixed MS Access - OLE Object fields handling in ASPRunner.NET
  • Fixed geCurrentRecord function in field event in inline mode
  • Improved Oracle SQL error reporting

New in ASPRunner Professional 9.8 Build 29139 (Jul 14, 2017)

  • fixed Interval Slider Filter in ASP
  • fixed bug with colons( : ) in SQL strings
  • fixed tooltips on the Edit page in popup
  • fixed Email validation
  • fixed counting of details records on the List page
  • fixed Search suggest bug
  • fixed Gauge charts

New in ASPRunner Professional 9.8 Build 29073 (Jul 4, 2017)

  • fixed connection issue in autocomplete routine
  • fixed some chart issues
  • multilanguage WHERE tabs in details

New in ASPRunner Professional 9.8 Build 28981 Beta (Jun 21, 2017)

  • Tabs and additional WHERE on List page
  • Export page in popup, export settings, choose fields and delimiter
  • Email templates. Customize any email sent from PHPRunner, ASPRunner.NET or ASPRunnerPro
  • Field events. Perform an action when cursor enters edit field or leaves it or mouse is over a field. Perform any sort of validation, make other fields hidden or required etc. Designed to work on Add, Edit and Register pages.
  • Two-factor authentication
  • SQL variables in SQL and Lookup wizards This is a very interesting feature that can be applied anywhere here SQL queries are in use. With variables like this you can write cleaner code and implement custom dropdown boxes or advanced security an easy way.

New in ASPRunner Professional 9.7 Build 28347 (Mar 7, 2017)

  • Improved password hashing
  • Code snippets in dashboards
  • 'Sort by' dropdown control
  • Grid row/field click actions
  • New APIs
  • Improved appearance of cross-tab reports
  • Form field placeholders

New in ASPRunner Professional 9.6 Build 27823 (Dec 20, 2016)

  • fixed runner-mail function in PHPRunner
  • fixed View and Edit plugins support in ASPRunner Pro
  • fixed Gauge chart header and footer
  • fixed Landing - menu page issue.
  • fixed hideField Javascript API function
  • fixed Reports - Outline layout

New in ASPRunner Professional 9.6 Build 27604 (Nov 28, 2016)

  • Fixed in this update
  • Fixed home page link
  • Fixed Register page - reenter password behavior
  • Added HTTPS support to Open Street Maps
  • Fixed glitch in Advanced Search page setup
  • Fixed field labels editing in reports
  • Fixed tables and fields dropdown in Label Editor
  • Prevent duplicate values feature now ignores empty values.
  • Fixed breadcrumbs links in multi-level details
  • Fixed case-insensitive search in File fields in SQL Server
  • Fixed Update Selected feature with Audit Log enabled
  • Improved diagram performance on the Datasource Tables screen.
  • Fixed button label issues
  • Added Update Selected feature to dashboards
  • Fixed encoding glitch in Inline Edit
  • Fixed Reset Search button with Hide Data until search enabled

New in ASPRunner Professional 9.5 Build 27464 (Nov 4, 2016)

  • Fixed issue with 'Insert button' in Visual Editor

New in ASPRunner Professional 9.5 Build 27433 (Nov 3, 2016)

  • Fixed Delete buttons on the Details preview pages
  • Fixed popup apperance on small screens
  • Fixed Freeform + Copy Page issues in Bootstrap layouts
  • Fixed issue with printing Mater with many details records.
  • Fixed filters state saving
  • Fixed active directory + case insensitive usernames issues.
  • Fixed multiseries Gauge charts
  • Fixed Bootstrap + Resizable columns appearance
  • Fixed Menu - ‘open in new window’ attribute in Bootstrap
  • Fixed Visual Editor crashing on Insert Button
  • Fixed several multilingual messages
  • Fixed Freeform mode in tabs and sections

New in ASPRunner Professional 9.5 Build 27326 (Oct 20, 2016)

  • fixed RTL languages support
  • fixed "Custom CSS" functionality in ASPRunner.NET
  • sync database no longer deletes tables from the project when the database link is dead.
  • fixed Labels weren’t displayed properly in some charts issue
  • fixed encryption in PHPRunner under PHP 7
  • added new multilanguage translations
  • fixed custom marker on dashboard map issue
  • fixed several issues with charts in dashboards
  • fixed an issue with jquery.mousewheel.js file being loaded from a third-party server.
  • fixed charts auto-refresh
  • fixed View-Edit page appearance, when View is set up to show in popup, while Edit is not
  • fixed 'After table initialized' event calls for Lookup tables
  • fixed popup window size for multistep pages
  • fixed datepicker on Search panel
  • added a new global wizard option - Make NOT NULL fields required by default.
  • added events to the Report and Report Print pages
  • fixed SQL Server + PHP7 bug
  • fixed Guest login issue (missing 'Login as guest' link)
  • fixed bootstrap popups appearance on small screens
  • fixed show/hide series on financial charts
  • fixed Heat maps on Dashboards
  • improved Import page error handling
  • fixed date and time picker appearance in popups.
  • fixed setProxyValue function issue on details preview page
  • fixed Dynamic permissions + multiple connections issue
  • improved readonly controls behavior
  • fixed Freeform mode on Add/Edit/View tabs and sections
  • fixed row ordering with Print selected feature
  • fixed issues with case-insensitive login in ASPRunner.NET version

New in ASPRunner Professional 9.5 Build 27012 (Sep 1, 2016)

  • Fixed in this update:
  • fixed gauge charts in dashboards
  • fixed details tab still visible when 'Hide link if no child records exist' option is turned on

New in ASPRunner Professional 9.5 Build 26950 (Aug 17, 2016)

  • Fixed in this update
  • security in breadcrumbs, items with insufficient permissions are no longer shown
  • fixed right-to-left languages in Bootstrap
  • fixed import in SQL Server with IDENTITY fields
  • fixed View/Edit plugins in ASPRunnerPro
  • fixed time field without timepicker didn't work issue
  • fixed Bootstrap + scrollable table data option
  • fixed CKEditor alignment issue
  • fixed header/footer in ASPRunner.NET

New in ASPRunner Professional 9.5 Build 26897 (Aug 5, 2016)

  • Fixed in this update
  • fixed 'change password' function with MD5 password encryption turned on
  • fixed headers & footers in popups
  • fixed MySQL initial encoding
  • fixed charts as details issue
  • fixed lookup wizard with search suggest in popup window issue
  • fixed mobile template menu page
  • fixed 'Home' link for old projects
  • fixed Search API - show/hide search panel
  • fixed Gauge charts: multiple series, linear gauge chart

New in ASPRunner Professional 9.5 Build 26849 (Jul 25, 2016)

  • Fixed in this update
  • updated AnyChart to version 7.10.1
  • updated all manuals
  • added two-column layout for the View page
  • fixed dates import in Excel (PHPRunner only)
  • fixed data encryption in ASPRunner.NET (code-based and database-based, SQL Server)
  • pagination changed to use real HTML links instead of Javascript links
  • fixed 'Print selected' in Bootstrap layouts
  • fixed missing "rollover row highlighting" option in ASPRunner.NET
  • fixed missing Javascript onload event on Change Password page
  • fixed Data Access Layer with PHP 7 (PHPRunner only)
  • fixed Interval Slider Filter error

New in ASPRunner Professional 9.1 Build 25192 (Nov 3, 2015)

  • This update fixes the following issues in PHPRunner, ASPRunnerPro and ASPRunner.NET:
  • fixed incomplete build issue
  • fixed mouse navigation in 'Edit box with AJAX popup' Lookup wizard

New in ASPRunner Professional 9.1 Build 24969 (Sep 22, 2015)

  • This update fixes the following issues in PHPRunner, ASPRunnerPro and ASPRunner.NET.
  • restored buttons Search, Replace, Go to in Visual Editor in HTML mode
  • fixed folding sections and tabbs on View/Add/Edit pages in Mobile mode
  • fixed Open Street Map support in ASPRunner.NET
  • fixed Next/Prev buttons on Edit/View pages when order by field values is empty (ASPRunner.NET)
  • fixed upload to Demo Account with hyphens in user email
  • fixed display of full name instead of username in web reports
  • fixed display of logged user name in Mobile template (ASPRunner.NET)
  • fixed 'Insert field' button in Visual Editor on Registration page
  • fixed display of new record ID after Inline Add (Oracle)
  • fixed Add/Edit/View page with sections/tab in popup (ASPRunner.NET)

New in ASPRunner Professional 9.0 Build 24793 (Aug 7, 2015)

  • Major new features:
  • Dashboards
  • Multiple database connections (part of Enterprise Edition)
  • Import page with columns mapping
  • New Printer page/PDF options (portrait/landscape, fit to page, scale)
  • Dashboards - display multiple related or unrelated objects on the same page like grids, single record views, master and details together, charts, reports, search pages etc.
  • Multiple database connections - you can add multiple datasources to your project. Doesn't have to be the same database type, you can mix MS Access, SQL Server and MySQL in single PHPRunner project.
  • You can have master table in MySQL and details table in MS Access. The same applies to lookup tables, they do not have to belong to the same database.
  • Import page
  • Two major improvements here are columns mapping and an option to copy/paste import data instead of uploading the file. The later can be extremely on mobile devices.
  • New Printer page/PDF options - choose between portrait and landscape orientation, fine tune PDF export by setting the scale.
  • Minor new features:
  • Mostly related to PHPRunner UI.
  • Improved start page
  • Tables/pages filtering on all screens
  • Proper handling of tables that were renamed in the database
  • Improved table selection dialog
  • Copy field settings from another field
  • Coral style/color scheme
  • 3-column and 4-column layouts for Add/Edit/View pages

New in ASPRunner Professional 9.0 Build 23504 (Feb 18, 2015)

  • Added support for MSSQL 2012 new data types - time, date
  • Fixed Logout routine
  • Added change password link to Dashboard
  • Fixed TimePicker control appearance in popups
  • Fixed an issue with record locking + search on lookup wizard fields
  • Fixed Dynamic permissions + numeric usernames starting with 0
  • fixed Update Latitude and Longitude by Address option
  • fixed readonly Images on Edit pages

New in ASPRunner Professional 9.0 Build 23238 (Dec 20, 2014)

  • Web reports for ASPRunner.NET + SQL Server fix (the list of tables didn't show up)
  • Added iSeries server database support
  • Fixed Freeze search panel settings issue (settings were not saved in project file)
  • Added Javascript onload event to Printer-friendly page.
  • Fixed Hide data until search mode in AJAX-based List page mode
  • Fixed Search highlighting in Dashboards
  • Fixed MySQL server re-connect in wizard ('MySQL Server gone away' error)
  • Fixed Section 508 keyboard shortcuts
  • Fixed some issues in regards to uploading MySQL and MSSQL databases to Demo Account

New in ASPRunner Professional 9.0 Build 23092 (Nov 21, 2014)

  • fixed AD with Dynamic permissions
  • fixed scaling in PDF reports
  • fixed Built-in web server

New in ASPRunner Professional 9.0 Build 22849 (Oct 9, 2014)

  • fixed controls in tabs on Add/Edit pages

New in ASPRunner Professional 9.0 Build 22790 (Oct 1, 2014)

  • In this update:
  • fixed events on Master List/Print pages
  • fixed logout function
  • fixed TIMESTAMP data type support in Oracle

New in ASPRunner Professional 9.0 Build 22784 (Sep 30, 2014)

  • In this update:
  • fixed 'Test' button in wizard for dependent dropdowns
  • fixed apostrophe character in custom labels
  • fixed totals on printer-friendly pages of details tables
  • fixed search suggest on details tables
  • fixed issue with identical table names in different databases
  • fixed master table header with 'View own data only' option
  • fixed remind/change password with password encryption turned on

New in ASPRunner Professional 9.0 Build 22701 (Sep 12, 2014)

  • Major new features:
  • Dashboards
  • Multiple database connections (part of Enterprise Edition)
  • Import page with columns mapping and copy/paste functionality
  • New Printer page/PDF options (portrait/landscape, fit to page, scale)
  • Minor new features:
  • Improved start page
  • Tables/pages filtering on all screens
  • Proper handling of tables that were renamed in the database
  • Improved table selection dialog
  • Copy field settings from another field
  • new "Coral" style/color scheme
  • 3-column and 4-column layouts for Add/Edit/View pages

New in ASPRunner Professional 8.1 Build 21342 (Apr 26, 2014)

  • fixed the password reminder page
  • ASPRunner.NET - fixed list of details table listed vertically
  • fixed syntax checking in PHPRunner event editor
  • fixed styling in Report Master-Details
  • fixed report details preview in Visual Editor
  • fixed SQl queries with with joins where JOIN condition where in parenthesis
  • INNER JOIN make ON ( make.name = cars.make)
  • fixed resixable columns issues
  • fixed AfterAdd event with details tables on the Add page
  • fixed dynamic permissions pages after new table added to the project and partial build performedНадо было делать полный
  • fixed filters for values starting with 0
  • fixed issues with project located in any folder but in the root of web server ('Session expired' message)
  • fixed 'Send activation link' feature in MS Access projects

New in ASPRunner Professional 8.1 Build 20499 (Feb 15, 2014)

  • fixed connection to SQL Server 2000
  • fixed issue with copying charts from one page to another
  • fixed issue with multilevel menu in IE 11
  • 64bit versions of PHPRunner/ASPRunnerPro/ASPRunner.NET are available (registered customers only)
  • ASPRunner.NET Webreports, fixed MS Access and Postgre support
  • Invoice template: fixed issue with redirect to the list of invoices
  • DocManager template: fixed issue with IE 9
  • DocManager template: fixed issue with breadcrumbs menu after the search

New in ASPRunner Professional 8.0 Build 19903 (Jan 10, 2014)

  • fixed custom expression in Lookup wizard
  • fixed handling decimal number with comma as decimal separator

New in ASPRunner Professional 8.0 Build 19454 (Dec 10, 2013)

  • fixed Visual Editor issue with ? character appearing in the beginning of visual template file
  • fixed DBLookup DAL function in ASPRunnerPro
  • Document Management template updated (ASP and PHP versions). Use download link from Document Management registration email

New in ASPRunner Professional 8.0 Build 19042 (Nov 18, 2013)

  • fixed search with the same field added twice to the search panel
  • fixed labels export to CSV
  • updated PHPRunner/ASPRunnerPro manuals
  • fixed dependent dropdowns on search panel
  • fixed 'Add template to project' function (missing AfterAppInit event)
  • fixed setting row/cell background color, manuals are updated with new code samples
  • fixed third level menu on iPhone/iPad
  • fixed "bad" characters in Active Directory user name/group name

New in ASPRunner Professional 8.0 Build 18881 (Nov 12, 2013)

  • fixed issue with ajax drop down field search
  • fixed issue with saving modified in Visual Editor Mobile pages
  • updated Templates pack, Survey, Invoice, Quiz templates
  • added an option to fix broken Master-Details relationship during database synchronization

New in ASPRunner Professional 7.2 Build 14944 (Mar 9, 2013)

  • fixed ASP import error (happenned on SQL Server with audit option turned on)
  • fixed 'View as' type 'Audio'

New in ASPRunner Professional 7.2 Build 14199 (Dec 31, 2012)

  • fixed Javascript API on Add/Edit/Register page with tabs

New in ASPRunner Professional 7.1 Build 11777 (May 17, 2012)

  • improved generated application load speed
  • fixed ASP charts with data encryption turned on
  • fixed dependent dropdowns 'unique values' feature
  • fixed Lookup wizard based on Custom Views bug
  • fixed 'No records on the first page' option in reports
  • fixed script generation for Demo Account upload (MySQL, default value for bit fields)
  • fixed record locking in inline edit mode
  • fixed web reports with Active Directory authentication (Enterprise Edition)
  • updated manual

New in ASPRunner Professional 7.0 Build 10638 (Apr 6, 2012)

  • Style Editor
  • New layouts
  • Mobile template
  • Built-in web server
  • Crosstab reports
  • Intellisense in Events Editor

New in ASPRunner Professional 6.3 Build 7474 (Feb 22, 2011)

  • fixed Search panel + View Popup bug
  • fixed Autofill + bad table names bug
  • inline add in default layout bug (inline add didn't work if there were no records on the page)
  • fixed totals bug (totals weren't recalculated after inline add/edit, affected currency fields)
  • fixed totals don't appear after first detaikls record added bug
  • fixed totals в inline detail preview moed on the View page
  • fixed iBox issue on View page
  • fixed pagination on admin_members_list page
  • fixed 'records per page' in reports bug
  • fixed Video player issue (video player didn't work if field name contains a single quote)
  • fixed details preview in popup bug (appears when search suggest option is turned off)
  • fixed 'Groups/Records per page' dropdown issue in reports

New in ASPRunner Professional 6.3 Build 7113 (Dec 6, 2010)

  • fixed AJAX sort/search in Internet Explorer and Default layout
  • fixed 'Reset buttons clears date field on edit page' issue
  • fixed list page with search lookup and header issue
  • fixed Javascript files loading for pages with large number of fields (more than 100 fields per page)
  • fixed search doesn't support fields with '#' in it's name issue
  • fixed tooltips for CKEditor text area fields
  • fixed sort/search in 'List page with search' Lookup wizard (ASP only)
  • fixed search suggest issue with duplicate values (ASP only)

New in ASPRunner Professional 6.3 Build 7062 (Nov 29, 2010)

  • fixed Google Maps initialization issue
  • fixed Rich Text Editor issue (click "insert link" or "insert table" or "insert special character" to popup error message)
  • fixed Internet Explorer timepicker issue
  • fixed IE6 search panel issue

New in ASPRunner Professional 6.3 Build 7049 (Nov 26, 2010)

  • Fixed issues with Rich Text Editor in popup mode
  • Fixed candle charts
  • Fixed Oracle connection issue
  • Fixed scrolling in charts
  • Printer-friendly and Export didn't work with 'Records per page - Show all' option
  • Fixed project loading with Malay language

New in ASPRunner Professional 6.3 Build 6843 (Nov 15, 2010)

  • fixed search panel with search suggest turned off
  • fixed dependent dropdowns with search suggest turned off
  • fixed autofill issue (wrong key column type assumed)
  • fixed captcha on password remind and login pages
  • fixed encoding issue in chart headers
  • fixed 'thumbnails can not be turned off' issue
  • fixed issue with 'Edit as' - Checkbox in inline and popup edit mode
  • fixed 'Insert button' issue on View page with multiple key columns
  • fixed 'Edit as' File/Image as required field issue
  • fixed totals recalculation after inline Add/Edit
  • fixed 'Add template to project' feature
  • fixed basic Rich Text Editor issue in popup window

New in ASPRunner Professional 6.3 Build 6735 (Nov 4, 2010)

  • Templates pack updated, now compatible with ASPRunnerPro6.3
  • Web report/chart builder updated, made compatible with ASPRunnerPro6.3
  • fixed menu appearance in Admin area
  • fixed 'Select all' checkbox in inline details edit mode
  • fixed issue with CHAR (MySQL) fields missing in dropdown boxes in wizard
  • fixed 'Resizable columns' in inline details edit mode
  • fixed Print/Export selected in Internet Explorer
  • fixed import integer fields from Excel issue
  • fixed autofill option for fields that don't appear on Edit/Add pages
  • fixed audio player won't loaded on 'Add on the fly' page (Chrome and Firefox)
  • fixed timepicker issues (always displayed in 12-hour mode, no AM/PM can be selected)
  • fixed 'Edit box with ajax' Lookup wizard with freetype option turned on

New in ASPRunner Professional 6.2 Build 5482 (Apr 26, 2010)

  • fixed images in reports issue
  • fixed reports in 'Show summary only' mode
  • fixed Javascript error on 'Change password' page
  • fixed 'search panel doesn't reset page number' issue
  • fixed 'first value is selected automatically in dependent multiline lookup wizard' issue
  • fixed complex WHERE clause parsing issue on 'SQL Query' screen

New in ASPRunner Professional 6.2 Build 5242 (Mar 31, 2010)

  • updated manual (HTML/PDF)
  • updated language files
  • fixed default value of now() in readonly fields
  • fixed 'Connect via PHP' function in PHPRunner (happened of some GoDaddy web servers)
  • fixed 'Quick search' fields selection for charts
  • fixed 'Block account after three unsuccessful login attempts' feature (ASP + Oracle)
  • fixed several CKEditor issues in ASPRunnerPro

New in ASPRunner Professional 6.2 Build 5197 (Mar 26, 2010)

  • fixed several CKEditor issues
  • fixed Timepicker issue on details edit page
  • fixed audit issue with Oracle and ASP
  • fixed numeric values export to Excel/CSV
  • fixed required field issue for file/image fields

New in ASPRunner Professional 6.2 Build 4586 (Feb 8, 2010)

  • Audit trail
  • Record locking
  • Edit/Add master-details tables on the same page
  • New FTP client. SFTP/FTPS support.
  • Section 508 compliance
  • Search panel (advanced search on the list page)
  • Charts update. Multiple series (unlimited), gauge charts (horizontal, vertical, circular), accumulation charts, scrollable charts, financial charts, bubble charts
  • Google maps widget
  • 'Insert button' feature. Add a button in Visual Editor and type in code to be executed after button is pressed.
  • New databases support: Informix, DB2, SQLite, any ODBC-enabled
  • Add CAPTCHA to any page (Edit/Add/Login/Password reminder etc)
  • AJAX-based pagination/sorting/search

New in ASPRunner Professional 6.1 Build 2135 (Jun 11, 2009)

  • Cascade menu builder
  • Validation plugins
  • New edit controls: Time picker, Set of checkboxes
  • Under the hood improvements:
  • smart database synchronization
  • reports performance improved
  • faster wizard navigation

New in ASPRunner Professional 6.0 Build 486 (Oct 3, 2008)

  • DIV-based templates
  • Data Access Layer generator.
  • Templates Merge. Add a template to any existing project.
  • Lookup wizard with built-in search
  • Multilanguage table/field labels
  • Online report/chart builder (part of Enterprise Edition)
  • Master-details improvements
  • Multiple primary-foreign keys to link tables
  • Number of details records on the list page
  • Inline preview of details records

New in ASPRunner Professional 6.0 Beta 1/ 5.2 Build 404 (Sep 16, 2008)

  • DIV-based templates. This means cleaner HTML code and less "Page need to be reset" warnings
  • Data Access Layer generator. This feature will be a great help for those who need to code events don't know SQL
  • New Charts (see online chart builder for examples)
  • Templates Merge- Create a new project using two templates or add a template to existing project
  • Master-details improvements
  • Multiple primary-foreign keys to link tables
  • Number of details records on the list page
  • Inline preview of details records

New in ASPRunner Professional 5.1 Build 318 (Sep 20, 2007)

  • New events/extended list of parameters available in each event
  • Inline Add/Edit on the list page. Add/Edit multiple records at once. Inline Add/Edit use the same input controls that appear on regular Add/Edit pages. All BeforeAdd/AfterAdd/BeforeEdit/AfterEdit events are supported by inline functions. Totals will be recalculated after new record is added or edited.
  • Security enhancements
  • Admin user is implemented as an Admin group which allows multiple admins
  • Separate OwnerID for each table
  • New, nice looking layouts: Default, Amsterdam, Rome, Paris, Madrid, and London.

New in ASPRunner Professional 5.0 build 261 (May 23, 2007)

  • Reports (outline, stepped, align, block and tabular layouts)
  • Charts (line, pie, doughnut, horizontal/vertical bars, 3D charts etc.) We use Flash-based charts developed by AnyChart.com
  • Business templates and visual themes
  • AJAX-based functionality:
  • Google-like auto-suggest feature on basic and advanced search pages
  • AJAX-based dependent dropdown boxes mean faster page load
  • mouse over link to Details table to see detail records without proceeding to the details page
  • "Lookup wizard as Edit box" feature - edit box with autosuggest

New in ASPRunner Professional 3.2 (May 2, 2006)

  • � Builtin FTP Client to upload ASP pages to the Web server
  • � User self-register page, password reminder, change password function
  • � Multilingual templates. Ability to choose language while logging in
  • � Use drop-down boxes, date-pickers, checkboxes on the Advanced search page
  • � Allow direct links to Edit, Add, Search results page
  • � Display "Please wait" message while search results page is loaded
  • � Copy a record function
  • � Tables menu on the list page. Allow to reorder tables in the tables menu
  • � Multiple ORDER BY fields
  • � Linked dropdown boxes on Edit/Add
  • � Upload files to some folder on the Web server.