Creating a Data Block from a Table
To create a data block from a table:
- Choose Tools | Data Block Wizard to invoke
a wizard that guides you through the process of building a data block
Or,
- In the Object Navigator, click the Data Blocks
node.
- Click Create in the toolbar.
- In the New Data Block dialog box, choose Build a New
Data Block Manually and click OK.
- Double-click the Block object icon to display the Property Palette.
- Under the Database node:
- Set the Query Data Source Type property to Table.
- Type the name of a database table in the Query Data Source Name text
box.
- Under the Advanced Database node, set the DML
Data Target Type property to Table.
- Type the name of your datasource in the DML Data
Target Name text box.
- Under the General node, click the Name property,
then type a name or accept the default name. You can use any name that
follows ORACLE naming conventions and is unique among blocks in the form.
The block name is an internal descriptor that is not displayed at runtime.
Related topics
Database Block property
DML Data Target Type property
DML Data Target Name property
Query Data Source Type property
Query Data Source Name property
Connecting to a database
About creating items
Creating a Data Item
Creating a control item
Using tables as block datasources