VistaDB 5
Properties  Methods 

VistaDB.DDA Namespace : IVistaDBTable Interface
IVistaDBTable Interface Members

The following tables list the members exposed by IVistaDBTable.

Public Properties
 NameDescription
 PropertyName of active index that pivots current row order  
 PropertyThe unique key that points out current row when Key is read or set respective row to be current when Key is wrote  
 PropertyRow structure containing current table row columns While reading creates new current row copy. When writing, caches data in the table until Post is issued.  
 PropertyTests if a record movement function has placed the row pointer beyond the last row in the table.  
 PropertyGets or sets a value indicating whether constraint rules are followed when attempting any insert, update or delete operation  
 PropertyGets or sets a value indicating whether identities are active when attempting any insert operation  
 PropertyGet or set the manual setting for IDENTITY_INSERT ON (true) or OFF (false) for this table. This is independent from the one-table-at-a-time setting for a SQL connection but provides the same basic functionality to allow explicit value insertion for identity columns.  
 PropertyGet the value indicating whether the table is closed  
 PropertyRead the memory-cached value of last insert operation made to the identity columns by this table instance  
 PropertyRead the last value of identity columns that will be used by any client in nearest insert operation. This value is saved in the file storage.  
 PropertyTable name  
 PropertyGet collection of regular indexes created and/or opened in this table instance  
 PropertyNumber of physical rows in the table  
 PropertyScans active index and calculates the keys in it, taking current scope operators into account. (WARNING: CAUSES SIDE-EFFECTS: The current row position of the parent table becomes undefined/EOF)  
 PropertyTests if a a record movement function has placed the row pointer before the first row in the table  
 PropertyGet collection of temporary indexes created and assigned to this table instance  
Top
Public Methods
 NameDescription
 MethodClose the table and clear respective resources  
 MethodCreate constraint to check after insert, update or before delete operations  
 MethodCreate a default value for a column using an expression.  
 MethodCreate foreign key constraint that instantiates respective relationship in the database  
 MethodCreate special index to use by full text search. Identity columns may not be used for FullTextSearch indexes. Only a single FullTextSearch index may exist per table.  
 MethodCreate and initialize identity counter. Applied to integer type columns only.  
 MethodCreate an index on current table. This may be a unique constrained index, or a primary key index.  
 MethodCreate temporary index from given keyExpression. The index is not added to database but kept separately in the user temporary folder. The file is deleted by engine when the table is closed.  
 MethodImmediately deletes current row and reset row lock if it was set before delete operation  
 Method (Inherited from System.IDisposable)
 MethodDrop existing constraint  
 MethodDrop an existing default value  
 MethodDrop foreign key constraint. Respective foreign key index will be deleted from the table as well.  
 MethodDrop full text search index. No params are required as there may be only one Full Text Search (FTS) Index per table.  
 MethodDrop existing identity column  
 MethodDrop existing index  
 MethodEvaluate expression.  
 MethodTo export table data using constraint set on destination table.  
 MethodOverloaded. Find an expression in an index. This is for searching for exact and partial matching records.  
 MethodSet current row pointer to the first row position. If there are no rows, the EndOfTable flag is set to the true value  
 MethodOverloaded. Get column value by column's name  
 MethodGets filter expression for current table state.  
 MethodGets the IVistaDBRow objects containing current top and bottom rows of the applied scope. These objects before the first row and after the last row.  
 MethodOverloaded. Read Text, NText, Image data from database and put them to external file.  
 MethodThe method should be called in the beginning the insert operation.  
 MethodSet current row pointer to the last row position. If there are no rows, the EndOfTable flag is set to the true value  
 MethodLock row. If zero is passed, the entire table will be locked  
 MethodAdvances current row pointer position  
 MethodAdvances current row pointer position If there are no rows, the EndOfTable flag is set to the true value  
 MethodOverloaded. The method should be called to finalize insert or update operations.  
 MethodMove row pointer one record ahead If there are no rows, the StartOfTable flag is set to the true value  
 MethodOverloaded. Assign column value with system type value by column order in the row.  
 MethodOverloaded. Assign array of bytes value to column by column's name  
 MethodOverloaded. Assign boolean value to column by column's name  
 MethodOverloaded. Assign byte value to column by column's name  
 MethodOverloaded. Assign DateTime value to column by column's name  
 MethodOverloaded. Assign DateTimeOffset value to column by column's name  
 MethodOverloaded. Assign Decimal value to column by column's name  
 MethodOverloaded. Assign Double value to column by column's name  
 MethodOverloaded. Put Text, NText, Image data from external file to a column.  
 MethodOverloaded. Assign Guid value to column by column's name  
 MethodOverloaded. Assign int16 value to column by column's name  
 MethodOverloaded. Assign int32 value to column by column's name  
 MethodOverloaded. Assign int64 value to column by column's name  
 MethodOverloaded. Set null value by column's name  
 MethodOverloaded. Assign Float value to column by column's name  
 MethodOverloaded. Assign string value to column by column's name  
 MethodOverloaded. Assign TimeSpan value to column by column's name  
 MethodRename existing index without rebuilding.  
 MethodReset event delegate type called by DDA  
 MethodReset all filters  
 MethodReset scope in active index  
 MethodSet delegate method called by core engine by event  
 MethodSet filter expression and try to optimize it if the optimize parameter is true  
 MethodDefines a delegate that time consuming operations may call back in order to inform the user as to the progress of the operation and additional information.  
 MethodOverloaded. Set scope on active index to apply filter on the number of rows. The columns referenced in the scope operators must be present in the active index for them to work correctly.  
 MethodUnlock row. If zero is passed, the entire table will be unlocked and all existing row locks will be released  
Top
See Also