d32dbms.h File Reference

KDbMaxName

const TIntKDbMaxName

The maximum length for a DBMS name: 64 characters.

KDbMaxColName

const TIntKDbMaxColName

The maximum length for a DBMS column name: 64 characters.

Typedef TDbName

typedef TBuf< KDbMaxName >TDbName

Represents a writable DBMS name. It maps to a modifiable buffer descriptor with maximum size KDbMaxName.

Notes:

A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.

Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.

See also: TBuf

Typedef TDbNameC

typedef TBufC< KDbMaxName >TDbNameC

Represents a non-writeable DBMS name. It maps to a non modifiable buffer descriptor with maximum size KDbMaxName.

Notes:

A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.

Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.

See also: TBufC

Typedef TDbColName

typedef TBuf< KDbMaxColName >TDbColName

Represents a writable DBMS column name. It maps to a modifiable buffer descriptor with maximum size KDbMaxColName.

Notes:

A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.

Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.

Typedef TDbColNameC

typedef TBufC< KDbMaxColName >TDbColNameC

Represents a non-writable DBMS column name. It maps to a non-modifiable buffer descriptor with maximum size KDbMaxColName.

Notes:

A DBMS name must begin with an alphabetic character, after which any alphabetic, numeric or the _ (underscore) character may be used. DBMS names are also limited to 64 characters in length.

Table names must be unique within a database, and columns and indexes must have unique names within the table to which they belong. For the purposes of uniqueness and identification, the names are folded before comparison, so two columns named column_one and Column_ONE are considered to have the same name.

See also: TBufC

Typedef TDbColNo

typedef TInt TDbColNo

Specifies when DBMS objects require a column ordinal to identify a column in a column set or in a rowset.

Note that KDbNullColNo is a special value of TDbColNo used to indicate that no such column exists.

KDbNullColNo

const TDbColNoKDbNullColNo

Indicates that a specified column does not exist.

KDbUndefinedCount

const TIntKDbUndefinedCount

A value returned by RDbRowSet::Count() when the number of rows cannot be determined.

See also: RDbRowSet

KDbUndefinedLength

const TIntKDbUndefinedLength

The length of a column is undefined.

KDbDefaultTextColLength

const TIntKDbDefaultTextColLength

The default text column length. This is equal to 50.

Enum TDbColType

Represents every supported column type.

EnumeratorValueDescription
EDbColBit

The column stores a single bit.

Representation range: 0 to 1

Storage: 1 bit

Auto-increment: Yes

Index key: Yes

EDbColInt8

The column stores an 8-bit signed integer.

Representation range: -2^7 to 2^7 - 1

Storage: 1 byte

Auto-increment: Yes

Index key: Yes

EDbColUint8

The column stores an 8-bit unsigned integer.

Representation range: 0 to 2^8-1

Storage: 1 byte

Auto-increment: Yes

Index key: Yes

EDbColInt16

The column stores a 16-bit signed integer.

Representation range: -2^15 to 2^15 - 1

Storage: 2 bytes

Auto-increment: Yes

Index key: Yes

EDbColUint16

The column stores a 16-bit unsigned integer.

Representation range: 0 to 2^16-1

Storage: 2 bytes

Auto-increment: Yes

Index key: Yes

EDbColInt32

The column stores a 32-bit signed integer.

Representation range: -2^31 to 2^31 - 1

Storage: 4 bytes

Auto-increment: Yes

Index key: Yes

EDbColUint32

The column stores a 32-bit unsigned integer.

Representation range: 0 to 2^32-1

Storage: 4 bytes

Auto-increment: Yes

Index key: Yes

EDbColInt64

The column stores a 64-bit signed integer.

Representation range: -2^63 to 2^63 - 1

Storage: 8 bytes

Auto-increment: No

Index key: Yes

EDbColReal32

The column stores a 32-bit floating point value.

Representation range: 1.4 X 10^-45 to 3.40282 X 10^38

Storage: 4 bytes

Auto-increment: No

Index key: Yes

EDbColReal64

The column stores a 64-bit floating point value.

Representation range: 2.2 X 10^-308 to 1.79769 X 10^308

Storage: 8 bytes

Auto-increment: No

Index key: Yes

EDbColDateTime

The column stores a date/time value.

Representation range: 1/1/0 to 31/12/9999

Storage: 8 bytes

Auto-increment: No

Index key: Yes

EDbColText8

The column stores a (short) variable length of non-Unicode text data.

Representation range: 0 to 256 characters

Storage: 0 to 256 bytes

Auto-increment: No

Index key: Yes

EDbColText16

The column stores a (short) variable length of Unicode text data.

Representation range: 0 to 256 characters

Storage: 0 to 512 bytes

Auto-increment: No

Index key: Yes

EDbColBinary

The column stores a (short) variable length of untyped data.

Representation range: 0 to 255 bytes

Storage: 0 to 256 bytes

Auto-increment: No

Index key: No

EDbColLongText8

The column stores a potentially large amount of non-Unicode text data.

Representation range: 0 to 2^31 characters

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: Truncated

EDbColLongText16

The column stores a potentially large amount of Unicode text data.

Representation range: 0 to 2^30 characters

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: Truncated

EDbColLongBinary

The column stores a potentially large amount of untyped data.

Representation range: 0 to 2^31 bytes

Storage: 0 to 2 Gbytes

Auto-increment: No

Index key: No

EDbColTextEDbColText16

This is equivalent to EDbColText8 if the build is narrow, and EDbColText16 if the build is Unicode.

EDbColLongTextEDbColLongText16

This is equivalent to EDbColLongText8 if the build is narrow, and EDbColLongText16 if the build is Unicode.

Enum TDbTextComparison

Represents different ways of comparing Text and LongText columns.

This affects the ordering of indexes (see CDbKey), the evaluation of SQL queries and matching row constraints (see TDbQuery).

EnumeratorValueDescription
EDbCompareNormal

Use standard text comparison and ordering.

EDbCompareFolded

Use folded text for comparison and ordering.

EDbCompareCollated

Use collation for comparison and ordering.

KDbUnlimitedWindow

Typedef CDbTableNames

typedef CDbNames CDbTableNames

Typedef CDbIndexNames

typedef CDbNames CDbIndexNames

Typedef CDbDatabaseNames

typedef CDbNames CDbDatabaseNames

KDbMaxStrLen

const TIntKDbMaxStrLen

The maximum length for a generic DBMS string, which might be transferred from DBMS server to the DBMS client using IPC.

Typedef TDbStringC

typedef TBufC< KDbMaxStrLen >TDbStringC

Represents a generic read-only DBMS string. It maps to a non-modifiable buffer descriptor with maximum size KDbMaxStrLen.

See also: TBufC