How Do I Manually Map a Browse Page to the Database without using an Integrator?

Answer

You can bypass an Integrator to connect a Browse Page to the database:

1. Click Browse Page –> Option –> EditPage and click DataSource in the Browse Page Editor window (see screenshot attachment)

2. Add the following code to the Browse Page OnLoad method:

public object BrowsePageName_OnLoad()
{
return customSetting.Value(process.Company, @"Connections\<DatabaseName>");
//Example: return customSetting.Value(process.Company, @"Connections\CasperOLEDB");
}

3. In the Query field of the Browse Page Editor window, enter the database query to populate the Browse Page with data:

Example: SELECT [Airline], [FrequentFlyerNo] FROM [Casper].[dbo].[vw_trEmpFreqFlyer] where [EmpID] = ‘aObjects(“TR10EmpId”)’

In this example, ‘aObjects(“TR10EmpId”)’ represents a control value on the form which is used as a parameter

4. Manually set up Page Objects with the fields returned by the query.