UL Ext: Builds a string of creation-time options for creating an UltraLite database.
Public Class ULCreateParms
public class ULCreateParms
All members of ULCreateParms class, including all inherited members.
Name | Description |
---|---|
Initializes a ULCreateParms instance with its default values. | |
Returns the string representation of this instance. | |
Specifies whether the new database should be case sensitive when comparing string values. | |
Specifies the level of database page checksums enabled for the new database. | |
Specifies the date format used for string conversions by the new database. | |
Specifies the date order used for string conversions by the new database. | |
Specifies whether the new database should be using AES_FIPS encryption or AES encryption. | |
Specifies the default maximum number of bytes to use for index hashing in the new database. | |
Specifies the nearest century used for string conversions by the new database. | |
Specifies whether the new database should be using obfuscation (simple encryption) or not. | |
Specifies the page size of the new database, in bytes or kilobytes. | |
Specifies the floating-point precision used for string conversions by the new database. | |
Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION during string conversions by the new database. | |
Specifies the time format used for string conversions by the new database. | |
Specifies the timestamp format used for string conversions by the new database. | |
Specifies the minimum difference between two unique timestamps, in microseconds (1,000,000th of a second). | |
Specifies whether the new database should be using the UTF8 character set or the character set associated with the collation. |
A ULCreateParms object is used to specify the parameters for creating a database (ULDatabaseManager.CreateDatabase(string,string)).
Leading and trailing spaces are ignored in all string values. Values must not contain leading or trailing spaces, or a semicolon, or begin with either a single quote or a double quote.
Once you have supplied all the creation parameters by setting the appropriate properties on a ULCreateParms object, you create a creation parameters string using the ULCreateParms.ToString. The resulting string can then be used as the createParms parameter of the ULDatabaseManager.CreateDatabase(string,string) method.
For more information, see UltraLite connection parameters.
The following code creates the database \UltraLite\MyDatabase.udb on a Windows Mobile device. The database is created case sensitive and with the UTF8 character set.
' Visual Basic Dim createParms As ULCreateParms = New ULCreateParms createParms.CaseSensitive = True createParms.UTF8Encoding = True Dim openParms As ULConnectionParms = New ULConnectionParms openParms.DatabaseOnDevice = "\UltraLite\MyDatabase.udb" ULConnection.DatabaseManager.CreateDatabase( _ openParms.ToString(), _ createParms.ToString() _ ) Dim conn As ULConnection = _ New ULConnection( openParms.ToString() ) conn.Open() |
The following code is the C# language equivalent:
// C# ULCreateParms createParms = new ULCreateParms(); createParms.CaseSensitive = true; createParms.UTF8Encoding = true; ULConnectionParms openParms = new ULConnectionParms(); openParms.DatabaseOnDevice = ".udb"; ULConnection.DatabaseManager.CreateDatabase( openParms.ToString(), createParms.ToString() ); ULConnection conn = new ULConnection( openParms.ToString() ); conn.Open(); |
ULCreateParms constructor
ToString method
CaseSensitive property
ChecksumLevel property
DateFormat property
DateOrder property
FIPS property
MaxHashSize property
NearestCentury property
Obfuscate property
PageSize property
Precision property
Scale property
TimeFormat property
TimestampFormat property
TimestampIncrement property
UTF8Encoding property
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |