Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » SQL Anywhere for Windows Mobile » Tutorial: Managing Windows Mobile databases with Interactive SQL

 

Lesson 3: Executing queries against a Windows Mobile database

Use Interactive SQL to view and manipulate the data and add and modify database objects in your Windows Mobile database.

Prerequisites

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Starting the sample database.

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Managing Windows Mobile databases with Interactive SQL.

Context and remarks

One of the principal uses of Interactive SQL is to browse table data. Interactive SQL retrieves information by sending a request to a database server. The database server looks up the information and returns it to Interactive SQL.

 Task

  1. In Interactive SQL, execute the following statement:

    SELECT * FROM Employees;

  2. From the SQL menu, click Execute to execute the statement.

    All the data from the Employees table appears in the Results pane.

  3. From the SQL menu, click Disconnect to disconnect Interactive SQL from the Windows Mobile database.

Results

You executed a query to browse table data and disconnected your Windows Mobile database from Interactive SQL.

Next

(Optional) Shut down the database server on your Windows Mobile device.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0