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.