Initializing help system before first use

SQLfiltarr

Description
This parameter changes the behaviour of SQLexecute when this routine is applied to a list of at least 2 arrays: in this situation, if the parameter is true, the first array of the list is retained and not used for the query. In the case of an output query this array is used as a filter to select the elements to be exported ( i.e. only index tuples defined by this dynamic array are considered, the type of the array does not matter). When performing an input query this filtering array is ignored.
Type
Boolean, read/write
Values
true 
Enable array filtering.
false 
Disable array filtering.
Default value
false
Affects routines
Module

© 2001-2025 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.