Write Data Access Applications with the Visual Builder

Visual Builder handles Data Access parts the same as it handles any other type of part. To create a Visual Builder application that can access a database, create the necessary Data Access parts by using Data Access Builder, and then load the needed parts into Visual Builder. The generated Data Access Builder parts are automatically Visual Builder-enabled.

Data Access Builder also provides some classes that you can use directly in applications, without generating any code. Load them into the Visual Builder to use in data access applications. All of these files are located in the include directory of the install image. The following Data Access .vbe files are provided:

Two "connect canvas" parts are provided, also in the include directory. Drop one of them on your Visual Builder application when you want to have a dialog that lets the user connect to a database. Code for these parts is generated by the Visual Builder. The following Visual Builder parts are provided:

ngaix.gif (1051 bytes)The vbload.dat File
Create a file called vbload.dat in your project's working directory. In this file, list all the .vbe and .vbf files that the Visual Builder needs to load in addition to the base parts that it automatically loads.  List all Data Access parts from the include directory:

usr/vacpp/include/IDS.vbe
usr/vacpp/include/IDSB.vbe
usr/vacpp/include/IDSBCLI.vbe
...and so on.
usr/vacpp/include/idsccabs.vbf
usr/vacpp/include/idsconcv.vbf

Then list all the generated parts from the mapping you created.  For example, if the mapping was called Dept, then the list of files would look like this:

Dept.vbe
DeptDataId.vbe
DeptDataIdManager.vbe
DeptDataIdManagerBase.vbe
DeptDataIdManagerTemplate.vbe
DeptDatastore.vbe
DeptForm.vbf
DeptManager.vbe
DeptManagerBase.vbe
DeptManagerTemplate.vbe

Then start Visual Builder from the working directory with the command ivb.   The list of loaded parts will show all of these parts from the vbload.dat file.

Each time you generate a new .vbe or .vbf file for the project,  update vbload.dat with the file name so each time you start Visual Builder, the file is automatically loaded.

Data Access/Visual Builder Tutorial
Creating a Visual Data Access Application - Follow the instructions in this tutorial to create a basic data access application visually, by using some of the parts described above.



Data Access Builder Workflow


Data Access Class Library and Generated Code
Data Access Builder Samples
Sample: Use the Generated Code with the Visual Builder