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

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

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