CreateSqlWhereForStandardRange Method

Member of finUtilities
Create an SQL Where clause to use for Standard Ranges that are read from the database, e.g. Accounts, Clients, Security Statements.

The additionalSqlWhere will be returned if the Standard Range is not to be read from the database, e.g. it comes from a global collection.

Syntax

finUtilities.CreateSqlWhereForStandardRange(standardRange, includeInactive, additionalSqlWhere, [alwaysIncludeId])

Parameters

NameTypeOptionalByRefDescription
standardRange isefinStandardRange The Standard Range.
includeInactive Boolean Indicates whether to include Inactive records where applicable.
additionalSqlWhere String The existing SQL Where clause to append to.
alwaysIncludeId String Optional The Id of a record to include regardless of whether it is inactive (where applicable).

Return Value

String

A String value.

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