Application Development: eWEEK Labs Walk-through: SQL Anywhere Version 11

 
 
By Jeff Cogswell  |  Posted 2008-11-12
 
 
 

eWEEK Labs Walk-through: SQL Anywhere Version 11

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

eWEEK Labs Walk-through: SQL Anywhere Version 11

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 2

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.

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 2

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 3

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.)

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 3

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 4

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.

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 4

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 5

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.

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 5

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 6

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.

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 6

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 7

 

eWEEK Labs Walk-through: SQL Anywhere Version 11 - Page 7

Rocket Fuel