AccpacDBLink.ParamGet

Gets the values of the specified field IDs from the first record of the specified view.

Function ParamGet(
  ViewID As String,
  FieldIDs as Variant) As Variant

Parameters

ViewID

[in] the Roto ID of the view whose field values (for the first record) are to be returned

FieldIDs

[in] an array of field IDs (array of Longs)

Return Value

Returns an array of variants containing the values of the requested fields in the view's first record. The values are returned in the same order as requested field IDs as they appear in the FieldIDs array.

Remarks

This method is applicable only to views that are designed to store parameters of an application. These views typically have one and only one record. Internally, this method opens the specified view, fetches the first record, and returns the values of the specified field IDs.

In a networked environment, this method is more efficient than manually opening a view, and then fetching and obtaining field values, since this method only takes one network call and all processing is done on the server.

Unlike the BlkGet method of the DataSource control, this method will access the view's values rather than cached values.