UltraLite 9.0.1 introduces several new features:
UltraLite.NET controls A set of controls are added to your Visual Studio.NET 2003 toolbox to make it easier to specify connection parameters and to monitor synchronization from UltraLite.NET applications.
CREATE and DROP statements in dynamic SQL CREATE/DROP TABLE and CREATE/DROP INDEX statements are now available in dynamic SQL. For users of UltraLite components, these statements provide a way of changing the schema of an UltraLite database.
Transaction control from dynamic SQL COMMIT and ROLLBACK statements are now available in dynamic SQL. For users of UltraLite components, these statements provide a way of using SQL statements to control transactions. They provide an alternative to the commit and rollback methods on the connection object.
The HAVING clause is now supported. See UltraLite SELECT statement.
Of particular interest is adding C++ Component dynamic SQL to an existing embedded SQL or static C++ API application, or using embedded SQL to execute general SQL in a primarily C++ Component-based application.
The new functions include db_start_database function (embedded SQL) and StartDatabase method.
CodeWarrior stationery for UltraLite C++ component The stationery Palm OS UltraLite C++ Component App is provided as part of the UltraLite plug-in for CodeWarrior. It assists in building C++ Component applications using CodeWarrior for Palm OS.
The files for the UltraLite plug-in for CodeWarrior are placed on your disk during UltraLite installation, but the plug-in is not available for use without an additional installation step.
Improved UltraLite C/C++ error handling An error callback is now supported for all UltraLite C/C++ interfaces. The callback allows the application to be notified of all errors, and so provides developers with invaluable information during development.
UltraLite components can use the engine The UltraLite database engine, which can accept connections from more than one application, is now available to UltraLite components as an alternative deployment option.
This option is not available to UltraLite for MobileVB or UltraLite ActiveX.
Database conversion tool The ulconv utility is a command line tool for carrying out numerous operations on UltraLite databases, including unloading databases to XML files, loading new databases from XML files, and converting database formats.
See the ULSyncState structure or object for the API you are using.
New Windows CE platform support UltraLite now supports the Smartphone 2002 platform. ActiveSync synchronization is not supported on this platform.UltraLite also supports Windows CE 4.1 on ARM chips in V4T ("thumb") mode.
There are some extensions to the connection parameters as a result of this feature.
ULPalmLaunch and ULPalmExit no longer required UltraLite now supports additional connection-related primitives that provide easier support for maintaining state when an application is closed. As a result of these new features, Palm OS applications no longer require special Palm-specific primitives, including ULPalmLaunch and ULPalmExit.
UltraLite database properties Properties of the UltraLite database are now available to UltraLite component applications. The case sensitivity, collation, and database ID used for global autoincrement values are all available as properties or methods of the Connection object, depending on the API.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|