home *** CD-ROM | disk | FTP | other *** search
Microsoft Windows Help File Content | 1997-02-28 | 25.3 KB | 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 
(.txt)