Article Details

Id:	11312
Product:	finPOWER Connect
Type:	FIX
Version:	2.00.00
Opened:	03/07/2013
Closed:	20/08/2013
Released:	04/10/2013
Job:	J011786
Breaking Change

ISSQLWhereBuilder; BlockBegin 'notBlock' option not working as expected

When using the BlockBegin method of the ISSqlWhereBuilder object (e.g., as part of the SqlWhere clause in an ISSelectQueryBuilder) and specifying that the block should be a NOT block, the SQL WHERE clause generated was not as expected. It simply put 'NOT' in front of each item in the SQL WHERE clause instead of a NOT in front of the entire contents of the block which was what was expected.

NOTE: Although this is not used internally within finPOWER Connect, it has been flagged as a breaking change since any Scripts or external applications using this functionality will need to be reviewed and updated if necessary.