Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Starting and connecting to your database » SQL Anywhere for Windows Mobile » Administration utilities on Windows Mobile » Tutorial: Managing Windows Mobile databases with Interactive SQL

 

Lesson 3: Executing queries against a Windows Mobile database

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

 Execute a SQL statement on a Windows Mobile database
  1. In the SQL Statements pane, 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 from the Windows Mobile database.

 Where do I go from here?
 See also