Article Details
Id:21426
Product:finPOWER Connect
Type:NEW
Version:4.01.01
Opened:09/05/2024
Closed:09/05/2024
Released:24/06/2024
Job: J033444

Business Layer; ISSelectQueryBuilder; Ability to append a numeric "IN" clause to the SQL Where

The ISSelectQueryBuilder object's .SqlWhere property has an .AppendIn() method.

This method receives a CSV list of values. Prior to this change, these values were always assumed to be String values and therefore quoted when generating the IN clause.

A new listIsNumeric optional parameter (False by default) can be passed as True to bypass this automatic quoting of values.