Blog: Posts from July, 2017

Labels
AJAX(112) App Studio(7) Apple(1) Application Builder(245) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) Barcode(2) Barcodes(3) BLOB(18) Business Rules(1) Business Rules/Logic(140) BYOD(13) Caching(2) Calendar(5) Charts(29) Cloud(14) Cloud On Time(2) Cloud On Time for Windows 7(2) Code Generator(54) Collaboration(11) command line(1) Conflict Detection(1) Content Management System(12) COT Tools for Excel(26) CRUD(1) Custom Actions(1) Data Aquarium Framework(122) Data Sheet(9) Data Sources(22) Database Lookups(50) Deployment(22) Designer(177) Device(1) DotNetNuke(12) EASE(20) Email(6) Features(101) Firebird(1) Form Builder(14) Globalization and Localization(6) How To(1) Hypermedia(2) Inline Editing(1) Installation(5) JavaScript(20) Kiosk(1) Low Code(3) Mac(1) Many-To-Many(4) Maps(6) Master/Detail(36) Microservices(4) Mobile(63) Mode Builder(3) Model Builder(3) MySQL(10) Native Apps(5) News(18) OAuth(9) OAuth Scopes(1) OAuth2(13) Offline(20) Offline Apps(4) Offline Sync(5) Oracle(11) PKCE(2) Postgre SQL(1) PostgreSQL(2) PWA(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(183) Reports(48) REST(29) RESTful(29) RESTful Workshop(15) RFID tags(1) SaaS(7) Security(81) SharePoint(12) SPA(6) SQL Anywhere(3) SQL Server(26) SSO(1) Stored Procedure(4) Teamwork(15) Tips and Tricks(87) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(338) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(40) Web.Config(9) Workflow(28)
Archive
Blog
Posts from July, 2017
Friday, July 21, 2017PrintSubscribe
Addendum for 8.6.5.0 Release Notes

Some additional information is available below on the fixes and new features present in release 8.6.5.0.

  • New Feature: Support for Report Viewer 2016. Microsoft Visual Studio 2017 RDLC editor automatically upconverts RDLC files to the latest format, incompatible with earlier versions of Report Viewer. Starting in 8.6.5.0, .NET 4.5 or 4.6 apps created on a computer with VS2017 installed will be prompted to automatically download Report Viewer 2016 Runtime and SQL CLR Types 2016. The required files will be copied into the ~/bin folder of the app.

  • New Feature: Support for Microsoft Graph OAuth Handler. Microsoft Graph offers a single API to offer Single Sign-On for users with a Microsoft, Windows Live, Office, Azure, or Azure Active Directory accounts. Simplified instructions are as follows:

    a. Add SiteContent to your app, if not already enabled. 
    b. Register your app at https://apps.dev.microsoft.com
    c. Copy the Application Id. This is your Client ID.
    d. Generate a new password. This is your Client Secret.
    e. Press “Add Platform”. Select “Web”. Enter the Redirect URL of “https://[yourwebsite]/appservices/saas/msgraph”
    f. Insert the following record to the SiteContent table:
        File Name: msgraph
        Path: sys/saas
        Text:
           Tenant ID: [TenantID or “common”]
           Client ID: [ApplicationID]
           Client Secret: [Press “Generate New Password”]
        Redirect Uri: [URL of site]/appservices/saas/msgraph        
           
    d. Append “Sync Roles: true”, save the record, reselect, and push “ADD SYSTEM IDENTITY” if you desire to synchronize groups from your Azure AD or Office system.       
    e. Open the login form. The button “LOGIN WITH MICROSOFT” will now be visible.

  • Corrected detection of Visual Studio 2017 and MSBuild tools in order to resolve compilation and publishing issues.

  • Apps with Active Directory Membership will no longer throw “asp_CheckSchema” exception.

  • “Membership uses standalone database” option will now stay selected.

  • BusinessRules.UserId will no longer throw an exception if the user is not logged in.

  • RowFilterOperation.IsEmpty and IsNotEmpty have been added.

  • Developers can now copy controller views onto pages in the Project Designer.

  • DotNetNuke projects compile correctly.

  • “Select All” option displayed in basket lookups.

  • Action “Select” with When Last Command Name of “Update” now works correctly in reopening the form after a record is updated.

Monday, July 17, 2017PrintSubscribe
July 2017 Hotfixes 2

Code On Time release 8.6.5.0 introduces the second collection of July hotfixes described below:

  • Added support for ReportViewer 2016.
  • Trust Origin URI specified for Report Viewer 2016 to ensure reporting DLLs loading correctly after being copied to another machine.
  • Windows Live OAuth Handler wrong redirect URI fixed.
  • App generator “User Interface” option now has "Touch UI + Classic" option. When "Touch UI" is set, no Desktop themes will be generated.
  • URL Hashing in HTML implementation is now fixed.
  • New projects will not permit “space” characters in the name.
  • Reports Viewer version is now a variable stored in the project file.
  • Fixed issues with Report Viewer version not detecting when generating from Project Designer.
  • Home page of the app generator displays the descending order of projects
  • Older ReportViewer references are removed from the VS project file.
  • ReportViewer DLL files are copied to the “bin” folder only when v14 is used.
  • Added MSGraphOAuthHandler implementation.
  • "Login with Microsoft" button appears on login page when MSGraph config entry is present in the site content.
  • Fixed exception in BusinessRules.UserId implementation raised when user is not logged in.
  • Added "IsEmpty" and "IsNotEmpty" to row filter operations. New options can be used in “soft” filters set on the server.
  • Fixed DotNetNuke Factory project compilation issues.
  • Touch UI: Fixed. Multi-select checkboxes are not cleared after Batch Edit.
  • Touch UI: New “Select All” option is displayed when more than one option is available for selection in a basket.
  • Touch UI: Keyboard navigation in the list scrolls the page when item is not visible.
  • Touch UI: Key “Right” goes to the lookup page after selecting “See All”.
  • Touch UI: Last focused field is recorded in the touch.lookup() method to correctly restore input focus when the lookup view is canceled.
  • Touch UI: Blank lookup field shows a popup when scrolled into view.
  • Touch UI: Removed excessive blank space in front of Add Item in empty basket.
  • Touch UI: Calendar is opened in correct position if the date input field has been scrolled into view in IE.
  • Updated app generator to use correct version of MSBuild for VS 2017, 2015, 2013, with MSBuild4.0 as fallback.
  • Touch UI: Command separator is displayed in popup with items for AutoComplete/Lookup.
  • Action with command name Select works correctly after command Update.
  • Fixed issue with Active Directory loading ASP.NET membership provider with no connection string.
  • Dropping/pasting controller view onto page will set the view as well.
  • Ensure "standalone database" checkbox is checked when membership dialog is loaded.
  • Fix for "asp_CheckSchema" exception with custom membership.
Wednesday, July 5, 2017PrintSubscribe
July 2017 Hotfixes

The flowing fixes are implemente in release 8.6.4.0.

  • New Feature: Property CausesCalculate of dataview fields is triggering Calculate event with the trigger set to the field name after any command executed on the rows of the child data view. Learn to create DataView fields in Episode 5 and Episode 7 of To-Do App tutorial.
  • Fixed. Error "$ not defined” is raised when activating project models and settings in the app generator on some machines.
  • Fixed. Specifying $quickfind or $quickfinddisabled in Search Options of a data field will break advanced search. This properties are designed for server-side optimazation of quick find feature but were causing incorrect behavior of Advanced Search screens.
  • Fixed. Clicking on thumbnail for non-image BLOBs will not open file in the new window
  • Fixed. Check boxes do not render in read-only mode in forms.
  • Changed custom JS loading to read only from "~/js/custom". Release 8.6.3.0 has linked any files in the ~/js folder to the main combined script.
  • Fixed. Collapse/Expand tooltips are not displayed on chevrons in categories.
  • Fixed. Map of suppliers crashes with a system alert when address has not been resolved correctly.
  • Fixed. Advanced Search / Filter controls will correctly display a filter applied by sidebar calendar.
  • Fixed. Mouse selection of dates in the calendar will set up the cursor at the end of date input field.
  • Fixed issue with Calendar and Mini Calendar corrupting advanced search.
  • Fixed. It is now possible to create models for Oracle and other database engine when only one data schema is present.
  • Fixed. Removed unncessary parameters created IsNotNullFilterFunction and IsNullFilterFunction that were causing an exception in Oracle-based projects.
  • Removes all role providers for Oracle projects in Web.Config.
  • Fixed. MySQL Membership/Role providers are cleared.
  • Fixed. Theme selector correctly previews themes in Free edition.
  • Membership connection string handling is fixed.
  • Fxied. Correct membership connection string is selected when membership is Custom.

We expect to release one more maintenance update this month. It will introduce a few features that are missing in Advanced Search 3.0 – “deep” search and history. History is expected to be displayed in both Search box and Adavanced Search forms.

Another feature of the upcoming maintenance update is enhanced RTF editor. 

Maintenance update will also introduce a new folder structure and naming for JavaScript and CSS files. We are moving things into ~/js and ~/css folders. Old folders ~/touch and ~/scripts will be removed. This is being done in a preparation for the native client generation. This is also the reason why we will replace XML format of data controller files with JSON. This is a big change that will not affect anything in the app. Application will perform internal transformation of JSON files into XML, so no behavior of the apps will be changed. JSON format of data controllers is core of offline feature and is the foundation of the upcoming CoT v9.

We expect the update to go out in a couple of weeks.

It will be followed by release 8.7.0.0 that will bring to life the native apps. Expected release date is the last week of July or early August.