- of
eWEEK Labs Walk-through: SQL Anywhere Version 11
by 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.
Application Development News & Reviews 
Data Center Efficiency: 10 Tips to Boost Productivity, Reduce Pow[..]
iPhone Apps to Kick Off the 2012 Summer Season 
Email Security: 10 Steps for Dealing With Dangerous Messages
New iPad, Nokia Lumia 900: 10 Gadgets to Boost Your Summer Produc[..]
Smartphone Winners and Losers: 10 Handsets on the Market Now
Microsoft Windows 7, Windows 8 Look to Redefine PC Experience
See All Slideshows
SQL Anywhere gives programmers full relational database access through SQL on a mobile device running Windows Mobile.