borland Packages Class Hierarchy dx.dataset Package
TableDataSet component
java.lang.Object
+----com.borland.dx.dataset.ReadRow
+----com.borland.dx.dataset.ReadWriteRow
+----com.borland.dx.dataset.DataSet
+----com.borland.dx.dataset.StorageDataSet
+----com.borland.dx.dataset.TableDataSet
About the TableDataSet component
Constructors Properties Methods Event Listeners
Implements AccessListener, ColumnDesigner, Designable, MasterNavigateListener, StatusListener, Serializable, EventListener
The TableDataSet is a simple DataSet that may or may not have a formal provider or resolver of its data. Its properties allow it to import file-based data. Use this component to create a StorageDataSet from sources other than SQL databases, for example, by importing data stored in a text file, from data computations, or to simply work with database data off-line. You can also use this component, or any other component that extends from StorageDataSet, to directly access tables stored in a DataStore database file.
You attach this component to any UI control in the same way that other subclasses of StorageDataSet connect to a UI control. Similarly, setting its sort property affects the sort order of the data in this component, and its rowFilterListener filters as it would any other StorageDataSet. It thereby mimics single-user SQL server functionality although no database connection is involved.
With file-based data sources, such as a TextDataFile, the providing phase occurs in a single fetch.
Similarly, if a TableDataSet is the detail of a master-detail relationship, setting its fetchAsNeeded property has no effect as all detail records are read from a single fetch operation when file-based data sources are involved.
The resolving phase is the most simple of all resolvers: the data saved to the file overwrites the existing data. To save the data in any StorageDataSet to a text file, set the TextDataFile component's fileName property to the export file prior to calling the StorageDataSet component's save() method.
Saving data in a TextDataFile to a JDBC data source
By default, data loaded into a TableDataSet using a TextDataFile is loaded with a RowStatus.LOADED
status. Calling the saveChanges(...) method on a QueryDataSet or ProcedureDataSet has no effect because these rows are not considered as being inserted. Setting the TextDataFile property setLoadAsInserted(true) causes all rows loaded from the TextDataFile to be RowStatus.INSERTED. A subsequent call to saveChanges(...) with the resolver property set to a QueryResolver or ProcedureResolver will insert the rows into the JDBC data source for the Resolver.
Note: This component will not delete existing rows if a DataSet already contains data.
TableDataSet constructors
TableDataSet properties
*Read-only properties **Write-only properties
Properties implemented in java.lang.Object
TableDataSet methods
- accessChange(com.borland.dx.dataset.AccessEvent)
- addRow(com.borland.dx.dataset.DataRow)
- allocateValues()
- atFirst()
- atLast()
- cancel()
- canNavigate(com.borland.dx.dataset.Column, int)
- canSet(com.borland.dx.dataset.Column)
- clearStatus()
- cloneDataSetView()
- close()
- columnIsVisible(java.lang.String)
- deleteAllRows()
- deleteRow()
- dittoRow(boolean)
- dittoRow(boolean, boolean)
- dropIndex()
- editRow()
- emptyAllRows()
- emptyRow()
- enableDataSetEvents(boolean)
- first()
- getDataRow(com.borland.dx.dataset.DataRow)
- getDataRow(int, com.borland.dx.dataset.DataRow)
- getDetail(java.lang.String)
- getDisplayVariant(int, int, com.borland.dx.dataset.Variant)
- getVariant(int, int, com.borland.dx.dataset.Variant)
- getVariant(java.lang.String, int, com.borland.dx.dataset.Variant)
- goToClosestRow(int)
- goToInternalRow(long)
- goToRow(com.borland.dx.dataset.ReadRow)
- goToRow(int)
- hasDetail(java.lang.String)
- hasValidations()
- inBounds()
- insertRow(boolean)
- interactiveLocate(java.lang.String, java.lang.String, int, boolean)
- isModified(int)
- isModified(java.lang.String)
- isNew(int)
- last()
- locate(com.borland.dx.dataset.ReadRow, int)
- lookup(com.borland.dx.dataset.ReadRow, com.borland.dx.dataset.DataRow, int)
- masterNavigated(com.borland.dx.dataset.MasterNavigateEvent)
- masterNavigating(com.borland.dx.dataset.MasterNavigateEvent)
- moveRow(int)
- next()
- open()
- openDetails()
- post()
- prior()
- refetchRow(com.borland.dx.dataset.ReadWriteRow)
- refilter()
- resetInBounds()
- saveChanges()
- setDefaultValues()
- setDisplayVariant(int, com.borland.dx.dataset.Variant)
- startEdit(com.borland.dx.dataset.Column)
- startEditCheck(com.borland.dx.dataset.Column)
- statusMessage(com.borland.dx.dataset.StatusEvent)
- statusMessage(int, java.lang.String)
- toggleViewOrder(java.lang.String)
- updateRow(com.borland.dx.dataset.DataRow)
- validate()
- validate(com.borland.dx.dataset.ReadRow)
- clearValues()
- requiredColumnsCheck()
- setBigDecimal(int, java.math.BigDecimal)
- setBigDecimal(java.lang.String, java.math.BigDecimal)
- setBoolean(int, boolean)
- setBoolean(java.lang.String, boolean)
- setByte(int, byte)
- setByte(java.lang.String, byte)
- setByteArray(int, byte[], int)
- setByteArray(java.lang.String, byte[], int)
- setDate(int, java.sql.Date)
- setDate(int, long)
- setDate(java.lang.String, java.sql.Date)
- setDate(java.lang.String, long)
- setDouble(int, double)
- setDouble(java.lang.String, double)
- setFloat(int, float)
- setFloat(java.lang.String, float)
- setInputStream(int, java.io.InputStream)
- setInputStream(java.lang.String, java.io.InputStream)
- setInt(int, int)
- setInt(java.lang.String, int)
- setLong(int, long)
- setLong(java.lang.String, long)
- setObject(int, java.lang.Object)
- setObject(java.lang.String, java.lang.Object)
- setShort(int, short)
- setShort(java.lang.String, short)
- setString(int, java.lang.String)
- setString(java.lang.String, java.lang.String)
- setTime(int, java.sql.Time)
- setTime(int, long)
- setTime(java.lang.String, java.sql.Time)
- setTime(java.lang.String, long)
- setTimestamp(int, java.sql.Timestamp)
- setTimestamp(int, long)
- setTimestamp(java.lang.String, java.sql.Timestamp)
- setTimestamp(java.lang.String, long)
- setVariant(int, com.borland.dx.dataset.Variant)
- setVariant(java.lang.String, com.borland.dx.dataset.Variant)
- addColumn(com.borland.dx.dataset.Column)
- addColumn(java.lang.String, int)
- addColumn(java.lang.String, java.lang.String, int)
- addLoadRowListener(listener)
- addUniqueColumn(com.borland.dx.dataset.Column)
- cancelLoading()
- cancelOperation()
- changeColumn(int, com.borland.dx.dataset.Column)
- changesPending()
- cloneColumns()
- cloneDataSetStructure()
- closeProvider(boolean)
- deleteDuplicates()
- dropAllIndexes()
- dropColumn(com.borland.dx.dataset.Column)
- dropColumn(java.lang.String)
- dropIndex(com.borland.dx.dataset.SortDescriptor, com.borland.dx.dataset.RowFilterListener)
- empty()
- endLoading()
- getDeletedRows(com.borland.dx.dataset.DataSetView)
- getInsertedRows(com.borland.dx.dataset.DataSetView)
- getOriginalRow(com.borland.dx.dataset.DataSet, com.borland.dx.dataset.ReadWriteRow)
- getUpdatedRows(com.borland.dx.dataset.DataSetView)
- hasRowIds()
- indexExists(com.borland.dx.dataset.SortDescriptor, com.borland.dx.dataset.RowFilterListener)
- loadRow()
- loadRow(int)
- moveColumn(int, int)
- postAllDataSets()
- provideMoreData()
- recalc()
- refresh()
- refreshSupported()
- removeLoadRowListener(listener)
- reset()
- resetPendingStatus(boolean)
- resetPendingStatus(long, boolean)
- restructure()
- saveChanges(com.borland.dx.dataset.DataSet)
- saveChangesSupported()
- setRowId(java.lang.String, boolean)
- startLoading(com.borland.dx.dataset.LoadCancel, int, boolean)
- startLoading(com.borland.dx.dataset.LoadCancel, int, boolean, boolean)
- startLoading(com.borland.dx.dataset.LoadCancel, int, boolean, boolean, boolean)
Methods implemented in java.lang.Object
- clone()
- equals(java.lang.Object)
- finalize()
- hashCode()
- notify()
- notifyAll()
- wait()
- wait(long)
- wait(long, int)
TableDataSet event listeners
TableDataSet constructors
TableDataSet()
public TableDataSet()
Instantiates a TableDataSet class object with default properties.
TableDataSet event listeners
This component is a source for the following event sets.
access
public final void addAccessListener(AccessListener listener)
public final void removeAccessListener(AccessListener listener)
calcAggFields
public synchronized void addCalcAggFieldsListener(CalcAggFieldsListener listener)
public synchronized void removeCalcAggFieldsListener(CalcAggFieldsListener listener)
calcFields
public synchronized void addCalcFieldsListener(CalcFieldsListener listener)
public synchronized void removeCalcFieldsListener(CalcFieldsListener listener)
columnChange
public void addColumnChangeListener(ColumnChangeListener listener)
public synchronized void removeColumnChangeListener(ColumnChangeListener listener)
dataChange
public final void addDataChangeListener(DataChangeListener listener)
public final void removeDataChangeListener(DataChangeListener listener)
edit
public void addEditListener(EditListener listener)
public synchronized void removeEditListener(EditListener listener)
load
public final synchronized void addLoadListener(LoadListener listener)
public final synchronized void removeLoadListener(LoadListener listener)
masterNavigate
public final void addMasterNavigateListener(MasterNavigateListener listener)
public final void removeMasterNavigateListener(MasterNavigateListener listener)
navigation
public final void addNavigationListener(NavigationListener listener)
public final void removeNavigationListener(NavigationListener listener)
open
public final void addOpenListener(OpenListener listener)
public final void removeOpenListener(OpenListener listener)
rowFilter
public final void addRowFilterListener(RowFilterListener listener)
public final void removeRowFilterListener(RowFilterListener listener)
status
public final void addStatusListener(StatusListener listener)
public final void removeStatusListener(StatusListener listener)