UltraLite Embedded SQL User's Guide
Embedded SQL Library Functions
void ULEnableGenericSchema( SQLCA * sqlca );
When a new UltraLite application is deployed to a device, UltraLite by default re-creates an empty database, losing any data that was in the database before the new application was deployed. If you call ULEnableGenericSchema, the existing database is instead upgraded to the schema of the new application.
This function can be used by C++ API applications as well as embedded SQL applications. It must be called before dbinit or ULData.Open(). An exception is the Palm Computing Platform, where there is no need to close all cursors before upgrading. Immediately following an upgrade on the Palm Computing Platform the LAUNCH_SUCCESS_FIRST launch code is returned.
Backup before upgradingIt is strongly recommended that you backup your data before attempting an upgrade, either by copying the database file or by synchronizing. |
For more information about the schema upgrade process, see How the schema upgrade works.
sqlca A pointer to the SQLCA. This argument is supplied even in C++ API applications.