c-treeDB .NET
Copyright Notice
FairCom Typographical Conventions
Introduction
c-treeDB Background
Function Level API (c-treeDB C API)
Connect to a Database
Open a Table
Add a Record
Class Level API (c-treeDB C++ API)
Create a Database
Create and Open a Table
Add a Record
c-tree and .NET
Quick Tour
C Sharp Tutorials
Introductory Tutorial
Init
Define
Manage
Done
Additional Resources
Relationships
Init
Define
Manage
Done
Additional Resources
Record/Row Locking
Init
Define
Manage
Done
Additional Resources
Transaction Processing
Init
Define
Manage
Done
Additional Resources
Visual Basic Tutorials
Introductory Tutorial
Init
Define
Manage
Done
Additional Resources
Relationships
Init
Define
Manage
Done
Additional Resources
Record/Row Locking
Init
Define
Manage
Done
Additional Resources
Transaction Processing
Init
Define
Manage
Done
Additional Resources
Programmer's Reference
Common Functionality
Objects Disposal
Error Handling
Transaction Processing
Session Wide Locking
Default Date, Time and Float Formats
User Defined Tags
Working with Sessions
Creating a Session Object
Creating a New Session Dictionary
Session Logon and Logout
Session Properties
Server, User Name and Password Properties
Active Property
Path Property
Managing Databases
Creating a New Database
Adding an Existing Database
Dropping a Database
Deleting a Database
First Database
Next Database
Find Database
Database UID (Unique Identifier)
Find Database by UID
Working with Sessions without Dictionary Support
Session Dictionary
Working with Databases
Creating a Database Object
Connecting to a Database
Database Properties
Database Name
Database Path
Table Count
Managing Tables
Adding an Existing Table
Adding an Existing Table Under Transaction Control
Dropping a Table
Dropping a Table Under Transaction Control
Deleting a Table
Deleting a Table Under Transaction Control
First Table
Next Table
Find Table
Table UID (Unique Identifier)
Find Table by UID
Database Dictionary
Working with Tables
Creating a Table Object
Creating a Table Object Without Database Support
Creating a New Table
Adding, Inserting or Deleting Fields
Field Types
Fixed or Variable Length Records
Hidden Fields
Adding or Deleting Indices
Segment Modes
ROWID Index
RECBYT Index
Changing Default Properties
Creating the Table
Creating a Table Under Transaction Control
Opening a Table
Table Open Modes
Opening a Table with a Password
Closing a Table
Altering a Table
Add, Insert, Delete, or Edit Fields
Add, Edit or Delete Indices
Alter the Table
Deleting an Index from a Table
Forcing an Index Rebuild
Forcing a Table Rebuild
Table Properties
Table Name
Table Path
Table File Extension
Index File Extension
Data File Extent Size
Index File Extent Size
Table Password
Table Group ID
Table Permission Mask
Number of Fields
Number of Indices
Field Padding
Update Create Mode
Working with Records
Creating a Record Object
Record Buffer Layout
Sharing the Same Context
Resetting a Record
The Default Index
Selecting the RECBYT Index
Selecting the ROWID Index
Navigating Records
First Record
Last Record
Next Record
Previous Record
Seek to Record
Finding Records
Find Modes
Building a Target Key
Finding Records by Target Key
Finding Records by ROWID
Record Sets
Creating a Record Set
Terminating a Record Set
Record Filters
c-treeACE Expression Parser and Grammar
Constants
Variables
Parentheses
Predefined Functions
Type Casting
Automatic Type Promotion
Operators
Reading and Writing Field Data to a Record Buffer
Automatic Data Type Conversion
Null Field Support
Field Defined Size
Field Actual Length
Field Offset in Record Buffer
Check if Field is Fixed or Variable Length
Using Field Names
Clearing the Record Buffer
Clearing a Field
Adding New Records
Updating Existing Records
Deleting Records
Record Properties
New Record Flag
Edited Record Flag
Record Offset
Record Count
Record ROWID
Record Locking
Check if a Record is Locked
Demoting Record Locks
Data Types
Scalar Types
Date Types
Time Types
Date/Time (Timestamp) Types
Numeric Types
CTBIGINT
CTMONEY
CTCURRENCY
CTNUMBER
Data Integrity
Transactions
Atomicity
Automatic Recovery
Creating Tables for Transaction Processing
Starting a Transaction
Terminating a Transaction
Save Points
Locking
Starting Locks
Lock Modes
Freeing Locks
Freeing Locks Associated with a Table
Working with Resources
Types of Resources
Resource Identification
Resource Type
Resource Number
Resource Name
Compatibility
Compatibility with c-treeACE ISAM and Low-Level Data Files
Compatibility with c-treeACE SQL
Field mapping between c-treeACE SQL, c-treeDB and c-treeDB .NET
c-treeDB .NET Class Reference
c-treeDB .NET Definitions
Field Types
Find Modes
Key Types (KEY_TYPE enum)
Record Lock Modes
Session Wide Lock Modes
Segment Modes
Table Create Modes (CREATE_MODE enum)
Table Open Modes
Table Permissions (TABLE_PERMS enum)
Lib Types (LIB_TYPE enum)
User Profile (USER_PROF enum)
Index Types (IDXNO enum)
Table Types (TABLE_TYPE enum)
System Filters (SYS_FILTER enum)
Index Key Types
CTBase Class
CTBase Public Members
CTBase Methods
CTBase.CTBase
CTBase.~CTBase
CTBase.Abort
CTBase.Begin
CTBase.ClearError
CTBase.ClearSavePoint
CTBase.Commit
CTBase.GetAutoCommit
CTBase.GetDefDateType
CTBase.GetDefFloatFormat
CTBase.GetDefTimeType
CTBase.GetError
CTBase.GetHandle
CTBase.GetHandleId
CTBase.GetHandleType
CTBase.GetKeepLock
CTBase.GetLockMode
CTBase.GetOperation
CTBase.GetSystemConfig
CTBase.GetTableType
CTBase.GetTransactionMode
CTBase.GetUserTag
CTBase.IsLockActive
CTBase.IsTransActive
CTBase.Lock
CTBase.RestoreSavePoint
CTBase.SetAutoCommit
CTBase.SetDefDateType
CTBase.SetDefFloatFormat
CTBase.SetDefTimeType
CTBase.SetError
CTBase.SetHandle
CTBase.SetKeepLock
CTBase.SetOperation
CTBase.SetSavePoint
CTBase.SetTransactionMode
CTBase.SetUserTag
CTBase.SwitchInstance
CTBase.Unlock
CTBigint Class
Class CTBigint
CTBigint Operators
CTBigint.operator =
CTBigint.operator <, <=, >, >=, ==, !=
CTBigint Methods
CTBigint.CTBigint
CTBigint.~CTBigint
CTBigint.AsBigint
CTBigint.AsFloat
CTBigint.AsLong
CTBigint.AsMoney
CTBigint.AsString
CTBigint.IsZero
CTBigint.SetBigint
CTBigint.Zero
CTBlob Class
Class CTBlob
CTBlob Operators
CTBlob.operator =
CTBlob.operator <, <=, >, >=, ==, !=
CTBlob Methods
CTBlob.CTBlob
CTBlob.~CTBlob
CTBlob.GetBlob
CTBlob.GetSize
CTBlob.SetBlob
CTCurrency Class
Class CTCurrency
CTCurrency Operators
CTCurrency.operator =, +=, -=, *=, /=, abs, +, -, *, /
CTCurrency.operator <, <=, >, >=, ==, !=
CTCurrency Methods
CTCurrency.CTCurrency
CTCurrency.~CTCurrency
CTCurrency.AsBigint
CTCurrency.AsCurrency
CTCurrency.AsFloat
CTCurrency.AsLong
CTCurrency.AsMoney
CTCurrency.AsString
CTCurrency.IsZero
CTCurrency.Round
CTCurrency.SetCurrency
CTCurrency.Zero
CTDatabase Class
Class CTDatabase
CTDatabase Methods
CTDatabase.CTDatabase
CTDatabase.AddTable
CTDatabase.CloseAll
CTDatabase.Connect
CTDatabase.Create
CTDatabase.CreateDatabase
CTDatabase.DeleteTable
CTDatabase.Disconnect
CTDatabase.Dispose
CTDatabase.DropTable
CTDatabase.FindTable
CTDatabase.FirstTable
CTDatabase.GetDefaultSqlTableOwner
CTDatabase.GetName
CTDatabase.GetPath
CTDatabase.GetTableCount
CTDatabase.GetTableUID
CTDatabase.IsActive
CTDatabase.IsExclusive
CTDatabase.NextTable
CTDatabase.RenameTable
CTDatabase.SetDefaultSqlTableOwner
CTDatabase.SetExclusive
CTDate Class
Class CTDate
CTDate Operators
CTDate.operator =
CTDate.operator <, <=, >, >=, ==, !=
CTDate Methods
CTDate.CTDate
CTDate.~CTDate
CTDate.CurrentDate
CTDate.DateToString
CTDate.Day
CTDate.DayOfWeek
CTDate.GetDate
CTDate.IsLeapYear
CTDate.Month
CTDate.Pack
CTDate.SetDate
CTDate.StringToDate
CTDate.Unpack
CTDate.Year
CTDateTime Class
Class CTDateTime
CTDateTime Operators
CTDateTime.operator =
CTDateTime.operator <, <=, >, >=, ==, !=
CTDateTime Methods
CTDateTime.CTDateTime
CTDateTime.~CTDateTime
CTDateTime.CurrentDate
CTDateTime.CurrentDateTime
CTDateTime.DateTimeToString
CTDateTime.Day
CTDateTime.DayOfWeek
CTDateTime.GetDate
CTDateTime.GetDateTime
CTDateTime.GetTime
CTDateTime.IsLeapYear
CTDateTime.Hour
CTDateTime.Minute
CTDateTime.Month
CTDateTime.Pack
CTDateTime.Second
CTDateTime.SetDateTime
CTDateTime.StringToDateTime
CTDateTime.Unpack
CTDateTime.Year
CTException Class
Class CTException
CTException Methods
CTException.CTException
CTException.~CTException
CTException.GetErrorCode
CTException.GetErrorMsg
CTException.GetLineNumber
CTException.GetSourceFile
CTField Class
Class CTField
CTField Operators
CTField.operator=
CTField Methods
CTField.CTField
CTField.~CTField
CTField.GetLength
CTField.GetName
CTField.GetNullFlag
CTField.GetNumber
CTField.GetPrecision
CTField.GetScale
CTField.GetStatus
CTField.GetType
CTField.IsNumeric
CTField.SetLength
CTField.SetName
CTField.SetNullFlag
CTField.SetPrecision
CTField.SetScale
CTField.SetType
CTIndex Class
Class CTIndex
CTIndex Operators
CTIndex.operator=
CTIndex Methods
CTIndex.CTIndex
CTIndex.~CTIndex
CTIndex.AddSegment
CTIndex.DelSegment
CTIndex.GetDuplicateFlag
CTIndex.GetEmptyChar
CTIndex.GetIdxNo
CTIndex.GetFileName
CTIndex.GetKeyLength
CTIndex.GetKeyType
CTIndex.GetName
CTIndex.GetNullFlag
CTIndex.GetNumber
CTIndex.GetSegment
CTIndex.GetSegmentCount
CTIndex.GetStatus
CTIndex.GetTemporaryFlag
CTIndex.GetUID
CTIndex.InsertSegment
CTIndex.MoveSegment
CTIndex.SetDuplicateFlag
CTIndex.SetFilename
CTIndex.SetEmptyChar
CTIndex.SetKeyType
CTIndex.SetName
CTIndex.SetNullFlag
CTIndex.SetTemporaryFlag
CTMoney Class
Class CTMoney
CTMoney Operators
CTMoney.operator =, +=, -=, *=, /=, abs, +, -, *, /
CTMoney.operator <, <=, >, >=, ==, !=
CTMoney Methods
CTMoney.CTMoney
CTMoney.~CTMoney
CTMoney.AsFloat
CTMoney.AsLong
CTMoney.AsMoney
CTMoney.AsString
CTMoney.SetMoney
CTMoney.StringToMoney
CTNumber Class
Class CTNumber
CTNumber Operators
CTNumber.operator =, +, -, (, /, abs
CTNumber.operator <, <=, >, >=, ==, !=
CTNumber Methods
CTNumber.CTNumber
CTNumber.~CTNumber
CTNumber.AsBigint
CTNumber.AsCurrency
CTNumber.AsFloat
CTNumber.AsLong
CTNumber.AsMoney
CTNumber.AsNumber
CTNumber.AsString
CTNumber.DecimalDigits
CTNumber.IntegralDigits
CTNumber.IsZero
CTNumber.Round
CTNumber.SetNumber
CTNumber.Zero
CTRecord Class
Class CTRecord
CTRecord Methods
CTRecord.CTRecord
CTRecord.Dispose
CTRecord.AtPercentile
CTRecord.BatchLoaded
CTRecord.BatchLocked
CTRecord.BatchMode
CTRecord.BatchTotal
CTRecord.BuildTargetKey
CTRecord.Clear
CTRecord.ClearField
CTRecord.CndxCompile
CTRecord.CndxEval
CTRecord.CndxFree
CTRecord.CndxGetExpression
CTRecord.Compare
CTRecord.CopyBuffer
CTRecord.Delete
CTRecord.EndBatch
CTRecord.EstimateSpan
CTRecord.FilterRecord
CTRecord.Find
CTRecord.FindRowid
CTRecord.FindTarget
CTRecord.First
CTRecord.GetDefaultIndex
CTRecord.GetDefaultIndexName
CTRecord.GetErrorIndex
CTRecord.GetFieldAddress
CTRecord.GetFieldAsString
CTRecord.GetFieldAsBigint
CTRecord.GetFieldAsBlob
CTRecord.GetFieldAsBool
CTRecord.GetFieldAsByte
CTRecord.GetFieldAsChar
CTRecord.GetFieldAsCurrency
CTRecord.GetFieldAsDate
CTRecord.GetFieldAsDateTime
CTRecord.GetFieldAsFloat
CTRecord.GetFieldAsMoney
CTRecord.GetFieldAsNumber
CTRecord.GetFieldAsShort
CTRecord.GetFieldAsSigned
CTRecord.GetFieldAsTime
CTRecord.GetFieldAsUnsigned
CTRecord.GetFieldAsWord
CTRecord.GetFieldByName
CTRecord.GetFieldLength
CTRecord.GetFieldName
CTRecord.GetFieldOffset
CTRecord.GetFieldSize
CTRecord.GetFieldType
CTRecord.GetFieldValue
CTRecord.GetFilter
CTRecord.GetRecordBuffer
CTRecord.GetRecordCount
CTRecord.GetRecordKeyPos
CTRecord.GetRecordLength
CTRecord.GetRecordLock
CTRecord.GetRecordPos
CTRecord.GetRecordSize
CTRecord.GetRowid
CTRecord.InsertBatch
CTRecord.IsBatchActive
CTRecord.IsEdited
CTRecord.IsFiltered
CTRecord.IsNew
CTRecord.IsNullField
CTRecord.IsRangeOn
CTRecord.IsRecordSetOn
CTRecord.IsVariableField
CTRecord.Last
CTRecord.LockRecord
CTRecord.Next
CTRecord.NextBatch
CTRecord.NextInBatch
CTRecord.Prev
CTRecord.RangeOff
CTRecord.RangeOn
CTRecord.Read
CTRecord.RecordSetOff
CTRecord.RecordSetOn
CTRecord.Reset
CTRecord.SeekRecord
CTRecord.SetBatch
CTRecord.SetDefaultIndex
CTRecord.SetEdited
CTRecord.SetFieldAsString
CTRecord.SetFieldAsBigint
CTRecord.SetFieldAsBlob
CTRecord.SetFieldAsBool
CTRecord.SetFieldAsByte
CTRecord.SetFieldAsChar
CTRecord.SetFieldAsCurrency
CTRecord.SetFieldAsDate
CTRecord.SetFieldAsDateTime
CTRecord.SetFieldAsFloat
CTRecord.SetFieldAsMoney
CTRecord.SetFieldAsNumber
CTRecord.SetFieldAsShort
CTRecord.SetFieldAsSigned
CTRecord.SetFieldAsTime
CTRecord.SetFieldAsUnsigned
CTRecord.SetFieldAsWord
CTRecord.SetFieldValue
CTRecord.SetNew
CTRecord.SetRecordOffset
CTRecord.SetRecordPos
CTRecord.SwitchContext
CTRecord.UnlockRecord
CTRecord.Write
CTResource
Class CTResource
CTResource Methods
CTResource.Add
CTResource.Delete
CTResource.Find
CTResource.First
CTResource.GetData
CTResource.GetDataLength
CTResource.GetName
CTResource.GetNumber
CTResource.GetType
CTResource.IsLocked
CTResource.Next
CTResource.SetData
CTResource.SetName
CTResource.SetNumber
CTResource.SetType
CTResource.Unlock
CTResource.Update
CTSegment Class
Class CTSegment
CTSegment Operators
CTSegment.operator =
CTSegment Methods
CTSegment.CTSegment
CTSegment.~CTSegment
CTSegment.AddSegment
CTSegment.GetField
CTSegment.GetFieldName
CTSegment.GetMode
CTSegment.GetNumber
CTSegment.GetStatus
CTSegment.MoveSegment
CTSegment.SetMode
CTSession Class
Class CTSession
CTSession Methods
CTSession.CTSession
CTSession.Dispose
CTSession.AddDatabase
CTSession.Attach
CTSession.ClearPathPrefix
CTSession.Create
CTSession.CreateDatabase
CTSession.CreateSession
CTSession.DeleteDatabase
CTSession.Detach
CTSession.DisconnectAll
CTSession.DropDatabase
CTSession.FindDatabase
CTSession.FirstDatabase
CTSession.GetAttachMode
CTSession.GetDatabaseCount
CTSession.GetDatabaseUID
CTSession.GetLibType
CTSession.GetLogonOnly
CTSession.GetParam
CTSession.GetPassword
CTSession.GetPath
CTSession.GetPathPrefix
CTSession.GetServerDateTime
CTSession.GetServerName
CTSession.GetSessionType
CTSession.GetUserLogonName
CTSession.IsActive
CTSession.IsExclusive
CTSession.Logon
CTSession.Logout
CTSession.NextDatabase
CTSession.SetConfigurationFile
CTSession.SetCurrentNodeName
CTSession.SetExclusive
CTSession.SetLogonOnly
CTSession.SetParam
CTSession.SetPath
CTSession.SetPathPrefix
CTSession.SetSessionType
CTSession.StartDatabaseEngine
CTSession.StopDatabaseEngine
CTString Class
CTTable Class
Class CTTable
CTTable Methods
CTTable.CTTable
CTTable.AddField
CTTable.AddIndex
CTTable.Alter
CTTable.Attach
CTTable.Clone
CTTable.Close
CTTable.Create
CTTable.CreateTable
CTTable.DelField
CTTable.DelIndex
CTTable.DelSegment
CTTable.Detach
CTTable.Dispose
CTTable.GetCndxIndex
CTTable.GetCreateMode
CTTable.GetDataDefaultExtentSize
CTTable.GetDataExtension
CTTable.GetDatno
CTTable.GetField
CTTable.GetFieldCount
CTTable.GetFieldNumber
CTTable.GetFirstPartition
CTTable.GetGroupid
CTTable.GetIdentityField
CTTable.GetIdentityFieldDetails
CTTable.GetIdxNo
CTTable.GetIndex
CTTable.GetIndexByUID
CTTable.GetIndexCount
CTTable.GetIndexDefaultExtentSize
CTTable.GetIndexExtension
CTTable.GetIndexFilename
CTTable.GetLastIdentity
CTTable.GetLastPartition
CTTable.GetName
CTTable.GetOpenMode
CTTable.GetPadChar
CTTable.GetPassword
CTTable.GetPath
CTTable.GetPermission
CTTable.GetSegment
CTTable.HasDelField
CTTable.HasNullFieldSupport
CTTable.HasRecbyt
CTTable.HasRowid
CTTable.InsertField
CTTable.InsertSegment
CTTable.IsActive
CTTable.Open
CTTable.PartAdminByKey
CTTable.PartAdminByName
CTTable.PartAdminByNumber
CTTable.Rebuild
CTTable.Remove
CTTable.MoveField
CTTable.MoveSegment
CTTable.ResetAll
CTTable.SetDataDefaultExtentSize
CTTable.SetDataExtension
CTTable.SetGroupid
CTTable.SetIdentityField
CTTable.SetIndexDefaultExtentSize
CTTable.SetIndexExtension
CTTable.SetIndexFilename
CTTable.SetOwner
CTTable.SetPadChar
CTTable.SetPassword
CTTable.SetPath
CTTable.SetPermission
CTTable.SystemFilterOff
CTTable.SystemFilterOn
CTTable.UpdateCreateMode
CTTable.UpdateCndxIndex
CTTable.UpdatePadChar
CTTable.UnlockTable
CTTime Class
Class CTTime
CTTime Operators
CTTime.operator =
CTTime.operator <, <=, >, >=, ==, !=
CTTime Methods
CTTime.CTTime
CTTime.~CTTime
CTTime.CurrentTime
CTTime.GetTime
CTTime.Hour
CTTime.Minute
CTTime.Pack
CTTime.Second
CTTime.SetTime
CTTime.StringToTime
CTTime.TimeToString
CTTime.Unpack
c-treeACE Error Code Reference
c-treeDB .NET Error and Return Values
Index