To illustrate portal functionality, this lesson teaches you how to build a simple mobile application that displays content from the warehouse_inventory table in the SybStore database.
To work with a table in the SybStore database, you must start the database and establish a connection to it from WorkSpace.
In the WorkSpace Navigator, expand MySybStore_Tutorials/Setup/Database and double-click startMySybStore.bat to start the SybStore database.
In the Enterprise Explorer view, right-click the MySybStore connection profile and select Connect from the context menu.
In the WorkSpace main window, s elect File|New|Mobile Application from the main menu bar.
When the New Mobile Application wizard opens, complete these options:
Connection Profile – select MyMobileServer.
Mobile Application Name – enter SybStoreItems.
Status – select Approved.
Launch Element Wizard – select this option and select Database as the value.
Click Finish. The New Mobile Application Element dialog box opens.
Add a SELECT statement to the mobile application. Select the Connection Profiles option and select MySybStore as the value.
Below the SQL Query pane, verify that Select is the value in the Visual SQL field, then click the Visual SQL button. The Visual SQL Select wizard opens.
In the Select Tables window, select warehouse_inventory and click Open. The wizard displays three main views:
Table Layout – to select columns.
Where – to create a more complex SQL statement by adding and nesting clauses. The tabs at the bottom of the view represent different clauses of a SQL statement appear at the bottom of the lower view.
Preview – displays a preview the of the SQL statement you are creating.
In the Table Layout pane, select (highlight) the item_desc column, then select the curr_qty column. These columns are added to Selection List bar and display in the Preview.
Select Design|Execute from the menu bar to run the query. Look at the Results tab to view the output from the SELECT query.
Click OK to save the statement. When you return to the New Mobile Application Element wizard, the SQL Query field is now populated.
Because the data will be displayed on a mobile device, verify that the columns are short and named appropriately.
In the SQL Query pane, change the SQL statement to the following text so that the description is a maximum of 30 characters and the column names are more appropriate.
SELECT substring(warehouse_inventory.item_desc,1,30)
"Item Description", warehouse_inventory.curr_qty
"Curr Qty" FROM warehouse_inventory
Click Validate. When you see a message that the SQL query validated successfully, click OK.
If the SQL query does not validate successfully, repeat
steps 11and 12, and verify that the information is entered correctly.
Click Preview.
Click Next.
When the Rules dialog box of the wizard opens, select the Records Contain Labels option and click Finish. You return to the mobile application editor.
Select File|Save from the WorkSpace main menu to save the mobile application.
Select the Preview tab to see a preview of the new mobile application.
Close the mobile application by clicking the “X” on the application’s title tab.
