You can import a schema definition from any of the following sources:
- A database connected to the current project
- A valid XSD file generated by means of the ABL function WRITE-XMLSCHEMA
- An ABL source file containing a schema definition, such as a ProDataSet
You have the option of either adding the imported schema to the current schema definition, or replacing the current definition with the imported one.
To import a schema definition:
- Open the ProBindingSource Designer. You can do this by drag-and-drop or by using the Toolbox, as described in the two preceding sections; or you can edit an existing binding source object.
- If you want to add an imported schema to the current schema definition, in the tree view in the Tables pane, select the table that is to be the parent of the imported schema.
-
Click
to import from a connected database, or click
to import from a file.
- If importing from a database, select the desired schema elements.
- If importing from a source file, browse to and select the file.
- The database schema appears in the Available Schema pane on the ProBindingSource Designer.
- In the Available Schema pane, select tables and columns that you want to add to the current schema definition.
- Click Add. The selected tables appear in the Tables pane and the columns in the Fields pane. You can define a recursive relation between tables in the current schema definition.
- The schema defined using the ProBindingSource Designer appears as a ProBindingSource object in the Design Canvas.