c-treeDB API for C# - Developers Guide

CTTable Methods

Constructor / Destructor

• CTTable(): Creates a CTTable object
• Dispose(): Destroys a CTTable object and resets all the dependent objects

Table Handling

• Alter(): Performs alter table functions
• Close(): Closes a table
• Create(): Creates a new table
• CreateTable(): Creates a new table
• GetCreateMode(): Retrieves the table create mode
• GetDataDefaultExtentSize(): Retrieves the c-tree data file default extent size
• GetDataExtension(): Retrieves the data file name extension
• GetDatno(): Retrieves the table datno
• GetGroupid(): Retrieves the table group id
• GetIndexDefaultExtentSize(): Retrieves the c-tree index file default extent size
• GetIndexExtension(): Retrieves the index file name extension
• GetIndexFilename(): Retrieves the index name
• GetName(): Retrieves the table name, without the name extension
• GetOpenMode(): Retrieves the table open mode
• GetPath(): Retrieves the table path.
• GetPermission(): Retrieves the table permission mask
• HasDelField(): Indicate if a table has the $DELFLD$ internal field
• HasLocks(): Indicate if there are any locks on the table in the current session
• HasNullFieldSupport(): Indicates if a table has null field support
• IsActive(): Indicates if a table is open or closed
• Open(): Opens an existing table
• Remove(): Delete a table
• ResetAll(): Resets all active record buffers associated with the table
• SetDataDefaultExtentSize(): Sets the c-tree data file default extent size
• SetDataExtension(): Sets the table data file extension
• SetGroupid(): Sets the table groupid
• SetIndexDefaultExtentSize(): Sets the c-tree index file default extent size
• SetIndexExtension(): Sets the table index file extension
• SetIndexFilename(): Sets the index filename
• SetPassword(): Sets the table password
• SetPath(): Sets the table path
• SetPermission(): Sets the table permission mask
• UnlockTable(): Unlocks all record locks from the table
• UpdateCreateMode(): Updates the table create mode

Field Handling

• AddField(): Adds a new field to table
• DelField(): Deletes one field from the table
• GetField(): Retrieves a field by its number or name
• GetFieldCount(): Retrieves the number of fields in table
• GetFieldNumber(): Retrieves the field number from a field name
• GetPadChar(): Retrieves the table pad and field delimiter characters
• InsertField(): Inserts a new field to table, in the specified position
• MoveField(): Moves the field from one position to a new position in the table
• SetPadChar(): Set the table pad and field delimiter characters
• UpdatePadChar(): Update the table pad and delimiter character resource

Index Handling

• AddIndex(): Adds a new index to the table
• DelIndex(): Deletes an index from a table
• GetCndxIndex(): Retrieves the conditional index expression string
• GetIndex(): Retrieves an index object
• GetIndexByUID(): Retrieves the index given its UID
• GetIndexCount(): Retrieves the number of indexes of the table
• GetIdxno(): Retrieves the index file number given the index number
• HasRecbyt(): Indicates if a table was created with support to a recbyt index
• HasRowid(): Indicates if a table was created with support to a rowid index
• UpdateCndxIndex(): Add, modify or delete conditional index

Segment Handling

• AddSegment(): Retrieves an index segment object
• DelSegment(): Deletes an existing segment
• GetSegment(): Adds a new segment to an index
• InsertSegment(): Inserts a new segment

System Filters

• SystemFilterOn(): Establish a permanent system wide record filter
• SystemFilterOff(): Delete a permanent system wide record filter

In This Section CTTable.AddField CTTable.AddField (by field object) CTTable.AddField (by name) CTTable.AddField (by number) CTTable.AddFullTextIndex CTTable.AddIndex CTTable.Alter CTTable.Attach CTTable.Clone CTTable.Close CTTable.Create CTTable.CreateTable CTTable.CTTable CTTable.DelField CTTable.DelFullTextIndex (by index name) CTTable.DelFullTextIndex (by index number) 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.GetFullTextIndex (by index name) CTTable.GetFullTextIndex (by index number) CTTable.GetFullTextIndexCount 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.HasLocks CTTable.HasNullFieldSupport CTTable.HasRecbyt CTTable.HasRowid CTTable.InsertField CTTable.InsertSegment CTTable.IsActive CTTable.MoveField CTTable.MoveSegment CTTable.Open CTTable.PartAdminByKey CTTable.PartAdminByName CTTable.PartAdminByNumber CTTable.Rebuild CTTable.Remove CTTable.ResetAll CTTable.SetDataDefaultExtentSize CTTable.SetDataExtension CTTable.SetFullTextIndexOption (by index object) CTTable.SetFullTextIndexOption (by name) CTTable.SetFullTextIndexOption (by number) 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.UnlockTable CTTable.UpdateCndxIndex CTTable.UpdateCreateMode CTTable.UpdatePadChar