List of Figures

3-1 Fast Refresh Synchronization

3-2 Upload/ Download Phases

3-3 Apply/Compose Phases

3-4 Mobile SQL and Mobile Sync Icons

3-5 Installed Files

3-6 Oracle Mobile Sync screen

4-1 Main Form for Palm

4-2 Order Form

4-3 Order Item Form

5-1 ODBC with C/C++ Development Interface

5-2 Code Warrior Sample Screens

5-3 Mobile SQL

5-4 Mobile SQL Tables

5-5 Sample Mobile SQL Table

5-6 SELECT Statement Example

5-7 New Project Menu

5-8 Target Settings

5-9 Access Paths

5-10 CodeWarrior Preferences

5-11 Mobile SQL and Mobile Sync Icons

5-12 Configuring Transport for Mobile Server

5-13 Network Preferences Screen

5-14 Login Screen

5-15 mSync Screen

6-1 Welcome Panel

6-2 Select Platform Screen

6-3 Application Panel

6-4 Files Panel

6-5 Filter Dialog Panel

6-6 Database Tab Screen

6-7 Snapshots Panel

6-8 New Snapshot Panel

6-9 Index Creation

6-10 Database Connection Panel

6-11 Table Selection Panel

6-12 Edit Snapshots Panel

6-13 Application Definition Panel

6-14 Publish Application Window

B-1 CREATE TABLE Statement Syntax

B-2 DROP TABLE Statement Syntax

B-3 CREATE INDEX Statement Syntax

B-4 DELETE Statement Syntax

B-5 DROP INDEX Statement Syntax

B-6 INSERT Statement Syntax

B-7 SELECT Statement Syntax

B-8 UPDATE Statement Syntax

B-9 COMMIT Statement Syntax

B-10 ROLLBACK Statement Syntax

B-11 WHERE Clause Syntax

D-1 Mobile SQL Overview

D-2 Mobile SQL Database Screen

D-3 Table View

D-4 Command Entry Menu

D-5 Example of Row Edit

E-1 Structural Description of the Client Device and Palm OS