Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

BV_SOURCE

Caution: BV_SOURCE has been deprecated.

Optional parameter in PARAM= 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

Optional parameter in PARAM

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.

Published:

BV_SOURCE

Caution: BV_SOURCE has been deprecated.

Optional parameter in PARAM= 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

Optional parameter in PARAM

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.

For an optimal Community experience, Please view on Desktop
Powered by Zendesk