Dynaset
Object List Next Object
Definition:
Provides an organized framework for connecting to a data source for the
purpose of viewing and/or modifying the data in the data source. A Dynaset references
an underlying FixedAscii, DelimitedAscii, or ODBC database through its
Database object reference property. These underlying database objects organize data in
a row/column table format.
Specialized Features:
The following tables list and describe the properties and methods added by Dynaset. There are no added events.
Properties Use to...
BOF Indicates whether the CurrentRecordNumber is the first record in the
underlying database.
Connect Determine the information needed to open and attach to an external database.
CurrentRecord An object reference to a persistent object that refers to the "current record."
CurrentRecordNumber Determine the row number that the CurrentRecord refers to.
Database An object reference to the underlying Database object.
DatabaseType Display the type of database that is being accessed. When the DatabaseType is
set, a corresponding Database object is dynamically created and referenced in
the Database property.
EditMode Indicate the state of editing of the current record.
EOF Indicate whether the CurrentRecordNumber is the last record in the underlying
database.
FieldCount Reflect the number of fields that are available in the underlying database.
FieldFormat Specify a format string that is used to format the field that is in position FieldIndex in the FieldList property.
FieldIndex Specify an index into the FieldList property.
FieldList List the fields that are available in the underlying database if there is an
active connection and no current query.
FieldMaxLength Specify the maximum length of the field that is in position FieldIndex in the FieldList property.
FieldName Specify the name of the field that is in position FieldIndex in the FieldList property.
FieldType Specify the type of the field that is in position FieldIndex in the FieldList property.
NoMatch Indicate whether or not a find method was successful in locating a record that
matched the search criteria.
ReadComplete Indicate the number of Records in the underlying database referenced by this
Dynaset.
RecordSource Indicate the table name or SQL string that is used to retrieve data into the
underlying database.
RowsRead Indicate the number of Records in the Database referenced by this Dynaset.
Methods Use to...
AddAt Add a new record at a designated location in the underlying database.
AddColumn Add a field for DelimitedAscii and FixedAscii databases.
AddNew Create a new record after the last Record in the underlying database of the
Dynaset.
Column Return an object that represents the column designated by position. The column can consist of an arbitary number of rows.
Columns Return an object that represents the column range beginning at a specific
column start position and including a specified number of columns from that point.
The column range can consist of an arbitrary number of rows.
Delete Delete the current record in the underlying database indicated by the
Dynaset's CurrentRecordNumber property.
DeleteAll Delete all records in the underlying database referenced by the Dynaset's
Database property.
DetailedEdit Display a Database Wizard designed to assist in the configuration of Dynasets.
Fields Return a Dynaset object representing the field name that is specified.
FindFirst Find the first occurrence of a string in the underlying database that matches
the search string.
FindLast Find the last occurrence of a string in the underlying database that matches
the search string.
FindNext Find the next occurrence of a string from the CurrentRecordNumber in the
underlying database that matches the search string.
FindPrev Find the previous occurrence of a string from the CurrentRecordNumber in the
underlying database that matches the search string.
Modify Set or change the value of the specified field.
ModifyData Allow the DataBuffer object to set the Value of a field.
MoveFirst Move to the first record in the underlying database object.
MoveLast Move to the last record in the underlying database object.
MoveNext Move to the next record in the underlying database object.
MovePrev Move to the previous record in the underlying database object.
Refresh Discard any changes made that have not been committed and reinitialize the
Dynaset with new data from the database source.
Row Return an object that represents a specific row in the underlying database.
Rows Return an object that represents the specified Rows requested in the
underlying database.
SaveFile Save the contents of the Dynaset to a specified filename, creating it if
necessary.
TextUnload Append statements necessary to regenerate the object from text. It is used by
the text-based object saving mechanism that is used by the write module (as
text) functions.
Update Save changes to CurrentRecord that are currently in the copy buffer of the
underlying Database.
UpdateAll Save all changes that are currently in the copy buffer to the underlying
Database.
Value Return the text character string represented by the object returned by a
Dynaset method
ValueData Return the value represented by the object in a DataBuffer.
Copied Features:
None
this is a top-level object.
Details:
A Dynaset object is used to open a data source and create a dynamic set of
records that are organized similar to a database table. The Dynaset object
provides flexible access to the records (Rows) and fields (Columns) of retrieved
data.Once the data is loaded into a Dynaset, the data can be retrieved as a Row,
Column, or series of contiguous Rows or Columns. When the methods Row[s],
Column[s] are called, an object is returned that represents the corresponding table
element. The characters in the object may change, but the object will always
contain the same Row or Column. When a method is called on an object returned by Row
or Column, it will only operate on the table elements represented by that
object. The actual data contents of an object returned by a Row or Column may be
converted into a text string with the use of the Value method.
To simplify the task of connecting a Dynaset to a database, a Database Wizard
is available. The Database Wizard can be displayed by double-clicking on the
Dynaset property in the Property Editor.