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

How Can We Help?

< Back

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)
  1. 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");
}
  1. 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

  1. Manually set up Page Objects with the fields returned by the query.
Comments are closed.

This is the legacy version of the XMPro Documentation site. For the latest XMPro documentation, please visit documentation.xmpro.com

X