IFirebirdTable

This interface provides the data management of the table which database engine holds.

IFirebird IFirebird { get; }

Gets the interface of the database which holds the table.

string TableName { get; }

Gets the name of the table.

string AliasName{ get; }

Gets the alias of the table. If an alias does not exist, this is the same as "TableName".

string EditPath { get; }

Returns the path of a database file.

Dictionary<DBAttrType, string>(DBAttrType types)

Gets a parts name with the specified attribute as Dictionary class.

IList<DBAttributedData>(DBAttrType types, int min, int max)

Gets the value by a parts with the specified attribute.

IList<DBAttributedData> GetAttributedValue(DBAttrType type)

Gets the value which a parts with the specified attribute has from all the cards.

DBAttributedData GetAttributedValue(DBAttrType type, int id)

Gets the value of a card which has a specified attribute and a number.

FbFieldData[] GetTableFields()

Gets the information on the field.

string GetAliasName(string fieldname)

Gets the alias of the specified field.

string GetReferenceComboTableName(string partsname)

Gets the table name to which a combo box parts relates.

string GetReferenceInListTableName(string parts)

Gets the table name to which a internal list parts relates.

FbResult EnumIndexes()

Enumerates the numbers of the existing cards as FbResult class.

int Count{ get; }

Gets the number of rows of a table.

int MinNumber{ get; }

Gets the smallest card number contained in the table.

int MaxNumber{ get; }

Gets the largest card number contained in the table.

int GetSkipedNumber(int current, int step)

Gets the nearest number in which a card exists within specified limits.

bool ExistNumber(int id)

If a row with the target number exists, it returns true.

void Insert(IEnumerable<DictionaryEntry[]> entries)

Adds a new row.

void Update(IEnumerable<DictionaryEntry[]> entries)

Updates multiple rows.

bool Merge(int targetid)

Adds an empty row, if a row with the specified card number does not exist.

bool Merge(int targetid, List<DictionaryEntry> entries)

Adds row to the specified card number.

void Delete(int id)

Deletes a row with the specified card number.

void Create(IEnumerable<SQLTypeDefine> defines, bool primary_id)

By the table name specified at the constructor, creates a table newly in the database.

void Create(List<SQLTypeDefine> defines)

Creates the table which made ID the primary key. This is the same as "FirebirdTable.Create(defines, true)".

Drop()

Deletes a table with the subtables*1.

object Calculate(int id, CalculationType calctype, string formula)

Runs calculation. This returns the same result as a calculation text.


*1 The table formed in "[table name]$[substitute name]".