Release Notes

Labels
AJAX(112) App Studio(9) 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(178) 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(184) 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(3) 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
Release Notes
Sunday, January 31, 2010PrintSubscribe
Universal Annotations and Dynamic Field Configuration

We are announcing immediate availability of two new features in Web Site Factory and Data Aquarium Framework premium projects. The features are included in the latest release of the product and are available to all subscribers to the Premium Projects.

Universal Annotations

This feature allows end users to extend any data records exposed by your application with custom annotations and attachments. Users can activate this feature on demand and enter notes and attach any number of files. The notes and attachments are stored outside of the application database in a specified folder.

You can activate this feature for the entire application or for individual data controllers.

The live demo is available at http://dev.codeontime.com/demo/annotations/pages/customers.aspx.

Click on the link above and sign in as admin/admin123% or user/user123% . Select any customer record and press edit button. Action Annotate will become available on the action bar of the form.

image

Click on Annotate button and the screen will transform as follows. New category Notes and Annotations is dynamically added to the form layout.

image

Enter a note and attach a few files. The screen will transform into the following. The category Notes and Attachments will move to a dedicated tab. Each note and attachment are presented as fields of the data record.

image

This feature requires no coding and may prove to be invaluable when end users are in the need of custom fields that were not incorporated in the database by design.

Note that users in role Administrators are allowed to add and delete notes and attachments. All other roles are only allowed to add new notes and attachments . Every note and attachment label incorporates the user name, email, and time-stamp.

Dynamic Field Configuration

Dynamic field configuration allows to provide data-driven run-time properties of individual data fields.

Here is the dynamic configuration of ProductName field in Products data controller.

image

Expression HeaderText=CategoryCategoryName will force the Data Aquarium Framework to use the name of the product category as the HeaderText of the field.

You can see this in action at http://dev.codeontime.com/demo/annotations/pages/products.aspx.

The grid view automatically uses the category name of the first record on the page or the category name of the selected product as a header text of the first column.

image

The same affect is taking place when you view your data in a form.

image 

You can override dynamically many properties of any field in a data controller through stored or calculated database table columns any properties of the fields in a given row. Open ~/App_Code/Data/DataField.cs(vb) to see available data field properties.

image

Dynamic field configuration is a great addition to the arsenal of developers building extensible data driven applications.

Thursday, December 31, 2009PrintSubscribe
Masked Editing, Auto Completion, Inline Record Insertion, New Themes

We are ending the year 2009 with a bang!

Here is list of features available in the latest update.

Grid View Allows Inserting New Rows Inline

Action New is now supported in grid views.

image

Here is a record in “New” mode displayed alongside of the other records in the grid view.

image

Masked Editing

Masked editing is supported by components of Ajax Control Toolkit, which provides the foundation for Data Aquarium Framework. Now you can easily enable masked editing in Code OnTime Designer with a a few clicks of a mouse on any field of any data controller. Read about mask format here.

image

Here you can see the masked editing in action:

image

Auto-Completion In Views

New attribute Auto Complete Prefix Length on a data field of a view controls the minimum prefix length for auto-completion to start.

You can quickly define this parameter on a data fields with the help of Code OnTime Designer. Pictured below is the data field City of editForm1 view in Customers data controller. The value of the prefix is set to 1.

image

Here you can see the auto-completion in action:

image

Server-Side Formatting Of Values

Data Aquarium Framework takes every opportunity to offload the processing of presentation logic to the client browser. The standard formatting of values is controlled by the data field property Data Format String. The actual formatting is done via JavaScript String.format function, which has powerful but limited capabilities if compared to .NET System.String.Format.

Now you can simply un-check the Format On Client box in Code OnTime Designer and additional processing will be performed on the server. The data controller will create a dynamic data field and will provide a formatted value for it. The actual field is aliased to present the dynamic data field in read-only mode.

image

Here you can see the [Product].[Discount] field formatted in the column five according to the data format string 00.00 shown in the previous screen shot. Note that this particular data format string is not compatible with the JavaScript implementation of String.format.

image

Html Encoding

Data Aquarium Framework makes sure that user data will not break the presentation when HTML compatible character sequences are entered as field values. Sometimes you might want to have them displayed as an actual HTML.

Suppose you have entered a product category as follows:

Cheeses <b>are great</b>

If you disable HTML encoding for the data controller field directly in the data controller or in Code OnTime Designer then the following will be presented with the phrase “are great” displayed in “bold” font in the Description column of the second grid row.

image

Improved blob Processing

File upload has just became easier with this release. Now you can simply select a file and the uploading starts instantly. A nice AJAX-style animated image is indicating process.

The previous implementation required user to additionally click on submit button next to the file input control.

Five New Themes

Users with Code OnTime Designer subscription are now able to create applications styled with five new themes. You can see samples of these themes presented in various browsers in this very post.

Tuesday, December 22, 2009PrintSubscribe
Date, Time, and DateTimeOffset Data Types

The latest update of the premium projects includes an improved handling of Microsoft SQL Server 2008 data types date, time, and datetimeoffset in generated code and Code OnTime Designer.

Adaptive filtering now works correctly with time and datetimeoffset. Filtering of datetimeoffset fields has been improved to automatically perform range filtering by including in the filtered results any matching dates in a range –14 hours to + 14 hours from the selected date.

Styling of tabs in  Web Site Factory applications has been slightly improved to make them “seem” large even though only 1 pixel of height has been added to tabs. You can see the current styling at http://dev.codeontime.com/demo/WebSiteFactory1/Pages/Home.aspx.

Coming Soon

The upcoming updates will include support for HtmlEncode attribute on fields to allow display of HTML markup stored in the database in the client-side views. The encoding occurs by default. It will be possible to turn it off.

We will be providing additional themes for Web Site Factory applications. The themes will be available to Code OnTime Designer subscribers only.

We are working on support for actions sets. An action set is a collection of action groups that you normally find in data controllers. It will be possible to develop custom action sets and link them to data controllers. This will make data controllers much smaller and will make it easier to maintain large projects.