PC World Komputer 1997 May/Pcwk0597.iso/borland/cb/setup/cbuilder/data.z/BCBDADG.TOC

Microsoft Windows Help File Content | 1997-02-28 | 26KB | 389 lines

:Base bcbdadg.hlp
0 Borland C++Builder Database Application Developer's Guide
1 Introduction
2 Introduction=Introduction
2 What's in help?=What's in help?
2 Software registration and technical support=Software registration and technical support
1 Using the C++Builder database development model
2 C++Builder database tools and features=C++Builder database tools and features
2 What is a C++Builder database application?=What is a C++Builder database application?
2 Understanding database components=Understanding database components
2 Building database forms
3 Building database forms=Building database forms
3 Making the connections: linking database components=Making the connections: linking database components
2 Understanding the C++Builder development model
3 Understanding the C++Builder development model=Understanding the C++Builder development model
3 Browsing and designing with the SQL and Database Explorers=Browsing and designing with the SQL and Database Explorers
3 Designing with the Database Desktop=Designing with the Database Desktop
3 Using data modules to centralize development=Using data modules to centralize development
3 Using the Data Dictionary=Using the Data Dictionary
3 Designing a database interface with data-aware controls=Designing a database interface with data-aware controls
3 Using the Object Repository=Using the Object Repository
1 Using data modules
2 Understanding data modules=Understanding data modules
2 Creating a new data module
3 Creating a new data module=Creating a new data module
3 Naming a data module=Naming a data module
3 Placing and naming components=Placing and naming components
3 Using component properties and methods in a data module=Using component properties and methods in a data module
3 Creating business rules in a data module=Creating business rules in a data module
2 Reusing data modules in the Object Repository
3 Reusing data modules in the Object Repository=Reusing data modules in the Object Repository
3 Copying a data module=Copying a data module
3 Inheriting a data module=Inheriting a data module
3 Using a data module=Using a data module
1 Accessing a data module from a form=Accessing a data module from a form
1 Adding a data module to the Object Repository=Adding a data module to the Object Repository
1 Connecting to databases
2 Connecting to databases=Connecting to databases
2 Using TSession components
3 Using TSession components=Using TSession components
3 Using the Active property=Using the Active property
3 Using the KeepConnections property=Using the KeepConnections property
3 Using the NetFileDir property=Using the NetFileDir property
3 Using the PrivateDir property=Using the PrivateDir property
3 Using the SessionName property=Using the SessionName property
3 Using the Databases property=Using the Databases property
3 Using the DatabaseCount property=Using the DatabaseCount property
3 Using session events=Using session events
3 Using session methods=Using session methods
1 Using the default session=Using the default session
2 Creating additional sessions
3 Creating additional sessions=Creating additional sessions
3 Managing multiple sessions=Managing multiple sessions
2 Using TDatabase components
3 Using TDatabase components=Using TDatabase components
3 Using temporary database components=Using temporary database components
3 Creating database components at design time=Creating database components at design time
3 Creating database components at runtime=Creating database components at runtime
3 Using TDatabase properties
4 Using TDatabase properties=Using TDatabase properties
4 Using the AliasName, DatabaseName, and DriverName properties=Using the AliasName, DatabaseName, and DriverName properties
4 Using the KeepConnection and Connected properties=Using the KeepConnection and Connected properties
4 Using the DataSets and DataSetCount properties=Using the DataSets and DataSetCount properties
4 Using the LoginPrompt and Params properties=Using the LoginPrompt and Params properties
4 Using the SessionName and Session properties=Using the SessionName and Session properties
4 Using the TransIsolation property=Using the TransIsolation property
4 Using database events=Using database events
4 Using database methods=Using database methods
4 Connecting to a remote server=Connecting to a remote server
1 Interactions between TSession and TDatabase=Interactions between TSession and TDatabase
1 Using TSession and TDatabase in data modules=Using TSession and TDatabase in data modules
1 Managing transactions
2 Managing transactions=Managing transactions
2 How transactions differ from cached updates=How transactions differ from cached updates
2 Implicitly controlling transactions=Implicitly controlling transactions
2 Explicitly controlling transactions
3 Explicitly controlling transactions=Explicitly controlling transactions
3 Controlling transactions using a database component
4 Controlling transactions using a database component=Controlling transactions using a database component
4 Starting a transaction=Starting a transaction
4 Committing database changes=Committing database changes
4 Discarding database changes=Discarding database changes
4 Specifying how a transaction interacts with other simultaneous transactions=Specifying how a transaction interacts with other simultaneous transactions
3 Sending an SQL transaction control statement to a remote server
4 Sending an SQL transaction control statement to a remote server=Sending an SQL transaction control statement to a remote server
1 Transactions against a local table=Transactions against a local table
1 Accessing data in databases
2 Providing common dataset functionality=Providing common dataset functionality
2 Interacting with the database=Interacting with the database
2 Surfacing datasets
3 Surfacing datasets=Surfacing datasets
3 Accessing all of your data through tables=Accessing all of your data through tables
3 Accessing a subset of data with queries=Accessing a subset of data with queries
3 Accessing data through a remote server's stored procedure=Accessing data through a remote server's stored procedure
1 Placing datasets in data modules=Placing datasets in data modules
1 Opening and closing datasets=Opening and closing datasets
2 Determining and setting dataset states
3 Determining and setting dataset states=Determining and setting dataset states
3 Understanding the dataset's Inactive state=Understanding the dataset's Inactive state
3 Understanding the dataset's Browse state=Understanding the dataset's Browse state
3 Understanding the dataset's Edit state=Understanding the dataset's Edit state
3 Understanding the dataset's Insert state=Understanding the dataset's Insert state
3 Understanding the dataset's SetKey state=Understanding the dataset's SetKey state
3 Understanding the dataset's CalcFields state=Understanding the dataset's CalcFields state
3 Understanding the dataset's Update states=Understanding the dataset's Update states
3 Understanding the dataset's Filter state=Understanding the dataset's Filter state
2 Navigating within datasets
3 Navigating within datasets=Navigating within datasets
3 Moving to the first or last record (First, Last)=Moving to the first or last record (First, Last)
3 Moving to the next or previous record (Next, Prior)=Moving to the next or previous record (Next, Prior)
3 Moving relative to the current record (MoveBy)=Moving relative to the current record (MoveBy)
3 Trapping beginning- and end-of-file conditions (Eof, Bof)=Trapping beginning- and end-of-file conditions (Eof, Bof)
3 Marking and returning to records (bookmarks)=Marking and returning to records (bookmarks)
2 Filtering datasets
3 Filtering datasets=Filtering datasets
3 Turning filters on and off=Turning filters on and off
3 Fine-tuning the filter=Fine-tuning the filter
3 Locating records in a filtered dataset=Locating records in a filtered dataset
3 Filtering datasets with the OnFilterRecord event=Filtering datasets with the OnFilterRecord event
3 Specifying a filter=Specifying a filter
2 Searching datasets
3 Searching datasets=Searching datasets
3 Moving the cursor to the located record (Locate)=Moving the cursor to the located record (Locate)
3 Returning values from a located record (Lookup)=Returning values from a located record (Lookup)
2 Modifying data
3 Modifying data=Modifying data
3 Editing records=Editing records
3 Editing entire records=Editing entire records
3 Adding new records=Adding new records
3 Deleting records=Deleting records
3 Posting data changes=Posting data changes
3 Canceling changes=Canceling changes
1 Accessing text files=Accessing text files
2 Using dataset events
3 Using dataset events=Using dataset events
3 Aborting a method=Aborting a method
3 Setting values of calculated fields with OnCalcFields=Setting values of calculated fields with OnCalcFields
1 Linking visual controls to datasets
2 Linking visual controls to datasets=Linking visual controls to datasets
2 Establishing a database-to-data-aware-control link=Establishing a database-to-data-aware-control link
2 Associating the data source with a dataset=Associating the data source with a dataset
2 Naming the data source=Naming the data source
2 Connecting to a dataset=Connecting to a dataset
2 Permitting automatic editing=Permitting automatic editing
2 Setting an integer value for programming needs=Setting an integer value for programming needs
2 Responding to data changes=Responding to data changes
2 Responding to updates=Responding to updates
2 Responding to dataset state changes=Responding to dataset state changes
1 Creating and using fields
2 Creating and using fields=Creating and using fields
2 Understanding field components=Understanding field components
2 Choosing between dynamic and persistent field generation
3 Choosing between dynamic and persistent field generation=Choosing between dynamic and persistent field generation
3 Benefits of dynamic field generation=Benefits of dynamic field generation
3 Benefits of persistent field generation=Benefits of persistent field generation
2 Creating persistent fields
3 Creating persistent fields=Creating persistent fields
3 Adding persistent fields=Adding persistent fields
3 Arranging the order of persistent field components=Arranging the order of persistent field components
3 Defining new persistent fields
4 Defining new persistent fields=Defining new persistent fields
4 Defining a data field=Defining a data field
4 Defining a calculated field=Defining a calculated field
4 Defining a lookup field=Defining a lookup field
3 Deleting persistent field components
4 Deleting persistent field components=Deleting persistent field components
2 Setting field properties and events
3 Setting field properties and events=Setting field properties and events
3 Setting display and edit properties of fields=Setting display and edit properties of fields
3 Creating attribute sets for field components=Creating attribute sets for field components
3 Associating attribute sets with field components=Associating attribute sets with field components
3 Removing attribute set associations=Removing attribute set associations
3 Working with field properties at runtime=Working with field properties at runtime
3 Handling field events=Handling field events
1 Working with field methods at runtime=Working with field methods at runtime
2 Displaying, converting, and accessing field values
3 Displaying, converting, and accessing field values=Displaying, converting, and accessing field values
3 Displaying values in standard controls=Displaying values in standard controls
3 Converting values=Converting values
3 Accessing values with the default dataset method=Accessing values with the default dataset method
3 Accessing values with a dataset's Fields property=Accessing values with a dataset's Fields property
3 Accessing values with a dataset's FieldByName method=Accessing values with a dataset's FieldByName method
1 Working with tables
2 Working with tables=Working with tables
2 What are table components?
3 What are table components?=What are table components?
3 Choosing between table and query components=Choosing between table and query components
2 Accessing all data with a table component
3 Accessing all data with a table component=Accessing all data with a table component
3 Specifying a database table=Specifying a database table
3 Specifying a table name=Specifying a table name
3 Specifying a table type=Specifying a table type
3 Opening and closing a table=Opening and closing a table
1 Creating a table programmatically=Creating a table programmatically
1 Controlling access to a table=Controlling access to a table
2 Searching for records
3 Searching for records=Searching for records
3 Moving the cursor to the first row matching search criteria=Moving the cursor to the first row matching search criteria
3 Returning values from rows that match search criteria=Returning values from rows that match search criteria
3 Moving among records that match filter criteria=Moving among records that match filter criteria
3 Searching for and moving to records based on indexed fields=Searching for and moving to records based on indexed fields
3 Working with a subset of data
4 Working with a subset of data=Working with a subset of data
4 Understanding the differences between ranges and filters=Understanding the differences between ranges and filters
4 Setting Range values=Setting Range values
4 Using Range values=Using Range values
3 Sorting records
4 Sorting records=Sorting records
4 Using secondary, or alternate, indexes=Using secondary, or alternate, indexes
4 Specifying sort order for SQL tables=Specifying sort order for SQL tables
4 Examining the field list for an index=Examining the field list for an index
1 Copying a table and its data=Copying a table and its data
1 Modifying data in a table=Modifying data in a table
1 Deleting records and tables=Deleting records and tables
1 Synchronizing tables linked to the same database table=Synchronizing tables linked to the same database table
2 Creating master-detail forms
3 Creating master-detail forms=Creating master-detail forms
3 Linking master and detail tables=Linking master and detail tables
3 Building an example master-detail form=Building an example master-detail form
1 Working with queries
2 Working with queries=Working with queries
2 Using queries effectively
3 Using queries effectively=Using queries effectively
3 Queries for desktop developers=Queries for desktop developers
3 Queries for server developers=Queries for server developers
1 What databases can you access with a query component?=What databases can you access with a query component?
1 Using a query component: an overview=Using a query component: an overview
2 Setting the SQL property
3 Setting the SQL property=Setting the SQL property
3 Specifying the SQL property at design time=Specifying the SQL property at design time
3 Specifying the SQL property at runtime=Specifying the SQL property at runtime
2 Setting parameters
3 Setting parameters=Setting parameters
3 Supplying parameters at design time=Supplying parameters at design time
3 Supplying parameters at runtime
4 Supplying parameters at runtime=Supplying parameters at runtime
4 Assigning values to parameters based on parameter name=Assigning values to parameters based on parameter name
4 Assigning values to parameters based on parameter order=Assigning values to parameters based on parameter order
3 Using a data source to bind parameters
4 Using a data source to bind parameters=Using a data source to bind parameters
3 Executing a query
4 Executing a query=Executing a query
4 Executing a query at design time=Executing a query at design time
4 Executing a query at runtime
5 Executing a query at runtime=Executing a query at runtime
5 Executing a query that returns a result set=Executing a query that returns a result set
5 Executing a query without a result set=Executing a query without a result set
1 Preparing a query=Preparing a query
1 Unpreparing a query to release resources=Unpreparing a query to release resources
1 Creating heterogenous queries=Creating heterogenous queries
2 Improving query performance
3 Improving query performance=Improving query performance
3 Disabling bidirectional cursors=Disabling bidirectional cursors
2 Working with result sets
3 Working with result sets=Working with result sets
3 Enabling editing of a result set=Enabling editing of a result set
3 Local SQL syntax requirements for a live result set=Local SQL syntax requirements for a live result set
3 Remote server SQL syntax requirements for a live result set=Remote server SQL syntax requirements for a live result set
3 Restrictions on updating a live result set=Restrictions on updating a live result set
1 Working with stored procedures
2 Working with stored procedures=Working with stored procedures
2 Using stored procedures=Using stored procedures
2 Accessing a stored procedure on a server=Accessing a stored procedure on a server
2 Understanding stored procedure parameters
3 Understanding stored procedure parameters=Understanding stored procedure parameters
3 Using input parameters=Using input parameters
3 Using output parameters=Using output parameters
3 Using input/output parameters=Using input/output parameters
3 Using the result parameter=Using the result parameter
3 Understanding input parameters=Understanding input parameters
3 Setting input parameters at design time=Setting input parameters at design time
3 Setting parameters at runtime=Setting parameters at runtime
1 Preparing and executing a stored procedure=Preparing and executing a stored procedure
1 Working with output and result parameters=Working with output and result parameters
1 Working with the result dataset=Working with the result dataset
1 Working with Oracle overloaded stored procedures=Working with Oracle overloaded stored procedures
1 Displaying and editing data in data-aware controls
2 Displaying and editing data in data-aware controls=Displaying and editing data in data-aware controls
2 Common data-aware control features=Common data-aware control features
2 Displaying and editing data in a data-aware control
3 Displaying and editing data in a data-aware control=Displaying and editing data in a data-aware control
3 Enabling mouse, keyboard, and timer events=Enabling mouse, keyboard, and timer events
3 Enabling editing in controls on user entry=Enabling editing in controls on user entry
3 Editing data in a control=Editing data in a control
3 Disabling and enabling data display=Disabling and enabling data display
3 Refreshing data=Refreshing data
1 Displaying fields as labels=Displaying fields as labels
1 Displaying and editing fields in an edit box=Displaying and editing fields in an edit box
1 Displaying and editing text fields in a memo control=Displaying and editing text fields in a memo control
1 Displaying and editing graphics fields in an image control=Displaying and editing graphics fields in an image control
2 Displaying and editing data in list and combo boxes
3 Displaying and editing data in list and combo boxes=Displaying and editing data in list and combo boxes
3 Displaying and editing data in a list box=Displaying and editing data in a list box
3 Displaying and editing data in a combo box=Displaying and editing data in a combo box
2 Looking up data for displaying and editing in list and combo boxes
3 Looking up data for displaying and editing in list and combo boxes=Looking up data for displaying and editing in list and combo boxes
3 Specifying a list based on a lookup field=Specifying a list based on a lookup field
3 Specifying a list based on a secondary data source=Specifying a list based on a secondary data source
3 Setting lookup list and combo box properties=Setting lookup list and combo box properties
1 Handling Boolean field values with check boxes=Handling Boolean field values with check boxes
1 Restricting field values with radio controls=Restricting field values with radio controls
1 Navigating datasets
2 Navigating datasets=Navigating datasets
2 Navigating and manipulating records=Navigating and manipulating records
2 Creating a navigator=Creating a navigator
2 Using a single navigator for multiple datasets=Using a single navigator for multiple datasets
2 Choosing navigator buttons to display
3 Choosing navigator buttons to display=Choosing navigator buttons to display
3 Choosing navigator buttons to display at design time=Choosing navigator buttons to display at design time
3 Hiding and showing navigator buttons at runtime=Hiding and showing navigator buttons at runtime
3 Displaying fly-over help=Displaying fly-over help
1 Displaying and editing data in grids
2 Displaying and editing data in grids=Displaying and editing data in grids
2 Viewing and editing data in grids
3 Viewing and editing data in grids=Viewing and editing data in grids
3 Changing a grid's default display
4 Changing a grid's default display=Changing a grid's default display
4 Creating persistent columns=Creating persistent columns
4 Removing persistent columns=Removing persistent columns
4 Ordering persistent columns=Ordering persistent columns
4 Defining a lookup list column=Defining a lookup list column
4 Defining a pick list column=Defining a pick list column
4 Putting an ellipsis button in a column=Putting an ellipsis button in a column
4 Setting column properties=Setting column properties
4 Setting column title properties=Setting column title properties
4 Restoring default column properties=Restoring default column properties
1 Controlling grid behavior and appearance=Controlling grid behavior and appearance
1 Editing in the grid=Editing in the grid
1 Rearranging column order at design time=Rearranging column order at design time
1 Rearranging column order at runtime=Rearranging column order at runtime
1 Controlling grid drawing=Controlling grid drawing
1 Handling grid events=Handling grid events
2 Displaying records like forms
3 Displaying records like forms=Displaying records like forms
1 Caching updates
2 Caching updates=Caching updates
2 How cached updates differ from transactions=How cached updates differ from transactions
2 Deciding to use cached updates=Deciding to use cached updates
2 Cached updates: an overview of the process=Cached updates: an overview of the process
2 Enabling and disabling cached updates=Enabling and disabling cached updates
2 Applying cached updates
3 Applying cached updates=Applying cached updates
3 Updating with a database component=Updating with a database component
3 Updating with a dataset component=Updating with a dataset component
2 Canceling cached updates
3 Canceling cached updates=Canceling cached updates
3 Canceling all updates=Canceling all updates
3 Canceling updates to the current record=Canceling updates to the current record
3 Canceling the most recently posted cached update=Canceling the most recently posted cached update
3 Undeleting a record=Undeleting a record
1 Checking update status=Checking update status
2 Handling cached update errors
3 Handling cached update errors=Handling cached update errors
3 Referencing the dataset to which updates are applied=Referencing the dataset to which updates are applied
3 Extracting an error message=Extracting an error message
3 Specifying the type of update that generated the error=Specifying the type of update that generated the error
3 Error handling=Error handling
3 Accessing the old and new values for a field=Accessing the old and new values for a field
2 Using prepared SQL statements to update a dataset
3 Using prepared SQL statements to update a dataset=Using prepared SQL statements to update a dataset
3 Creating update SQL statements=Creating update SQL statements
3 Executing update SQL statements=Executing update SQL statements
2 Creating an update event handler
3 Creating an update event handler=Creating an update event handler
3 Identifying the dataset to update=Identifying the dataset to update
3 Specifying how the current record was changed=Specifying how the current record was changed
3 Accessing a query component=Accessing a query component
3 Using an update component's SQL property=Using an update component's SQL property
3 Applying updates for the current record=Applying updates for the current record
3 Using parameter substitution=Using parameter substitution
3 Executing a prepared update SQL statement=Executing a prepared update SQL statement
2 Updating a read-only result set
3 Updating a read-only result set=Updating a read-only result set
3 Setting the UpdateObject property for a dataset=Setting the UpdateObject property for a dataset
1 Handling batch move operations
2 Handling batch move operations=Handling batch move operations
2 Using the batch move component=Using the batch move component
2 Specifying a batch move mode=Specifying a batch move mode
2 Transliterating character data=Transliterating character data
2 Mapping column data types=Mapping column data types
2 Executing a batch move=Executing a batch move
2 Handling batch move errors=Handling batch move errors
1 Upsizing and deploying an application
2 Upsizing and deploying an application=Upsizing and deploying an application
2 Upsizing, or migrating, a database=Upsizing, or migrating, a database
2 Upsizing an application=Upsizing an application
2 Moving data between databases on a one-time basis=Moving data between databases on a one-time basis
2 Deploying support for remote server access=Deploying support for remote server access