What's New in SQL Anywhere Studio
Welcome to SQL Anywhere Studio Version 9
New feature samples
The UltraLite samples are located at 
http://ianywhere.codexchange.sybase.com/servlets/ProjectDocumentList?folderID=283
This sample demonstrates the new UltraLite.NET component. In this sample, you create an UltraLite database based on a .USM (UltraLite schema file). The schema file stores database information such as tables, columns, indexes, and so on. You do not alter the schema of an UltraLite database directly. Instead, you modify a schema file (which typically has the file extension .USM) and upgrade the database schema from that file using a built-in UltraLite function in your application. After the database is created, data is downloaded through MobiLink. Finally, a SQL query, which displays a resultset in a list box, is executed.
ULFoundation was developed as a base platform on which to start the development of a new UltraLite application and as a learning tool. The goal of this project is to help developers understand the portions of an application that directly relate to UltraLite. Platform-specific functionality has been kept to a minimum. The code has been written to be platform-independent where possible. Additional modules are being developed that guide you through adding new features to the basic ULFoundation program. This is an effective tool for demonstrating how UltraLite works and can be used in a variety of applications. There are many ways to go about setting up ULFoundation. Following the instructions in the text files are recommended, but not necessary.
This sample illustrates the addition of Dynamic SQL queries within the UltraLite Component Suite. For this sample, an application was written using the UltraLite.NET API. During the sample, an application is deployed to a CE device along with a pre-created UltraLite database. From this sample, a user can type in any valid SQL SELECT query and the results appear in a list box.
In this sample, two applications (ULapp1 and ULapp2) access the same database on your device using the new multi-process access feature. The first application creates a database. The UltraLite engine starts, allowing you to open the second application, which also connects to the newly created database. The engine remains open as long as at least one of the two applications is open. The engine shuts down automatically when both applications are closed.