Databases access Constants

 

Constants Value Descriptions
Databases types
cddbBigInt 16 Long Numeric type(8 bytes)
cddbBinary 9 Binary type
cddbBoolean 1 Boolean type (2 bytes)
cddbByte 2 Byte type (1 byte).
cddbChar 18 Char type (1or 2 bytes)
cddbCurrency 5 Currency type (4 bytes)
cddbDate 8 Date type
cddbDecimal 20 Decimal type
cddbDouble 7 Double (8 bytes)
cddbGUID 15 Identifier
cddbInteger 3 Integer type (2 bytes)
cddbLong 4 Long integer type (4 bytes)
cddbMemo 12 Memo type (for large text or binary data)
cddbNumeric 19 Numeric type
cddbSingle 6 Float type (4 bytes)
cddbText 10 String type (no more than 256 characters)
cddbTime 22 Time type
cddbTimeStamp 23 Date and time
Parameters types
cddbInput 1 Input
cddbInputOutput 2 Input/Output
cddbOutput 4 Output
Cursor types
cddbCursorForwardOnly 1 The cursor can move only forward and is not sensitive to changes in the database.
cddbCursorKeyset 2 The cursor is sensitive to updates in the database.
cddbCursorDynamic 4 The cursor is sensitive to all changes in the database.
cddbCursorStatic 16 The cursor is not sensitive to changes in the database.
Cursor move direction
cddbMoveNext 1 Allows using MoveNext
cddbMoveFirst 2 Allows using MoveFirst
cddbMoveLast 4 Allows using MoveLast
cddbMovePrevious 8 Allows using MovePrevious
cddbMoveAbsolute 16 Allows using Move for absolute positioning
cddbMoveRelative 32 Allows using Move for relative positioning
Transaction types
cddbTransReadUncommited 1

Transaction doesn't isolate each other. There are following situations may occur:
Dirty Read. Transaction 1 changes a row. Transaction 2 reads the changed row before transaction 1 commits the change. If transaction 1 rolls back the change, transaction 2 will have read a row that is considered to have never existed.
Nonrepeatable Read. Transaction 1 reads a row. Transaction 2 updates or deletes that row and commits this change. If transaction 1 attempts to reread the row, it will receive different row values or discover that the row has been deleted.
Phantom. Transaction 1 reads a set of rows that satisfy some search criteria. Transaction 2 generates one or more rows (through either inserts or updates) that match the search criteria. If transaction 1 reexecutes the statement that reads the rows, it receives a different set of rows.

cddbTransReadCommited 2 "Dirty Read" not allowed.
cddbTransRepeatableRead 4 "Dirty Read" and "Nonrepeatable Read" not allowed.
cddbTransSerializable 8 "Dirty Read", "Nonrepeatable Read" and "Phantom" not allowed.
Conformance levels
cddbLevel0 0 Minimal conformance level
cddbLevel1 1 Base conformance level
cddbLevel2 2 Extended conformance level
Driver type
cddbODBC 0 ODBC driver