Creating the TravelRequest Database Table

Create the database table to be used by the Travel Request mobile business object.

1. From the main menu, select File > New > Other.
2. Select SQL Development > SQL File, and click Next.
3. Enter or select the values shown, then click Finish:

   Field	Value
   Parent folder	Select the MobileWorkflow101 project.
   File name	Enter TravelRequest.
   Database server type	Select Sybase_ASA_12.x.
   Connection profile name	Select My Sample Database.
   Database name	Select sampledb.

   
   
   
4. In the TravelRequest.sql editor, copy and paste this code:

   CREATE TABLE TravelRequest (
       trvl_Id                      integer NOT NULL DEFAULT autoincrement 
      ,trvl_Date                    date NULL 
      ,trvl_Loc                     varchar(20) NULL
      ,est_Cost                     float NULL
      ,purpose                      varchar(200) NULL
      ,trvl_Status                  varchar(20) NULL 
      ,st_Cmmnt                     varchar(200) NULL 
      ,PRIMARY KEY CLUSTERED (trvl_Id) 
   );
   
   

5. Save TravelRequest.sql and close the editor.
   Unwired Workspace adds TravelRequest.sql to the MobileWorkFlow101 project.
6. In the WorkSpace Navigator, expand MobileWorkflow101. Right-click TravelRequest.sql and select Execute SQL Files.
   Unwired Workspace creates a table called TravelRequest in the sampledb database.
7. In the Enterprise Explorer, expand sampledb, expand the Tables folder, and verify that the new TravelRequest table is added.
   If the table is not visible, right-click the Tables folder and select Refresh.