Blog: Posts from May, 2011

AJAX(112) Apple(1) Application Builder(242) Application Factory(207) ASP.NET(95) ASP.NET 3.5(45) ASP.NET Code Generator(72) ASP.NET Membership(28) Azure(18) 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(11) 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) DotNetNuke(12) EASE(20) Email(6) Features(99) Firebird(1) Form Builder(14) Globalization and Localization(6) Hypermedia(2) Installation(4) 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(15) OAuth(5) OAuth Scopes(1) OAuth2(6) Offline(14) Oracle(10) PKCE(1) PostgreSQL(2) QR codes(2) Rapid Application Development(5) Reading Pane(2) Release Notes(163) Reports(48) REST(26) RESTful(21) RESTful Workshop(13) RFID tags(1) SaaS(7) Security(75) SharePoint(12) SPA(5) SQL Anywhere(3) SQL Server(26) Stored Procedure(4) Teamwork(15) Tips and Tricks(81) Tools for Excel(2) Touch UI(93) Transactions(5) Tutorials(183) Universal Windows Platform(3) User Interface(331) Video Tutorial(37) Web 2.0(100) Web App Generator(101) Web Application Generator(607) Web Form Builder(39) Web.Config(9) Workflow(28)
Posts from May, 2011
Monday, May 23, 2011PrintSubscribe
Dynamic Client Expressions, Page Base, Resetting Cascading Lookup, etc.

This release of Code On Time web application generator includes several bug fixes and enhancements.

  • Annotations column rendering in Data Sheet view has been enhanced in all themes.
  • It is now again possible to click on a thumbnail of an image field in grid and data sheet view to download the original file stored in the database table column. The first click will activate a row. The second click will initiate the download process.
  • Visual Basic.NET version of generated applications will correctly handle extended upload/download utility fields File Name, Content Type, and File Size.
  • Check boxes are correctly rendered in form views with templates.
  • Read-only and static fields are not causing “Field value is required” error in the user interface when user saves a form even if the field is not set to “Allow Nulls=false”.
  • Client library includes significantly improved processing of Client Script expressions used to evaluate conditional styling and control field / category visibility. All data types are handled correctly. You can also use special JavaScript Date class extensions. For example, the client script Date.$within([RequiredDate], 5) will return true if Required Date is within 5 days as of now. The client script Date.$pastDue([ShipDate], [RequiredDate]) will return true if the ship date of an order is greater than required date or if a ship date is not specified and the time to ship the order has passed. This type of expressions may be useful to specify conditional styling calling for attention.
  • Some enhancements to the system files of the code generation library were deployed to support the upcoming Azure Factory web application generator project.
  • Field property “Copy” now supports expressions in format FieldName=null to support clearing/resetting of cascading lookup fields when the value of the master field has changed. Read about configuring cascading lookups in Code On Time applications at /blog/2011/05/cascading-lookups.html.
  • All pages of the generated applications are now based on Namespace.Web.PageBase. This partial class will detect “right-to-left” cultures and switch the text flow to right-to-left from standard left-to-right. The class will also handle culture/language selection that will be enabled on the membership bar. User Interface Language selection feature will be available in the upcoming releases.
Thursday, May 19, 2011PrintSubscribe
Cascading Lookups

ASP.NET web applications created with Code On Time application generator offer impressive lookup capabilities. Numerous lookup styles allow configuring sophisticated data lookup scenarios including cascading lookups. Cascading lookups is a data lookup scenario involving more than one lookup field.

Example of Cascading Lookups

Consider the fragment of Adventure Works LT database presented below.

Table SalesOrderHeader has three lookup fields. Field CustomerID references table Customer, fields ShipToAddressID and BillToAddressID are referencing the same table Address. Shipping and billing addresses may be represented by the same or different rows in the table Address. The many-to-many table CustomerAddress links a Customer and an Address.

If a new Sales Order Header is created and a customer is identified and associated with the header then it will be logical to assist end users of your application in selecting a customer address by limiting the list of all addresses to those that are matching the selected customer. Selection of one lookup value (CustomerID) in a row must cascade as a filter to other dependent lookups (ShipToAddressID and BillToAddressID).

Configuring Cascading Lookups

If you generate a new Web Site Factory application from the database and start creating a new Sales Order Header then you will see a page similar to the one presented below. The screen shot shows that a customer has been selected already and shipping and billing addresses are blank.


Click on (select) link in Ship To Address Line1 or Bill To Address Line1 and you will be presented with lookup window that allows selecting an address. The entire collection of addresses stored in the database is available for selection. The screen shot shows that the application user has activated the search bar to find the right address and is trying to find an address using predictive input.


Let’s make the task of selecting an address easier and limit the list of addresses to those that are associated with the user account.

First we will examine lookup configuration of ShipToAddressID and BillToAddressID fields.

Run the web application generator, select the project name and click Design to activate the project Designer.

Select “All Controllers” tab and locate SalesOrderHeader data controller.

Click on the controller name and select Fields tab.

Select ShipToAddressID field and click Edit button.

Scroll to Lookup section of the field properties. The configuration of lookup properties is presented below.

Property Items Data Controller is set to Address, which instructs the generated web application to show the first grid view of Address data controller when a user click on (select) link of the lookup field.


If you inspect configuration of BillToAddressID field then you will find that it is exactly the same. This type of configuration is automatically performed by Code On Time web application generator when a baseline application is constructed straight from your database.

Table Address does not offer any information that will help us to identify the addresses that belong to a specific customer.

Table CustomerAddress has a pointer to a Customer and provides a perfect replacement for Address data controller.

By default only the first mandatory field from master table Address is included by the application generator in the data controller CustomerAddress. We suggest defining the following de-normalization map for your project to expand available fields borrowed from master tables in tables CustomerAddress and SalesOrderHeader.

SalesLT.SalesOrderHeader => SalesLT.Customer

SalesLT.CustomerAddress => SalesLT.Customer

SalesLT.CustomerAddress => SalesLT.Address

The application in the screen shots was generated with this de-normalization map.

Let’s change the configuration of field ShipToAddressID as follows:

  1. Set Data Controller property to “CustomerAddress”.
  2. Set Data Value Field property to “AddressID”.
  3. Set Data Text Field property to “AddressAddressLine1”.
  4. Set Content Fields under Dynamic Properties section to “CustomerID=CustomerID”.


Step (4) will instruct the data controller CustomerAddress to filter data by field CustomerID (field on the left hand side of the equal sign) with the value stored in field CustomerID (field on right hand side of the equal sign) in the current row of Sales Order Header data controller.

This change does not effect the command text of the data controller SalesOrderHeader in any practical way. The lookup configuration will be taken into account only when a user selects a value for ShipToAddressID or BillToAddressID field.

Save the changes and modify the field BillToAddressID by following exactly the same steps.

Generate your project, start creating a new Sales Order Header record, select “Family’s Favorite Bike Shop” customer in Customer Company Name field. Try select a shipping or billing address. Only two records will be available for selection. Both records match the selected customer.


Try changing a customer and observe that a different selection of addresses is presented each time.

Lookup Styles

You can change the style of lookups using the Items Style property. If you change the style of CustomerID, ShipToAddressID, and BillToAddressID then the cascading lookup behavior will still take place.

Lookup field CustomerID is presented  in Lookup and  two address reference fields are presented in Auto-Complete styles below.


A combination of Auto-CompleteList Box and Radio Button List lookup styles is shown next.


Clearing Dependent Lookup Fields

Most scenarios of cascading lookups will require  a particular combination of master and detail selections in the lookup fields. If a master values has changed then a cascading clearing of dependent lookup fields may be called for. In fact inconsistent selection of master and detail lookup fields may cause data integrity issues.

An extra step is involved in clearing dependent cascading lookup field values.

Select CustomerID master field in Designer and set its “Copy” property as follows:


The screen shot shows the “Copy” property of CustomerID when opened in Designer.


The primary purpose of “Copy” property is to allow specifying multi-field copy instructions executed upon lookup selection. Read about multi-field lookup at /blog/2010/02/multi-field-lookup.html.

If you enter “null” on the right-hand side of the equal sign then the field value will be cleared when the value of the lookup field has changed. In this particular case any changes to CustomerID field must cause clearing of fields ShipToAddressID and BillToAddressID. Both fields are aliased with ShipToAddressAddressLine1 and BillToAddressAddressLine1 fields accordingly. If you configure only the foreign key fields to be reset upon changes of the master field CustomerID then fields will get cleared but their visual representations will remain intact. Therefore we require clearing of alias fields as well.

Property “Copy” provides surgical level of control over resetting of dependent fields in a cascading lookup field groups. If you have more than one level of dependency then make sure to configure clearing of fields on all levels.

Wednesday, May 18, 2011PrintSubscribe
Bug Fixes, Just-In-Time Formatting of Numbers

The new update includes the enhanced client library. Any numeric values with data format strings are automatically formatted as soon as a field input control loses its focus.

The following issues were resolved in this release:

  • Processing of numeric values entered with percent symbol are correctly converted to  floating values. You can enable Percent data format if you enter letter “p” in the data format string of a numeric field in Designer.
  • Source code generated in Visual Basic projects now uses “TypeOf X is Y” expressions to determine if an instance X is of a specific type Y of if an instance X is implementing interface Y. This corrects the issue that was introduced in last update that had to do with various conversion error messages when business rules were invoked.
  • Client library now correctly processes read only primary key values that are not auto-incremented. This fixes the problem with Designer that was reported as “Cannot create duplicate object” and was preventing creation of page containers and actions.
  • Interactive History is correctly rendered in IE 9 and WebKit browsers.

Make sure to clear the browser cache after re-generating your project.