bindParameters

The bindParameters property in a business record relation binds a parameter with a value.

The bindParameters property defines a list of optional parameter-value pairs used to replace question mark (?) placeholders in an SQL query .

In each pair the name of the parameter is for information and only the order matters. The value is either the field from the master record or all ancestor records according to specific rules. This value can be empty.

When a query contains question marks, a bind parameter must be defined for each ? to assign it a value. These question marks can be found in the WHERE clause of the Join Builder dialog or at any place in the custom query. Additional question marks may appear in the code and the bindParameters property must be used for each.

Rules defined for whereParameters must also be used for bindParameters.