Blog: Posts from April, 2012

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
Posts from April, 2012
Friday, April 13, 2012PrintSubscribe
Controlling Length on Input Fields

Code On Time web applications automatically limit the amount of text that users are allowed to enter in the text-based input fields. The following screen shot shows the createForm1 form view rendered in the new mode.

Users are not able to enter more than 5 characters in the Customer ID and 30 characters in the Contact Name accordingly.

Automatic enforcement of field length in web apps created with Code On Time

The length of fields is controlled by the Length property of data controller fields. The fields with the type String inherit the limit from the maximum length of the database table column. The limit applies to both single-line and multi-line text boxes.

The list of fields in Customers data controller is shown next. Column Len shows the values assigned by the code generator.

Field property 'Length' can be changed in the list of data controller fields in Project Designer

You can also select any String field in Project Explorer and change the Length property there.

Property 'Length' is available in the data controller fields of the 'String' type

The database exception will be raised if the Length property of a field is left blank and a user enters more data than the database is expecting. The record will remain in the edit or new mode.

An error message is displayed if the Length property of the ContactName is cleared and more than 30 characters are enters when creating a new record.

The error message of database exception raised by Microsoft SQL Server when a text longer than the database column maximum length is entered in the field

Thursday, April 12, 2012PrintSubscribe
Interactive History of Recently Viewed Data

It is common for users in a line-of-business application to interact with the same data objects for extended periods of time. In this case, it may help to allow rapid switching between recently viewed objects. This capability can be enabled in the project settings of your Code On Time web application.

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 interactive history of most-recent data objects”.

'Enable interactive history of most-recent-used data objects' option under 'Permalinks and History' of Code On Time Project Wizard

Continue through the wizard. On the Themes page, select Social theme.

'Social' Theme selected in Code On Time Project Wizard

Finish configuring project settings and generate the application. When your default web browser opens, navigate to the Categories page. View several category records. Try viewing master records on other pages of the application. Any record that is displayed in the summary card on the left side of the page will be automatically added to the History of the current browsing session.

Next, click on the History link in the top left corner of the application.

History link in Code On Time web application

An interactive display of summary cards will take up the screen. When you mouse over a card, it will be brought forward. You can click on the spyglass icon to cycle through the cards.

Interactive History in Code On Time web application

Click on any card to navigate directly to the record.

Selected record in Code On Time web application

You can also click on the white space in the background or press the Esc button on your keyboard to close the History.

Thursday, April 12, 2012PrintSubscribe
Displaying Modal Form Views

Web applications generated with Code On Time use an in-place form when a user drills in to a master record, such as the selected Supplier in the picture below.

In-place form view of a selected master record in Suppliers page in Code On Time web application

Modal presentation is used for master data views without children and for child data views. The picture below shows the modal form view displayed when a Product is selected in the child data view.

Modal form view displaying a selected child Products on Suppliers page in web application created with Code On Time

You can change the presentation of a data view using the “Show Modal Form” property.

Start Code On Time web app generator, click on the project name, and press Design. Double-click on Region / Suppliers / container2 / view2 node in the Project Explorer. Uncheck the Show Modal Forms property.

'Show Modal Forms' property unchecked

Press OK to save the data view. On the tool bar, press Generate to regenerate the web application.

When the web application opens in your default web browser, navigate to Suppliers page, and select any supplier. Select a product in the child data view, and you will see the record form opened in-place. Users drill into the details of a record in the grid view.

Both master and child data views using in-place form

There is also an option in the Project Wizard to control modal presentation of form views for the entire application.