When you select a CursorAdapter in the Data Builder List and click the Edit page, you will see the CursorAdapter Properties page. Buttons at the bottom of the CursorAdapter Properties page allow you to access four utility functions: Browse, Create Schema, Data Sources and Rename.
Tip Ė Select Command: When a CursorAdapter is created or modified, the SELECT command is saved in the CursorAdapterís record in the SDATADDTV table. The SELECT command is displayed on the CursorAdapterís Data Builder Edit-Properties page for information purposes only. The SELECT command is also displayed on the Data Dictionary Report for the CursorAdapter.
Clicking the Browse button displays the records in the CursorAdapter in a read-only Browse form. The Browse utility is handy when you need a quick look at the CursorAdapter data.
Clicking the Create Schema button creates an XML schema file for the currently selected CursorAdapter. The file is created in the \Data directory of the current project. The XML schema file name is:
Class Library is the name of the class library that contains the currently selected CursorAdapter.
CursorAdapter is the name of the currently selected CursorAdapter.
When would someone want to create an XML schema file for a CursorAdapter? Well, an XML schema file can be helpful when you need to work with a CursorAdapter in VPME but do not have a connection to the data source that would allow you to use the CursorAdapter Builder to create the CursorAdapter Select command and schema. Further, in our example, letís say that you do not even know the structure of the data source that would allow you to create the CursorAdapter schema by hand.
If, on the other hand, a co-worker, named Steve, is in a location that allows him to make a connection to the data source, he can use the CursorAdapter Builder to create the schema. Then, Steve can use the Create Schema utility on the VPME Data Builder CursorAdapter Properties page to create an XML schema file and email the schema file to you.
You can then use the CursorAdapter Builder to build the CursorAdapter, and during that process, you can insert the contents of the schema file into the Schema edit box on the Data Access page. This saves you a good bit of tedious work that would be involved in creating the schema by hand, and of course, you did not even have the data source data structure that would have allowed you to create the schema by hand.
To learn how to use the Data Sources utility for CursorAdapters, go to Data Sources.
Clicking the Rename button displays the Rename dialog, which allows you to rename a CursorAdapter.