|
»Spread COM
» Product Tour
» Bound Mode
|
|
jump to:
|
|
Bound Mode |
|
Spread can automatically retrieve information from a multitude of
databases and connect to them using ActiveX Data Objects (ADO) 2.0 using OLE DB
technology, Data Access Objects (DAO), or Remote Data Objects (RDO) connections.
After the database connection has been
made, Spread can connect to the data source and display the requested
information. But Spread takes this several steps further to help ensure data
integrity by automatically doing most of the work for you.
After the
connection has been established, Spread can:
- Easily connect to most commercial databases using.ADO, DAO, and RDO
connections
- Read and display the field names as the column headers
- Create the necessary number of columns
- Create the appropriate cell types depending on the data .to ensure data
integrity when editing
- Display the requested data in the appropriate format
- Allow the user to make any changes on screen and have Spread automatically
update. the database without writing any extra code
- Let users navigate though the data using the standard or special scroll bars
- Insert new columns and rows (especially useful for creating "total" columns
or rows)
And of course, all of this default behavior can be modified
and enhanced to best suit your business needs. Many of the features listed above
are explained in more detail in the
Updating/Exporting
Data section.
The following sections illustrate some of the default
features listed above.