This procedure describes how to define the drill-down application named SSCA Department. This application displays the employees in a department. The application uses an @OP tag to dynamically select rows from the database to replace the Dept Name parameter. See “Using the @OP tag to insert parameters” for information.
Defining the SSCA Department application
In Mobile Web Studio, select Applications from the Build menu in the left pane, select New under Application Manager, and click the New button to launch Application Builder.
Click the down-arrow to the right of Add, and select Database Element.
In the Database Elements Definition window, enter JDBC connection information needed for the application to access a database and extract specific database information.
The values in the following example assume that the database included with Mobile Web Studio—sampledb—has been started and that it is accessible on port 4747.
Click the JDBC URL option button.
Complete these options:
Username – enter dba,
which is the user name used to access the database.
Password – enter SQL,
which is the password used to access the database.
JDBC Connect URL – enter the URL used by JDBC to connect to the database:
jdbc:sybase:Tds:localhost:4747?ServiceName= sampledb
JDBC driver – enter the JDBC driver used to connect to the database, in this case:
com.sybase.jdbc2.jdbc.SybDriver
SQL Query String – enter the following SQL code to select department heads for each department from sambledb:
select e.emp_fname + ' ' + e.emp_lname as Employee from employee e, department d where e.dept_id = d.dept_id and '@OP["Dept Name"="Shipping"]' = d.dept_name
Notice the use of the @OP tag. This indicates that the application uses a parameter (Dept Name) to replace the tag at run time. If the parameter is not defined, the @OP tag will be replaced by the default value, Shipping. This ensures that previews, where parameters may not be explicitly defined, result in some valid data being returned.
When you create an application with input parameters,
you must define a default value to register as click-across event listeners.
UI XSLT – leave this field empty.
Click Preview. A one column table showing Employee displays in the Preview panel.
Employee |
|---|
Jeannette Bertrand |
Jose Martinez |
Jane Braun |
Felicia Kuo |
Charles Crowley |
Joseph Barker |
Anthony Rebeiro |
Sheila Romero |
Michael Lynch |
Click Next. The Split window displays.
Click Next. The Define window displays.
On the Define window displays, identify record 1 as the header row. In the Define Record Layout section:
Click “Record Contains Labels.”
Accept the default 1,
and click Next. The Filter window displays.
Click Next. The parameter definition window displays with a list of parameters.
On the parameter definition window, specify “shipping” as the default Department Name for the @OP tag, and define Dept Name as the default value. Accept the defaults including:
Variable – select the Variable option to the left of Dept Name.
Display Name – accept Dept Name.
Default Value – accept Shipping.
Type – accept Text Field.
Click Next. The Window Preview displays.
In Element Name, enter SSCA Department as
the element name. Under Window Preview, notice the grid showing Employee.
Click Next.
In the Continuous Capture Page window, click Finish.
When you return to the Application Builder, click Save.
In the Finish window, make this change (otherwise accept the defaults):
Name – enter SSCA
Department.
Click Finish to create the application.
Click OK to confirm.
Click Close to exit the Application Builder.
In Mobile Web Studio, approve the application:
Right-click the SSCA Department application in the detail pane, and select Approval Status | Approved.
Click OK to confirm.
Select Approved from the Application Manager Status menu. You see your newly approved SSCA Department application in the detail pane.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
