Code On Time: Tutorials

Tuesday, March 6, 2012Print Subscribe

Orders: Changing Field to Drop Down List

There are only three shipping companies in the Northwind database. By default, the web application generator renders the ShipVia field as a lookup.

A lookup is very useful when there is a long list of options, as it offers sorting, filtering, and quick find. In this situation, the lookup is just a hindrance to the user. Let’s change this lookup to a drop down list.

Go back to the Designer, and expand to the Order Form \ c100 \ dv100 \ editForm1 \ c1 – Orders \ ShipVia node. Double click on ShipVia field, and scroll down to the Lookup section. Change the following settings:

Property	Text
Items Style	Drop Down List
Data Value Field	ShipperID
Data Text Field	CompanyName

Press OK to save. Press Generate, and wait for the page to load. If you edit an order, you will see that Ship Via Company Name field is now a drop down list.

Labels: Tutorials, Web Application Generator

Tuesday, March 6, 2012Print Subscribe

Orders: Displaying Inserted Record in Edit Mode

When we insert a new order, it would be more convenient if the order remained selected and in edit mode.

Switch back to the Designer, and expand Order Form / c100 / dv100 / Actions / ag2 node. Double-click on the last action in the list, a13 - Select.

Change the Command Name to “Edit”.

Press OK to save the action. Press Generate and wait for the Preview to refresh.

Create a new order, and select a customer and employee. Press OK to save the order, and the form will stay in edit mode.

Labels: Tutorials, Web Application Generator

Tuesday, March 6, 2012Print Subscribe

Orders: Resizing Data Fields

Let’s change the length of the data field text boxes to match the expected text length. Go back to the Designer, and navigate to Order Form / c100 / dv100 / editForm1 / c1 – Orders node. Right-click the node and press Show All Data Fields.

This will take you to the list of data fields. Mouse over the field Freight, click on the dropdown arrow, and press Edit.

Enter “5” in the Cols property, press Save to save the data field.

Also change the following data fields:

Field Name	Cols
ShipName	30
ShipAddress	30
ShipCity	30
ShipRegion	30
ShipPostalCode	30
ShipCountry	30

Press Generate, and wait for the page to load. Start editing any order, and you will see that the data fields have been resized.

Labels: Tutorials, Web Application Generator