NEW4.01.01 · Released 24 June 2024

NEWfinPOWER Connect

Released in

4.01.01

24 June 2024

1. Opened9 May
2. Closed9 May
3. Released24 Jun

Article 21426 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.