eWEEK Labs Walk-through: SQL Anywhere Version 11

eWEEK Labs Walk-through: SQL Anywhere Version 11by Jeff Cogswell

When you develop for the Windows Mobile version of SQL Anywhere, you can use Visual Studio and its familiar design tools. This image shows the form as it looks inside the designer, complete with a Windows Mobile skin.

As the SQL Anywhere server starts on the Windows Mobile device, you can see a log window scrolling with messages about the status of the server. (Fortunately, you can close this up so you can run your other apps while the server remains running in the background. When you open it again, you’ll still see the log messages from when the form was closed.)

Once connected, the sample application can perform SQL queries against the database. This screen shows how the sample app displays the result set in a grid control.

This particular device can switch to landscape mode, and the sample app adjusts accordingly. Here you can see the results of a query that includes a “where” clause.

The SQL Anywhere engine supports more complex queries, including joins and even stored procedures. In this image you can see the results of a query joining two tables together and only retrieving three columns.