iAnywhere.com - ULCreateParms class

UltraLite® - .NET Programming
iAnywhere.Data.UltraLite namespace (.NET 2.0)
ULCreateParms class

UL Ext.: Builds a string of creation-time options for creating an UltraLite database.

Prototypes

Visual Basic
Public Class ULCreateParms

C#
public class ULCreateParms

Remarks

A ULCreateParms object is used to specify the parameters for creating a database (CreateDatabase method).

Leading and trailing spaces are ignored in all string values. Values that contain a semicolon (;), or that begin with either a single quote (') or a double quote (") may not contain both single and double quotes.

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 ToString method. The resulting string can then be used as the createParms parameter of the CreateDatabase method.

For more information, see UltraLite Connection String Parameters Reference.

Example

The following code creates the database \UltraLite\MyDatabase.udb on a Windows CE 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.DatabaseOnCE = "\UltraLite\MyDatabase.udb"
' Assumes file coll_1250LATIN2.vb is
' also compiled in the current project
ULConnection.DatabaseManager.CreateDatabase( _
    openParms.ToString(), _
    iAnywhere.UltraLite.Collations.Collation_1250LATIN2.Data, _
    createParms.ToString() _
  )
Dim conn As ULConnection = _
  New ULConnection( openParms.ToString() )
conn.Open()


// C#
ULCreateParms createParms = new ULCreateParms();
createParms.CaseSensitive = true;
createParms.UTF8Encoding = true;
ULConnectionParms openParms = new ULConnectionParms();
openParms.DatabaseOnCE = @"\UltraLite\MyDatabase.udb";
// Assumes file coll_1250LATIN2.vb is
// also compiled in the current project
ULConnection.DatabaseManager.CreateDatabase(
    openParms.ToString(),
    iAnywhere.UltraLite.Collations.Collation_1250LATIN2.Data,
    createParms.ToString()
  );
ULConnection conn = new ULConnection( openParms.ToString() );
conn.Open();

Prototypes

Remarks

Example

See also