ii
Using parameters. . . . . . . . . . . . . . . .5-27
Re-executing the parameterized query
with new parameters . . . . . . . . . . . .5-29
Binding parameters . . . . . . . . . . . . . .5-29
Parameterized queries in master-detail
relationships. . . . . . . . . . . . . . . . . .5-30
Obtaining data through a stored procedure . .5-30
Tutorial: Accessing data through a
stored procedure . . . . . . . . . . . . . . .5-31
Creating tables and procedures for
the tutorial . . . . . . . . . . . . . . . . .5-32
Adding the DataSet components . . . . .5-32
Adding visual controls . . . . . . . . . . .5-33
Discussion of stored procedure escape
sequences, SQL statements, and
server-specific procedure calls . . . . . . .5-34
Creating tables and procedures for
the tutorial manually. . . . . . . . . . . . .5-34
Example: Using InterBase stored
procedures . . . . . . . . . . . . . . . . . .5-36
Example: Using parameters with
Oracle PL/SQL stored procedures . . . . .5-37
Using Sybase stored procedures . . . . . . .5-38
Browsing sample applications that
use stored procedures . . . . . . . . . . . .5-38
Writing a custom data provider . . . . . . . . .5-38
Obtaining metadata . . . . . . . . . . . . . .5-39
Invoking initData . . . . . . . . . . . . . .5-40
Obtaining actual data . . . . . . . . . . . . .5-40
Tips on designing a custom data
provider . . . . . . . . . . . . . . . . . .5-40
Understanding the provideData
method in master-detail data sets . . .5-41
Working with columns . . . . . . . . . . . . . .5-41
Column properties and metadata . . . . . .5-41
Metadata and how it is obtained . . . . .5-42
Non-metadata column properties. . . . .5-42
Viewing column information in the
Column Designer . . . . . . . . . . . . .5-42
Using the Column Designer to persist
metadata . . . . . . . . . . . . . . . . . .5-43
Making metadata dynamic using
the Column Designer . . . . . . . . . .5-44
Viewing column information in the
JDBC Explorer . . . . . . . . . . . . . . .5-44
Optimizing a query . . . . . . . . . . . . . . . .5-45
Setting column properties . . . . . . . . .5-45
Persistent columns . . . . . . . . . . . . .5-46
Combining live metadata with
persistent columns. . . . . . . . . . . . 5-47
Removing persistent columns . . . . . . 5-47
Controlling column order in a
DataSet . . . . . . . . . . . . . . . . . . 5-48
Chapter 6
Saving changes back to
your data source 6-1
Saving changes from a QueryDataSet . . . . . . 6-2
Saving changes back to your data source
with a stored procedure . . . . . . . . . . . . . 6-5
Tutorial: Saving changes with a
NavigatorControl . . . . . . . . . . . . . . . 6-5
Coding stored procedures to handle
data resolution . . . . . . . . . . . . . . . . . 6-7
Tutorial: Saving changes with a
ProcedureResolver. . . . . . . . . . . . . . . 6-8
Example: Using InterBase stored
procedures with return parameters . . . . 6-10
Resolving data from multiple tables . . . . . . 6-10
Considerations for the type of linkage
between tables in the query . . . . . . . . 6-11
Table and column references (aliases)
in a query string . . . . . . . . . . . . . . . 6-12
Controlling the setting of the column
properties. . . . . . . . . . . . . . . . . . . 6-12
What if a table is not updatable? . . . . . . 6-12
How can the user specify that a table
should never be updated? . . . . . . . . . 6-12
Streaming data . . . . . . . . . . . . . . . . . . 6-12
Example: Using streamable data sets . . . . 6-13
Using streamable DataSet methods . . . . . 6-13
Customizing the default resolver logic . . . . . 6-14
Understanding default resolving . . . . . . 6-15
Adding a QueryResolver component . . 6-15
Intercepting resolver events . . . . . . . 6-16
Tutorial: Using resolver events . . . . . . 6-17
Writing a custom data resolver . . . . . . . 6-18
Handling resolver errors . . . . . . . . . 6-18
Resolving master-detail relationships . . 6-19
Chapter 7
Establishing a master-detail
relationship 7-1
Defining a master-detail relationship. . . . . . . 7-2
