VistaDB 5

VistaDB.DDA Namespace : IVistaDBTable Interface
IVistaDBTable Interface Methods

For a list of all members of this type, see IVistaDBTable members.

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