BV_SOURCE
= optional in PARAM sheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Value in col D (example) | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|
FORMS | REPORT | |||||
BV_SOURCE |
| n/a | <view name> or <temp table> | n/a | 1
| Use an alternative source when fetching data from Bizview. Only applicable for fetching data, not updating. |
BV_SOURCE is a FORM specific parameter that can be stated to use an alternative source when fetching data from the Bizview database. The default view used when fetching values from Bizview is cust.v_$CLIENT_data_cells (from Bizview 5.1 a generic procedure, #plandata, is used instead). Although, in some cases another view/temp table may need to be used. This parameter can only be used for fetching values. Updated values will always be saved to the default data cells table in Bizview.
Caution: The alternative view or temp table defined for this parameter must be saved in the Bizview database. If a temp table is used, then the procedures creating the temp table must be defined in the Template in the Events tab.
Access this parameter from Template Design by selecting Parameters > Frequently Used > BV SOURCE > Alternative source/table to fetch values to form.
Choose a View name (including schema) or temp Table name:
The alternative view defined in the example above will be used for this form when the program inserts already saved data. When updating values to the database from this form, values will be saved in the default Bizview data cells table.