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.

To execute a SQL statement against a Windows Mobile database

  1. In the SQL Statements pane, execute the following statement:

    SELECT * FROM Employees;

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

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

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

Where do I go from here?

Once you connect to a database from Interactive SQL, you can view and manipulate the data, as well as add and modify database objects.

For information about Interactive SQL, writing queries, and using SQL statements, see:

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0