Features

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
Features
Friday, May 11, 2012PrintSubscribe
Feature: Multi-Level Master-Detail Pages

Master-detail relationships exist in all databases. For example, the Northwind database has a three-level master-detail relationship. Customers is referenced by Orders, and Orders is referenced by Order Details.

Customers, Orders, and Order Details table relationships in Northwind database

Code On Time web application generator automatically creates two-level master-detail pages. You can extend any master-detail page to have more relationship levels. An extended three-level master-detail page is shown below.

Three-Level Master-Detail page in Northwind web application.Three-Level Master-Detail page in Northwind web application.

Sunday, April 29, 2012PrintSubscribe
Feature: Automatic Denormalization

Code On Time application generator performs automatic denormalization when constructing application data controllers from tables of a normalized database.

Consider the following subset of tables from the Northwind sample.

Normalized tables Products, Categories, and Suppliers

Product information is stored in three tables. Normalized table Products replaces category and supplier information with ID of data rows stored in Categories and Suppliers tables.

If you run the sample application then the Products page will be presented in a denormalized user-friendly fashion.

Denormalized presentation of products includes category and supplier information

You can control the inclusion of fields in the data controllers with the help of denormalization field map.

Friday, April 13, 2012PrintSubscribe
Creating Permanent Links to Data Records

Application users have an easy way of exchanging links to data records in Code On Time web apps. This feature can be enabled in the project settings.

Start creating a sample Northwind web application. When you reach the Features page, switch to the Permalinks and History section using the box on the left side of the screen. Toggle the checkbox next to “Enable permalinks to allow bookmarking of master records selected by end users”.

'Enable permalinks to allow bookmarking of master records selected by end users' property enabled in Code On Time Project Wizard

Press Next until you reach the Themes page. Select “Ricasso” theme.

'Ricasso' theme selected in Code On Time Project Wizard

Continue configuring settings and generate the web application. When it loads in your default web browser, switch to the Products page. Select any product from the list.

Product selected on Products page in web application generated with Code On Time

In the top left corner of the page, click on Permalink.

Permalink link in top left corner of Code On Time web application

A textbox will appear to the right of the link, showing the permalink to the selected record. If you mouse over the link, it will show you the Product information also shown in the Summary on the side bar. You can email or instant message this link to anyone.

Activated permalink in Code On Time web application

The button immediately to the right of the textbox will add the link to your bookmarks.

Adding a permanent link to a data record to the web browser bookmarks

A user will be required to log in to the web application, when attempting to access the URL of the permanent link.

User is required to log in to view the data record referenced by the permalink

If the user logs in with a valid account, and the access control rules permit the user to view the record, then the record will be displayed.

Data record referenced by a permalink

Continue to Permalinks Feature