Create a DataView from a Standard Range.

User Filters for Clients, Accounts etc will be respected.

Syntax

finUtilities.CreateDataViewFromStandardRange(standardRange, sqlWhere, includeInactive, target, dataView, idField, descriptionField, fieldList, [alwaysIncludeId], [globalCollection])

Parameters

NameTypeOptionalByRefDescription
standardRange isefinStandardRange The Standard Range.
sqlWhere String An SQL Where clause to filter by. Depending on whether this Standard Range is based on a global collection or not this may filter either the DataView itself or be applied when querying the database.
includeInactive Boolean Indicates whether to Include Inactive records. This will be ignored if it is not applicable to a particular Standard Range.
target iseCollectionDataViewTarget The Target that this DataView is being used for. This will afect the fieldList returned.
dataView DataView ByRef The DataView.
idField String ByRef The Id Field ie. the Field used to uniquely identify a record.
descriptionField String ByRef The Description Field ie. the Field used to display along side the Id Field.
fieldList ISList ByRef A List of Fields to display based on the target.
alwaysIncludeId String Optional The Id of a record to include regardless of whether it is inactive (if the concept of 'Inactive' records applies to this Standard Range).
globalCollection I_ISCollectionDataView Optional ByRef If omitted, a value of Nothing is assumed.

Return Value

Boolean

A Boolean value indicating success.

Member of:
finUtilities
Namespace:
Intersoft.finSupport6
Assembly:
finSupport6, Version=6.0.3
Target Framework:
.NET 9.0